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
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?