Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

drilldown matrix problem Expand / Collapse
Posted Wednesday, April 24, 2013 6:31 AM


Group: General Forum Members
Last Login: Wednesday, July 17, 2013 6:23 AM
Points: 15, Visits: 50
Hi all !

i have a slight problem with my drilldown report. I have a matrix table that drills down to a table. below is what the matrix table looks like

department |LastName | FirstName |FISCAL YEAR 2013

|fiscal quater|Total
hfhgfh bloggs jon q1 q2 q3 q4
0 4 2 1
Grand Total| Dept Total

the problem im having is that when i click on one of the fiscal quarter values that drillsdown to the table say for example q2 which has 4 entries then it only shows one entry when it should show all four entries within the drilldown table.

Is there any advice on what i need to do to show all four entries. i heard i need to add scope to my stored procedure. is this right?
Post #1445904
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse