Crosstab row groups tree structure

[Sebastian]

I have a crosstab with the following Row Groups:
Year ->
     Month ->
             Sales Unit ->
                       Sub Sales Unit 1 ->
                                  ... Sub Sales Unit N ->
                                                           Product ->
                                                                             Detail.

Groups are linked to each other by parent-child relationship.
In an application this tree structure is dynamic, the level of the Sub Sales Units equals 1...N (for example Nmax=5). User can select Sales Units that are shown on the report.
How to prepare a report with this structure. Is it possible to hide unused levels and show Product and Details?
Detail group in the crosstab is linked with the last child group. How can I show Product and Details if there are less levels than Nmax?
Attached image shows a report with one Sub Sales Unit. I'd like to avoid designing a separate reports for each level.

Thanks,
Sebastian

[IvanY]

Hello Sebastian,

Your scenario can be easily achieved simply by using the Crosstab wizard:

1. Add your data source.
2. Choose the Crosstab wizard and click on the Detail section.
3. Click next.
4. Choose the added data source from Current Data Sources and click next.
5. Add Year, Month, Sales Units, Sub Sales Units and Product in this order to the Row Groups.
6. Add Quantity to the Column Groups.
7. Add Sum(Quantity) to Detail Values and click next.
8. From the four options choose Blocked layout, subtotals above and click next.
9. Choose the desired coloring of the Crosstab and click finish.

I have attached a sample report with a similar Crosstab.

Kind regards,
IvanY
the Telerik team

[Sebastian]

Thank you for the information.

I've already used Report Wizard to prepare the crosstab (attached in the first post). It's working good :).
For example I'm able to prepare the crosstab that contains 5 "Sub Sales Units".
In this scenario - Details row will be attached to the last 5th Sub Sales Unit.
User can choose Sales Units that are shown on the report.
So if the user choose Sales Units from levels 1 to 3, the Details won't be visible on the report
because are attached to the 5th level (not to 3rd).
So the issue is: how to display Details with the "dynamic" Row Groups level?
I'd like to avoid designing a separate reports for each level.

Regards,
Sebastian

[IvanY]

Hi Sebastian,

This scenario currently is not possible as leaving the details section means grouping and recalculating the whole Crosstab using a different criteria. What you can do is create multiple Crosstabs and hide them depending on a Parameter.

All the best,
IvanY
the Telerik team