Crystal Reports crosstab

Question

I am new to crystal reports so this might be novice to you.

I have created a cross tab with row grand total to the right. How can I add an extra column to display Average of the rows. I am using Crystal reports 2008

Here is a rough example of the cross tab- How do I insert the Average column? Thanks

        New York   Chicago     Boston     Total       Average   

Gross Sales

Solution

do it on the back end instead of with Crystal. You want Crystal to do the least amount of data manipulation possible, as it's a reporting tool.

Comments

[user455580]

Sure I can do the that. But how do I insert an additional column in my cross tab to display the average numbers

[Daria Dragomir]

forget the Crystal solution, use whatever your back-end tool is (SQL Server?) to add the additional col (in a second view, for example, in SQL Server.) I'm assuming you can modify the report's datasource directly, but if not, you can modify it with whatever tool you have in another step before using the datasource in the report.

[Admin]

the OP is trying to use a crosstab, ie. to pivot the data. This is one case where it is normally better to do it in the presentation layer (ie. Crystal, here) rather than the data layer - even though Crystal's crosstabs suck.

[Cimplicity]

Beth... I agree with your point +1.... On the other hand I've been directed by management at my company to only use CR so that co-workers can edit my files. So disregarding logic there are cases when you have to do it the round about way. (If you can figure it out.)

[Daria Dragomir]

You will still use CR, and they will still be able to edit your files, you're just taking the crosstab step upstream to your datasource.