Monday, March 19, 2012

Matrix Questions

I have been running into a couple of problems with my Matrix style reports:

First my Matrix is a drillthrough that looks like this

Year Group QuarterGroup Detail name Detail name Group1 Group2 Group3 Detail data Detail Data

1. How do I interactively sort by a detail column name, right now I'm using a switch statement in the Group1-3 sorts to allow the user to sort, the problem is that the user has to choose how to sort before running the report and I can't set the sort direction. Sort direction doesn't take an expression.

2. How do I collapse a Detail name column, when I set the visible property to false on the text boxes in the column all they disappear but the Year and Quarter Group textboxes don't resize.

3.

I would also like to have an drillthrough matrix report that looks like this

Year Group QuarterGroup Detail % Change over previous time period Group1 Group2 Group3 Detail data % of change from last quarter or year

What expression should I place in the % of change from last quarter or year box?

Anybody?

No comments:

Post a Comment