Crystal Reports Tools: Improve Performance While Saving Time and Money
  Resources  
Best sellers:
cView
Report Analyzer
cViewSERVER
 ReCrystallize
 

Buy Crystal Reports

Articles:
 Administration
Advanced
Basic
 Crystal eNL
Database
Financial
Problems Solved

 Books:
CR Books
Database Books
Developer Books
 
Tools:
All CR Tools
CR Analyzers
CR Bestsellers
DataBase Tools
CR Graphics
International
CR Mail UFLs
ReCrystallizePro
CR Schedulers
CR UFLs
CR Viewers


Add'l:
About us
Contact Us
cViewSUITE Ppt
Support
CR trial
 

Crystal Reports
on Steroids

Crystal Reports: Calculate Member in Crosstab

Creating a Calculated Member in a Crosstab in Crystal Reports 2008

 

One of the great new features in Crystal Reports 2008 is that you can include additional rows and columns in your crosstab reports. We like this improvement and suggest that some might find this alone could justify upgrading to the new release.

 

Select the crosstab and Right Click to select the Advanced Calculations/ Calculated Member menu item.

That will display the form you see on the right.

Click New to create your new calculated member. You then give it a name and select what group level you want it to appear in.

 

Click Image to Enlarge

The Value formula combines the values for three cities as follows:

GridValueAt(CurrentRowIndex,

GetColumnPathIndexOf("Hamilton"),

CurrentSummaryIndex) +

GridValueAt(CurrentrowIndex,

GetColumnPathIndexOf("Rotorua"),

CurrentSummaryIndex) +

GridValueAt(CurrentrowIndex,

GetColumnPathIndexOf("Tauranga"),

CurrentSummaryIndex)

The Insertion Formula uses the Functions:

GetColumnGroupIndexOf(CurrentColumnIndex)=1 and

GridRowColumnValue("City") = "Hamilton"

The column value and Header formulas are a constant string saying "Upper North Island". You could then add additional rows and columns to calculate summaries of your other cell values.