Hi CR Gurus,

I am building a CR cross-tab report which has three levels of grouping. My original requirement is to build a report which will look similar to the excel report attached in the screen-shot along with this post.

Grouping is at following levels -
1. Batch Type (CA)
2. Region (01)
3. Sub-Type (C,T,P,Q & I)

I have managed to create this cross-tab with appropriate grouping. My cross tab is in the footer section for Sub-type grouping. Thus I get to see my grand-totals @ Sub-Type section.

However, I want to see totals at Regional level, and Batch Type level. And if I put my cross-tab in any other grouping footer, the report looses its grouping for Sub-type section.

Any idea on how I can implement this?

Thanks for the efforts.

Cheers,



Image