Problem: How to create a drill
through report in SSRS?
A drillthrough report is a report that a user opens by
clicking a link within another report. Drillthrough reports commonly contain
details about an item that is contained in an original summary report. For
example, in this illustration, the sales summary report lists sales orders and
totals. When a user clicks an order number in the summary list, another report
opens that contains details about the order.
Example:
In this article, I am going to show we can use a report data
column to open a detail report based on invoice date.
For
example, we have invoice details and invoice year, date and invoice id.
Step 0:
Create an invoice detail report using the below set to add a parameter by
invoice date.
SELECT [Invoiceid]
,[itemid]
,[unitprice]
,[quantity]
,[TotalAmount]
,[lineitem]
,[linetotal]
,[invoicedate]
FROM [dbo].[OrderInvoice]
Where
Invoicedate=@invoicedate
Step 1: Go
to the designer, add invoice year, invoice date, invoiceid. Go to Tablix properties
of the invoice date column by right clicking on the table inside the report
designer.
Step 2:
From the properties window select the action tab and select the option go to
report and from the drop down select the report to drill through and add the
parameter to this by invoicedate.
Step 3: go
to preview of the report and click on the invoice id and this will take to the
invoice details reports based on the invoice id’s invoice date.
Results:
0 comments:
Post a Comment