Wednesday, March 28, 2012

Problem in Drillthrough report

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