Solved

drill-through report, SSRS

Posted on 2011-03-14
2
959 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:dbaSQL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
ID: 35135662
Hi

You have one report with parameters and second report with parameters. You created a link but you don't send any information using this link. In action you have option to pass information (parameters). You just have to type/select destintion parameter and provide the correct value usually using something like that =Fields!MyDateField.Value

Hope that helps
Emil
0
 
LVL 17

Author Comment

by:dbaSQL
ID: 35138723
Hi Emil.  I was hoping this was a fix, but I got into the Action, and my expression is already like that:

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.Value

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.
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question