Post reply

SSRS URL Paramter Value does not match with report parameter Values

  • October 8, 2010 at 6:03 am

    #224832

    Hi,

    We have rdl report and passing a multiple paramter values through URL. When the passed values exists in report parameter values then report displayes properly.

    But when we pass the values through URL which doesn't exists in report parameter value then it throws an error saying parameter value is missing.

    The reports db and the application db through which we display the reports are different. how do we address this issue.

    pls help.

    regards, hari.

  • October 8, 2010 at 7:09 am

    #1234232

    Do you have an example url that won't process correctly that you can post so we can see what you are talking about?

  • October 8, 2010 at 7:18 am

    #1234237

    We are passing the following script to response.write which is opening a popup window to show the report.

    <script type='text/javascript'>detailedresults=window.open('http://xx.xxx.xxx.xxx:xxxx/ReportServer/Pages/ReportViewer.aspx?%2fFMIS+Reports%2fHHTS&rs:Command=Render&Location=KAF Main BFI&Location=KAF Retail&Location=KAF Retail BFI&rc:Parameters=True', 'eTIMS', 'toolbar=0,location=0, directories=0, status=0, menubar=0,scrollbars=1,resizable=1,width=1014,height=714,left=0,top=0,addressbar=0');</script>

    The report has two datasets, one is for the report and another one is for parameter values.

    In the above parameters the values "KAF Main BFI" and "KAF Retail BFI" has data for the report and "KAF Retail" doesnot have the data. So it throws parameter is missing a value.

    Thanks in advance.

    regards,

    hari.

  • October 8, 2010 at 10:40 am

    #1234383

    So one of your databases has the value "KAF Retail" and the other does not? I would work on getting the databases in sync not troubleshooting the report.

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

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