Cross Tabs

[ChrisH1]

Using Crystal 8

Having not used Cross Tabs much, can someone please point me in the right direction.

Currently my Cross Tab is as follows :

Rows
Workstage
@Name

Column
Week Ending Date

Summarized Field
Sum of amount
Sum of quantity


Example output

23/09/06 30/09/06
FARC
C Vella £30.00 £25
6 5
M Spilla £34.00 £24
3 3

I would like the Sum of Amount and Quantity to be side by side as opposed to the Amount being on top of the Quantity.

I cant see a way of doing this ?

Thanks

Chris

 

[lbass]

In 8.0, the crosstab does not allow for horizontal summaries. Paul Marr suggested this solution in another thread, with the solution apparently coming from BO. Try creating two separate crosstabs with the same row and column fields, but only one summary each, with one of them left justified, and one right justified. Then overlay one crosstab over the other. You can go to the customize style tab->format grid-> and uncheck "draw" to eliminate grid lines and then suppress the row and column labels in one of the crosstabs.

-LB

 

[ChrisH1]

Thanks for the advice.

Although it works there are two issues.

1. When an export to excel is run it looks as if only one cross tabs data is being exported. Theres only one summary appearing.

2. A minor issue is that the summary data in the crystal report starts in synch but with half a dozen rows one field changes to be higher than another.


Any ideas ?

 

[lbass]

Your best bet is to do a manual crosstab, if you don't have too many columns.

Or you could follow my suggestion in thread149-980436.

Or you could consider upgrading to XI.

Otherwise, it sounds like your crosstabs aren't exactly aligned. Try magnifying the view and realigning the fields, using guidelines for assistance.

-LB