Matrix Reprt Drill Through

Hi:
I wonder is there anyway I can show all items in a grouped level in a
cross-tab report with one click of a button (or an action)? The report is
query based.
For example, I have 10 stores and I want the user to be able to click a
botton and see all the customers in the 10 stores instead of clicking one by
one.
--
AraleHelo Arale,
What is a botton? Is that Chinese for button? Plewse spell better.
"Arale" wrote:
> Hi:
> I wonder is there anyway I can show all items in a grouped level in a
> cross-tab report with one click of a button (or an action)? The report is
> query based.
> For example, I have 10 stores and I want the user to be able to click a
> botton and see all the customers in the 10 stores instead of clicking one by
> one.
> --
> Arale

Matrix grouped by Day Part and Date

I am wondering has anybody ever created a Matrix in a report grouped by Day Part (10-2 Morn, 2-6 Aft, 6-10 Eve etc) and Date?

I would like to see a report with an output such as

13/02/2006 14/02/2006 Total
Morn Aft Eve Morn Aft Eve
Mr A 2 4 5 2 6 2 21
Miss B 8 8 1 1 4 5 27

I have a DB table which records the datetime each time a viewer changes TV channel. The report is a summary by user of each channel change By Day Part with Each Date

I can do this easily enough by just grouping on Date but now require another level of detail.Ok keep date as your first category, but group day part as a subcategory. You may need to represent the day part numerically, ie morn =1, aft = 2, eve = 3, then you will be able to srt in ascending order the dispalay morn aft eve. I hope this helps, i came across something similar the other day.|||I don't think you can have Subcategories in a Matrix, the only similar thing I've tried was to add a second grouping to the Column Grouping. The output of this does not sub group the data in Day parts it simply displays the Date with the first Day Part appended, however it doesn't sub group by Day Part

Matrix columns

Hi,
I have a report which is showing monthly sales figures on a matrix. the Rows
are grouped by year and product and the Columns grouped by month. What i
would like to achieve now is to add a column between each month column to
show the % increase between the months.
so that the report looks something like:
Year JAN % diff FEB %diff
MAR ......
2004
Product A 10 100% 5 0%
5 ......
Product B .....
...
2003....
...
regards,You could put a rectangle which has two textboxs in the data cell. One
textbox is for sum of sales and another for percentage of increase. In
column header, do same things to show different title.
Regards,
Henry
"Kazar" <kazar@.kazar.kaz> wrote in message
news:uO%23kdK0lEHA.2880@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a report which is showing monthly sales figures on a matrix. the
> Rows
> are grouped by year and product and the Columns grouped by month. What i
> would like to achieve now is to add a column between each month column to
> show the % increase between the months.
> so that the report looks something like:
> Year JAN % diff FEB %diff
> MAR ......
> 2004
> Product A 10 100% 5 0%
> 5 ......
> Product B .....
> ...
> 2003....
> ...
>
> regards,
>