Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Cross Tab with SELECTIVE total

Avatar of PAG_Promax
PAG_Promax asked on
Crystal Reports
16 Comments1 Solution611 ViewsLast Modified:
Hi folks,

I'm in desperate need of some help here.  I've created a new cross tab report in Crystal 8.5, and have a problem with the total.  Please see example in image (not real names or values).

I have made a variable which I add too when the column names are equal to only column1 or column2  which works nicely, but when I add it as a summary field, I get a new row.  Is there any way I can use this value instead and not use the Crystal provided total?

Many thanks for any help!

Stuart. eeCR85.PNG