Tuesday, March 27, 2012

Create table groups horizontally?

Hello,
I hope this all makes sense. I need something that has the
functionality of both a table and a matrix:
- Table: drilldown into individual records
- Matrix: show one of the groups horizonally
Here's a simplified version of what I need the table/matrix to look
like. Everything, including the Quarters, are in my dataset:
_______________________________________________
QUARTER1 QUARTER2 QUARTER3
DEPARTMENT
+ Cleaner $400 $300 $200
+ Landscaper $300 $400 $300
+ Maintenance $100 $200 $100
+ Painter $200 $100 $400
_______________________________________________
When someone clicks on the + next to each department all of the records
for that department are displayed. Here is a sample of what the data
for the report could look like:
_________________________________
Joe Blow Cleaner $10 Quarter1
Joe Blow Cleaner $5 Quarter2
Jane Doe Painter $7 Quarter2
Jane Doe Painter $9 Quarter3
Josh Ho Painter $15 Quarter2
Josh Ho Painter $7 Quarter3
_________________________________
Is this possible with both dynamic Quarters and Departments? There can
be 0 to 4 quarters and many departments, the Quarters need to be
displayed Horizontally and the departments vertically, the user needs
to be able to drilldown into the individual records.
Thank you,
MichelleHi Michelle,
If I understand correctly - this is possible.
Start off with a matrix - don't use the wizard, add a group - Department -
do not use the default cell provided (delete this one) when you have added
yours - give the cell a label (properties)
Add the next group on this group - on the visibility tab - select hidden and
tick Visibility can be toggled by another report item. In the report item
combo box - select the previous group (this is the label name you gave the
first group) etc - if you close the group before setting the visibility you
won't see the label in the drop down combo - just type it in - works just as
well.
You can do this across as well.
Hope this helps.
Regards
K
<Michelle@.bwalk.com> wrote in message
news:1109267358.435207.233690@.z14g2000cwz.googlegroups.com...
> Hello,
> I hope this all makes sense. I need something that has the
> functionality of both a table and a matrix:
> - Table: drilldown into individual records
> - Matrix: show one of the groups horizonally
> Here's a simplified version of what I need the table/matrix to look
> like. Everything, including the Quarters, are in my dataset:
> _______________________________________________
> QUARTER1 QUARTER2 QUARTER3
> DEPARTMENT
> + Cleaner $400 $300 $200
> + Landscaper $300 $400 $300
> + Maintenance $100 $200 $100
> + Painter $200 $100 $400
> _______________________________________________
>
> When someone clicks on the + next to each department all of the records
> for that department are displayed. Here is a sample of what the data
> for the report could look like:
> _________________________________
> Joe Blow Cleaner $10 Quarter1
> Joe Blow Cleaner $5 Quarter2
> Jane Doe Painter $7 Quarter2
> Jane Doe Painter $9 Quarter3
> Josh Ho Painter $15 Quarter2
> Josh Ho Painter $7 Quarter3
> _________________________________
>
> Is this possible with both dynamic Quarters and Departments? There can
> be 0 to 4 quarters and many departments, the Quarters need to be
> displayed Horizontally and the departments vertically, the user needs
> to be able to drilldown into the individual records.
>
> Thank you,
> Michelle
>|||This is perfect - thank you!|||Do you happen to know if there is a way to hide the enitre columns of
the extra groups until they are made visible? I have it so that the
groups are hidden, but their columns remain so they take up extra
width, even if the groups aren't visible. Does that make sense? There
is no visibility property on the columns themselves, and judging from
some of the other posts on this forum, it may not yet be possible to
dynamically size column widths on a matrix.
Thanks!
Michelle

No comments:

Post a Comment