Report to have n.. columns

Hi,

I have a table with following structure:

There can be different weeks for different activities. Depending on weeeks on weeks having data should be displayed. i.e. when activity was running.

Activitynumber Line Product Week1 Week2 Week3 .....Week52

100 Volume Product1 23 32

100 Volume Product2 11 46

102 Volume Product3 45 56 67 76

100 Revenue Product1 766 232

100 Revenue Product2 763 146

102 Revenue Product3 890 356 467 576

I want a report which should look like this

For Line=Volume Report:

-

Weeknumber Product1 Product2

Week1 23 11

Week2 32 46

For Line=Revenue Report:

-

Weeknumber Product1 Product2

Week1 766 763

Week2 232 146

Can anyone help me to suggest what should be the wayout?

A matrix will represent that for you. With a matrix, you can set row level grouping and column grouping. For both of your reports i would have the weeks as the row level grouping, and Product as the column grouping, and then either volume or revenue as the detail. The column group means that you will have a dynamic number of columns, one for each product in your dataset.

|||

Hi Sluggy,

Thanks for your answer. The problem here is that the table has got 52 columns for 52 weeks starting from week1, week2...week52.

some activities may be for 3 weeks some for 10 or some for 50. Will this display only the weeks whihc has the data?

regards

Josh

|||

In your report data, just make sure pull back either a week number or a week commencing, then you can row group on that. This means that you will have 52 rows in your matrix. Then if a product doesn't have any volume or revenue for that week you can show a zero (or empty cell) in the detail section. You could even go to the extent of hiding (set the hidden property to true) rows or columns that are only zeros or empty.

Hope that helps.

sluggy

|||

How can I hide rows which dont have any data? I mean which options do I have to select?

thanks

Josh