Drillthrough Report - Default Parameter
-
Tuesday, February 19, 2013 10:38 PM
I have a report (main report) that allows users to go to another report (drillthrough report) when they click on a link. The main report will pass some, but not all, of the parameters for the drillthrough report to use. The thing is that a parameter in the drillthrough report does not have a default value and is meant for the user to specify once they get to the drillthrough report.
However, doing this causes an error message to be displayed when the user clicks on the link:
"The 'parameterName' parameter is missing a value."
It is supposed to be missing a value because user is supposed to choose the value for that parameter instead -- per business rule, a default value for that parameter should not be chosen by default.
So yes, the report parameters do show up and function correctly, and the report does pass the other parameters as it is supposed to. However, how can I make the report show the default "Specify Parameters Values" instead of the error message when the user clicks on the report link from another report?
Note: Another option is to have the Action "Go to URL" instead -- but using this option does not allow me to pass on the other parameters dynamically (or at least not that I know of). So if there is a way to pass the parameters dynamically (based on the main report's parameters) through URL, please do share.
Thank you in advance!
*Edit: This is utilizing Report Builder 3.0 for SQL Server 2008 R2 on SharePoint 2010.- Edited by yosedesh Wednesday, February 20, 2013 12:11 AM
All Replies
-
Wednesday, February 20, 2013 4:02 AM
http://msdn.microsoft.com/en-us/library/aa337477(v=sql.105).aspx
This link here statest "If the drillthrough report has parameters, you must pass parameter values to each report parameter"
So I am thinking they might work like a subreport where you have to specify a value for each parameter.
-
Wednesday, February 20, 2013 4:04 AM
Perhaps you can do it slightly differently using a URL, so that you dont get the problem you are having?
http://msdn.microsoft.com/en-us/library/ms152835(v=sql.105).aspx
-
Wednesday, February 20, 2013 6:36 AM
I'm hoping that there is a way to not have to specify all of the parameter values since only some will need to be passed and the user should select whatever parameters do not have a default value specified. The report still works and the parameters function correctly... but the error message will turn some people off and I wish there is away to just have the regular "Specify Parameters Values" message to display instead of the error message.
I've already looked at the 2nd link that you've sent. Unfortunately, I don't know how to pass the report parameters dynamically if I use the URL. It seems that the tutorial only shows hard-coded parameters which wouldn't be helpful in this case.
-
Tuesday, February 26, 2013 4:34 AMModerator
Hello,
Based on your description, I can reproduce the issue in my test environment. When I run the report from report server using Report Viewer, the error message is disappear. It seems this behavior is happened only when using the Report Viewer Web Part on a SharePoint Site.
Personally, I recommend you that submit a feedback at https://connect.microsoft.com/SQLServer/. Your feedback is valuable for us to improve our products and increase the level of service provided.
If you want to pass the parameter value through URL, please referto the following expression:
="http://servername/ReportServer?/Reportname&rs:Command=Render&Group="& Parameters!Group.Value &"&Country=" &fields!SalesTerritoryCountry.Value &"&Year=2002”Regards,
Fanny LiuFanny Liu
TechNet Community Support
- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Tuesday, February 26, 2013 9:44 AM
- Marked As Answer by yosedesh Tuesday, February 26, 2013 10:20 PM
-
Tuesday, February 26, 2013 10:20 PM
Thank you for your help, Fanny!
I have submitted a feedback regarding this: https://connect.microsoft.com/SQLServer/feedback/details/780059/drillthrough-report-with-no-default-parameter
The current workaround is dynamically passing some of those parameters through the URL. This has helped me a bit as well (in regards to using the rv and rp):
="http://<SharePoint_site>/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/<SharePoint_Document_Library>/<Report_Name>.rdl&rp:Month=" & Parameters!PTest.Value
However, I have found that linking it this way seems to take more time for the server to process and render for some reason. It still would have been nice to not have to do the workaround.
.png)
