Post reply

Passing parameters in linked reports

  • July 17, 2008 at 11:37 pm

    #184899

    Hi,

    I am facing a problem when i create linked report.

    I have a parent report which displays 'Region' as hyperlink. When i click on any region my report gets drilled down to sub level i.e. country.

    The problem that i am facing is that after selecting any region and then creating the linked report. Though the linked report gets created but my parameter i.e. region is not stored. The linked report displays all the regions where as the ideal behavior would be to display details of only selected region.

    Any suggestions in this regard will be of great help

  • July 17, 2008 at 11:55 pm

    #844791

    Hi Fayez,

    Are you passing the parameter to drill report?

    You need to pass the field value where you want to click.

    e.g. in navigation window YourParameter = Fields!Region.Value

    And one more thing, there should be a parameter for region in your drill report.

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • July 18, 2008 at 12:05 am

    #844795

    Hi Hari Narayan Sharma,

    Thanks for your reply.

    The problem is not the drilldown. The report is drilled down with correct parameters. But the problem is when i create a linked report the previuos parameter is lost. I will explain it with the help of an example

    My report has region as first level on navigation, country as second level as so on. I click on any region, report gets drilled down to countries under that region. Now i go to properties and select option 'Create Linked Report', the linked report gets created but it displays me all regions where as it should display only countries that come under the previous selected region.

    regards,

  • July 18, 2008 at 8:26 am

    #845097

    Hi Fayez,

    Does your linked report MDX / SQL is driven by the Parameter "Region"? I guess its not there and hence you are getting everything. You need to create the Region parameter which will be slicing your cube or SQL to get only the subset of data you are looing for.

    Regards

    Amber

  • July 18, 2008 at 8:32 am

    #845101

    My report is SQL driven. Every parameter is there and gets passed successfully on drilldowns. It is just when i create a linked report with some previous selected parameter e.g region, the linked report does not save the parameter insted displays all the details

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply