December 1, 2011 at 7:13 am
I have a query in my report like this.
SELECT T1.A1,T1.A2,T1.A3,T1.A4,T1.A5,T1.A6,T1.A7,T1.A8,T1.A9,T2.B1,T2.B2 FROM T1
INNER JOIN T2 ON T1.A9 = T2.B3
LEFT OUTER JOIN T3 ON T1.A10 =T3.C1D
i have row groups on A2,A3,A4,A5 and column group on A6. Now I have to make drill down on A1(country name) and after trying every technique it's not coming.
Can some one help in my case.
Thanks
December 1, 2011 at 7:27 am
Have you thought of navigating to a second "drilldown" report? It's much easier to maintain and change than nesting everything together. You can also get much more intricate this way. I have a report that has 7 drilldown reports with options on the drilldowns like drilling down on company I have a selection "report" for the user to choose region, district and department. Fun stuff.
December 1, 2011 at 7:36 am
I have not tried in your way before. Can you please tell me how to use your method in my report. A1 (country name) which I add latter so that I can create drill down on A1.
December 1, 2011 at 12:05 pm
In properties of a text box there is a tab called Navigation. There is a "Jump to report:" hyperlink action where you can name a report you want the user to seamlessly go to passing parameters. When the user clicks on a field in any row, the data in that row is available for parameter passing.
Does that help?
December 1, 2011 at 12:56 pm
I am using SSRS 2008 version.
December 1, 2011 at 1:44 pm
SSRS 2008 doesn't have a "Jump to report" option? How does it navigate from one report to another? That is the feature you need to employ if you use my solution.
December 1, 2011 at 1:48 pm
There is an action selection in the left column of the properties box for a text box. It refers to the option as a hyperlink (which it actually is). A little different wording than the 2005 SSRS but does the same thing.
December 1, 2011 at 2:18 pm
First of all no drill down option is coming up. But yes if I click on column it is navigating to same page.
What if I select multiple values of parameter.
Can you please provide steps for this so that I can use this in my report.
Thanks
December 1, 2011 at 3:12 pm
With the report in the Visual Studio right click on the field you want your user to use to get to the drilldown report. You will get up a box with Action in the left column. Click on that and in the next box select go to report, or something like that - I don't remember right now. You will then name the report you want the user to go to and select the parameters and fill in the params the drilldown report will need to properly show the drill down data. Then when the user clicks on that box, no matter which line is selected, that line's data will be available for you to pass on through parameters to your secondary report. You can include additional parameters depending on the requirements of the report you are navigating to such as parameters used to create the top report, fields in the line clicked on, calculated values, etc. Obviously you have to have created the drill down report independently and identified the parameters in that report and use them in that report's query to retreive the proper data for reporting. It's really simple if you think when you are creating the secondary report that it could be a primary with parameters for selecting the data, etc. I alway choose to hide the report so it doesn't confuse the users. Then when the user selects the top, or primary report, and the drilldown is requested, the user should only have to click on that field you have selected as the link between the top and secondary report. Have I been to detailed or not enough?
December 2, 2011 at 7:05 am
Thanks for detail steps.
I will work on that and let you know if I get some problem.!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply