dbaSQL
asked on
drill-through report, SSRS
I want to enable a drill-through report in SSRS.
The first report would be just daily sales, like this:
ApplicationDate TotalLoanAmount
03/14/2011 42350.00
03/13/2011 7525.00
03/12/2011 5700.00
03/11/2011 35625.00
03/10/2011 36975.00
03/09/2011 36650.00
03/08/2011 33100.00
Where it is the max applicationdate available, minus 6 days, so that this first little report will always return seven days of data.
At this point, I would like the user to be able to click any date, and pull up the details for the loans applied for on the selected date. Basically, pick the date from the list above, and return detailed information from the date selected.
I've created both reports, and I've enabled an Action on the date value in the text box properties, to 'go to report', where my larger, more detailed report is the selected report.
It works, in that it opens the other report. But, all of the dates of data are shown, not just the one that was selected in the first report.
I don't want a user to have to input anything. When he/she opens the report, I want them to see that daily count that I've posted above, and then be able to select a date in the list. That selected date will somehow be passed into the larger, detailed report, as a @applicationdate parameter, and the detailed applications for the selected date will be returned.
Very important, please advise.
The first report would be just daily sales, like this:
ApplicationDate TotalLoanAmount
03/14/2011 42350.00
03/13/2011 7525.00
03/12/2011 5700.00
03/11/2011 35625.00
03/10/2011 36975.00
03/09/2011 36650.00
03/08/2011 33100.00
Where it is the max applicationdate available, minus 6 days, so that this first little report will always return seven days of data.
At this point, I would like the user to be able to click any date, and pull up the details for the loans applied for on the selected date. Basically, pick the date from the list above, and return detailed information from the date selected.
I've created both reports, and I've enabled an Action on the date value in the text box properties, to 'go to report', where my larger, more detailed report is the selected report.
It works, in that it opens the other report. But, all of the dates of data are shown, not just the one that was selected in the first report.
I don't want a user to have to input anything. When he/she opens the report, I want them to see that daily count that I've posted above, and then be able to select a date in the list. That selected date will somehow be passed into the larger, detailed report, as a @applicationdate parameter, and the detailed applications for the selected date will be returned.
Very important, please advise.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just right click the text box, to to properties, in the general tab -- my Value says 'application_date', but if i hit the expression, this is the value:
=Fields!Application_Date.V
However if I go into text box/properties/Action, I have this:
Enable as an action: Go to report
Specify a report: MyOtherReportName
Use these parameters to run the report: there are none selected
aaah.... I got it.
It is in the Action parameters section that I was lacking. I added the name and parameter value in there, now it works.
the first report just returns this:
ApplicationDate TotalLoanAmount
03/14/2011 42350.00
03/13/2011 7525.00
03/12/2011 5700.00
03/11/2011 35625.00
03/10/2011 36975.00
03/09/2011 36650.00
03/08/2011 33100.00
And if I hit one of those dates, it pulls up the detailed report, but now it only lists the records for the date i selected.
Excellent.
Thank you very much.