Print Page | Close Window

cross-tab summary

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13860
Printed Date: 20 Apr 2025 at 1:39pm


Topic: cross-tab summary
Posted By: pnini1000
Subject: cross-tab summary
Date Posted: 24 Jul 2011 at 11:31pm

Hi all,

I have a cross tab in the report.
I want to sum up in the summarized field only amounts that greater than 0.
I tried to use a formula:
 if({DataTable.TotalSum}>0) then
 sum({DataTable.TotalSum})
but the amounts don't reset on every group.
 
how can I do it in cross tab?
 
thanks,
pnini1000


Replies:
Posted By: hilfy
Date Posted: 25 Jul 2011 at 8:23am

Are you using Crystal's Cross-Tab component or are you manually creating a cross-tab? 

If you're using Crystal's cross-tab, create a formula like this:
 
If {DataTable.TotalSum} > 0 then {DataTable.TotalSum} else 0
 
Place the formual in your cross-tab and configure it for a sum.
 
If you're manually creating your cross-tab, use the same formula then add a summary field that will show the sum by group.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window