Home Forums Reporting Services Reporting Services SSRS cube report with parameters...and more RE: SSRS cube report with parameters...and more

  • April 10, 2014 at 2:32 pm

    #1705048

    scottcabral (4/10/2014)

    SSC Journeyman,

    I guess it could be. I was thinking of creating each report as a separate rdl file and then combining them into 1 report based on the inputs from the parameters.

    Is there a better way of doing it? do you think creating separate pages on 1 report and then somehow making them visible/hidden based on parameter inputs?

    thanks

    Scott

    Scott, see this article I wrote on creating a basic SSRS report. http://sqlsaga.com/ssrs/how-to-create-a-basic-ssrs-report-with-parameters/[/url]

    I haven't created a cascading filter there.. Try this article to know about cascading filters.. http://www.msbiguide.com/2012/02/adding-cascading-parameters-to-ssrs-reports/[/url]

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.