Hello All
I need help with a Crystal Reports 2008 crosstab linked to BW. The problem is as follows:
When reporting data on two Hierarchies within a Cross Tab I get correct result as follows:
_______________Region 1 Region 2 Region 3 Region 4
Article Group 1..... 100...... 2000..... 300....... 400
Article Group 2..... 6000..... 200..... 3000....... 500
When adding a third Hierarchy to the cross tab I lose data for Region 3 and 4.
__________________________Region 1 Region 2
Article Group 1 Department1..... 50..... 1000
................. .. . Department2..... 50..... 1000
Article Group 2 Department3..... 3000..... 100
.................... .. Department4..... 3000..... 100
Please note that Regions, Article Group are grouped by specified order.
This seems like I have hit a data limit on which the Cross Tab can report upon. Can anyone suggest how I could fix this ?
Thanks
Phillip
Edited by: Phillip L on Jan 6, 2011 12:12 PM