Hi Friends,
I am very new to MSSQL Reporting service 2005. I wanted to create a drithrough report. I have created a master report using a cube created using MSSQL Analysis service 2005. The master report contains a column called 'Territory', which details some other columns also. My child report contains the same 'Territory' column, but with displays some other detailed information. If I click on the territory column data on master report, it should take me to child report where it should show only Territory which matches with the master territory.
I have created both master & child reports. In my master report, Jump to Report, I have given the name of my child report. In my child report, if I have created a hidden parameter by providing available value through query. But while clicking the territory column master report I'm getting error parameter xxx is missing a value. If I uncheck as hidden parameter it pops up for the value & it works.
How to go about it, can someone help?
Thanks & Regards,
Naveen J V
Hi,
Its a long time ago as I had built my last report - but at the Jump to Report there is also a part where you map the Target Report Paramter to something of your current Report. There you have to specify the value for Target Report Parameter - your current Territory.
If you not specify the paramters it get set to the default parameter of null - which seems to be not allowed for your parameter.
It looks like this is more related to report server - I recommend you to post your question there if my hint does not help.
Mabe someone from MS moves it to the report server forum.
Best Regards
Hannes
No comments:
Post a Comment