February 20, 2015 at 5:48 am
Hello
I've encountered a really strange error with Reporting Services that's I'm hoping you guys can help with. I have a Report that I use as a Report Menu, this report linked to other reports using the action property (so users can get to all reports from one Report). however when they click on a link it isn't prompting the user to pick the parameters of the report its just erroring, saying no parameters was entered.
It trying to execute the report straight away without the parameters. On the Report Service I have checked that the report report has the parameters Set to Prompt User and the strangest thing of all is that If I run this locally in BIDS its working as intended; that is prompting the user for the parameters before running the report (like the Report Server version should do).
I have used this solution before and know it works but don't know why it isn't now.
This is using SSRS 2005. Any help would be greatly appreciated
Thanks
February 23, 2015 at 6:17 pm
Hey dude, did you assign the parameters to the drill through report while defining it in the action section? If not, then click 'ADD' and you will get the options to assign fields to the parameters of the drill through report.
February 25, 2015 at 3:16 pm
I'm experiencing the same thing he has reported.
These sub-reports (that have parameters) have default parameter values, and the action I'm seeing, is the top menu, slides right into the 2ndary report using those defaults and generates the report.
That's all the consumer gets to do - generate a report of the default parameters.
The parameters fields (located at the top) are not visible to choose anything and regenerate another report....
OR -
The 2nd (sub) report never shows the parameter fields to the consumer.
Usually after generating the default values for the report (using the default parameter values) the consumer can change those default values and re-generate a custom report.
Now the action just dies, as the Report Server gives the consumer just the defaults, and that's it.
The consumer's choices after generating the report are to back up to the calling menu report (period).
Usually, they can customize their report using these real-time parameters, after the 1st pass and do multiple report generations via tweaking the parameters.
These options are available and active - if the consumer drills right into the sub-report itself, and ignores the top menu report.
This is the first I've seen this situation.
Thanks-
February 26, 2015 at 8:16 am
Just discovered,
the called SSRS report (with parameters), has the parameters pane object collapsed.
Doing so, does not allow the user to click and re-generate a new report with non-default parameters.
Need to see how to control (force a expand property) on this object from an object that can tell the report to expand or collapse this object.
February 26, 2015 at 8:46 am
Thanks for the replies, I don't want the structure report to pass values to the unlying report I want it to prompt the user to select the parameters an then run. The parameter pane is also not collapsed its just not there the report is executing as soon as its opened rather than asking user for parameters.
This works fine locally and in SSRs 2008 but not in 2005 🙁
February 26, 2015 at 9:34 am
For your situation, check the 'default' parameter values to see they haven't been assigned.
Mine have and is a 1-off.
I've read that in visual studio 05 there is a snap-in wrapper to control the properties of the Report Viewer...
Initially, I built my series of reports using Visual Studio with a Report Designer snap-in, where the parameters stopped the report viewer from generating the report - because I hadn't assigned default parameter properties.
But then switched to just developing within Report Builder and didn't use the menu concept until last night where I found the different behavior slide right passed the parameters because they had been assigned.
Thanks and good luck...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply