We are currently using Crystal Reports for Enterprise 4.0 to develop the required reports. One of the reports we are generating needs to provide the P&L actuals or budgets based on G/L hierarchy and fiscal period. We are connecting to a BW query with prompts for fiscal period range and GL account.
I created a crosstab with G/L hierarchy in the rows and fiscal year period in the columns and actuals as the delgated measure. For ex : I selected July 2011 to June 2012 as my fiscal period range, the report sorts the columns in ascending order by default which would be April, August and so on. When I change the sort order to original order, the columns gets sorted as required, but create duplicate columns of the fiscal period and repeats for many number of times. Even for the G/L Hierarchy, when I change the sort order to original order, I have the same problem. We have observed this issue of original order sorting when we use the cross tab. Could anyone suggest a solution for this? Thanks.