Forum Discussion
undefined
Hi mcantos - I have some key ideas, please check once.
Create a measure for each cell you need to populate (based on Stage and Status), which will avoid the need to create 9 or 6 separate datasets.
A matrix should work for cross-tabulation of Status and Stage. It dynamically expands and simplifies the table structure.
Focus on formatting and grid alignment to make the matrix look as close to a report as possible.
This approach should give you more flexibility than manually creating separate datasets for each table while keeping the report structure more maintainable.
Hope the above informaiton helps.
Hi mcantos - I have some key ideas, please check once.
Create a measure for each cell you need to populate (based on Stage and Status), which will avoid the need to create 9 or 6 separate datasets.
A matrix should work for cross-tabulation of Status and Stage. It dynamically expands and simplifies the table structure.
Focus on formatting and grid alignment to make the matrix look as close to a report as possible.
This approach should give you more flexibility than manually creating separate datasets for each table while keeping the report structure more maintainable.
Hope the above informaiton helps.
HI rajendraongole1 ,
Thank you for your ideas. I guess it is possible to create measures that concatenate more than one field, so I'll try.
On the other hand, I think the problem would be the little squares on the right side of the cell as they are also different fields with a specific format.
Since the report contains two slides should I create them as a separate report? I don't see any way to create them together.
Thank you! I'll get back with my results!