Skip to Content
0
Former Member
Jan 06, 2011 at 11:12 AM

Crosstab Data Loss

13 Views

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