CODEWITHSUNDEEP
reporting-servicesparametersdrillthrough
luciefi
luciefi

Reputation: 11

Combining multiple drill through reports into one

First time posting here so please be kind. I've come from using PowerBI to achieve pretty much everything I need to with a couple of clicks to using SSRS 2008... and I'm having a hard time. Here's what I'm trying to do:

I have a main report that summarizes some data on how long it takes to close down help desk tickets. On that report I have a table with summary figures (ie 220 tickets were picked up after 5 working days, 18 tickets were reopened etc). I want to click the text-box that contains 220 and be taken to a drillthrough report that contain the same table with column headers and just different row sets in each case. There will be 8 drill through actions in total and I currently have 8 drill through reports. Only 2 of those are parameter based, the others just filter the dataset based on some conditions.

What I'm trying to work out is this: can my 8 drill-through reports be rolled into one, if they're just different views of the same dataset? I've created some calculated columns with values (Yes/No because boolean doesn't allow multiple values) which are easier to pass to parameters. I also have 8 parameters on my detail data set. I've set up actions (where parameter1 = yes for instance) to take me to my detail report and use the corresponding parameter each time. It should work... but it doesn't and I can't work out why. Currently its' complaining that I can't compare a boolean to an int16 - neither the value in my calculated column nor the default parameter value is boolean or int. So, am I trying to do something that just isn't possible? Has anyone else achieved this?

Edit: here's the parameter

Parameter

Default parameter values

The error I'm getting is

error description

The calculated column that should be checked against the parameter is 

=IIF(IsNothing(Fields!DatePickedUpByAgent.Value), "Yes", "No").

Here's how I defined the action to take me to the drill through report in this case

https://i.sstatic.net/XlfQV.png

Here are the filters on the subreport dataset based on the parameters passed through from the main report. "NotYetPickedUpByAgent" is the example we've been discussing here. enter image description here

Upvotes: 1

Views: 413

Answers (1)

AnkUser
AnkUser

Reputation: 5531

Could you please go through each of your parameters one by one.

I would suggest deleting all the filters and trying to run the report and subreport. Then keep adding filter one by one.

I think issue can be any of the filter and not the one you think.

Upvotes: 0

Related Questions