September 19, 2022 at 8:34 pm
We have a requirement to create SSRS drilldown report. The data comes from 7 excel reports. Using same sql query with different values for parameters. So, SSRS report has 7 datasets.
Example:
Stored Procedure:
Create uspxx (
fileFolder varchar(200),
fileName varchar(100)
)
As
BEGIN
-- import of file to table happens here
-- file 1 import into table 1
-- file 2 import into table 2
END
IN SSRS report, we have 7 datasets and each dataset has different value for filename.
It is financial report where we are showing year end expenses sums like this
Type Final Expense OtherExpenses
Purchases 12345.00 98988.00
Adjustment 1111.00 000099.00
In this purchases is one dataset or 1 file data,
Adjustment is another dataset\ from another file
Basically, value Purchases and Adjustment are hard coded and 12345.00 is sum(fields!column1.value), "dsPurchases". This dataset has other fields. Requirement is
1. Purchases should have + sign and act as drilldown.
2. When clicked on Purchases + sign, details of dsPurchases should be shown
3. Adjustment should have + sign and act as drilldown
4. When clicked on Adjustment + sign, details of dsAdjustment should be shown
From what I have seen regarding drilldown reports, groups are created and then drilldown is set.
But in my requirement, each line item is it's own dataset. So, how can I create drilldown for that dataset to show details underneath.
Thank You
September 20, 2022 at 9:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
October 13, 2022 at 10:14 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply