Crystal Reports crosstab
21,105
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.
Author by
user455580
Updated on April 27, 2020Comments
-
user455580 almost 4 years
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
-
user455580 over 13 yearsSure I can do the that. But how do I insert an additional column in my cross tab to display the average numbers
-
Daria Dragomir over 13 yearsforget 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 over 13 yearsthe 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 about 12 yearsBeth... 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 about 12 yearsYou 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.