DRILLTHROUGH in report server

Dear all,

Please help to create DRILLTHROUGH in a report server project. I am a beginner . I want the DRILLTHROUGH featrure in Report server like same as that of analysis server project

Please help

regards

Polachan

go to the textbox or the field, where you want to drill throught to another report by clicking on it.

right click and go to the properties

Use Navigation tab

there go to Hyperlink action and select the second option "Jump to the report" and select the report in the dropdown box

|||

Thank u Suresh

Now I got . Still I have one doubt how can we go to previous screen from the drill down. Please give me ...

Suresh where is ur place .. I am from Kerala now I am working in NI , UK

Regards

Polachan

DRILLTHROUGH in report server

Dear all,

Please help to create DRILLTHROUGH in a report server project. I am a beginner . I want the DRILLTHROUGH featrure in Report server like same as that of analysis server project

Please help

regards

Polachan

I assume you are having problems with the query. There is a "bug" in SSRS that I logged here http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126175 and there is also a work around listed on this site.

If you are just after a sample, Nick Barclay has one on his blog here: http://nickbarclay.blogspot.com/2006/03/ssrs-mdx-drillthrough-gotcha.html