Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: cross-tab summary Post Reply Post New Topic
Author Message
pnini1000
Newbie
Newbie


Joined: 21 Jul 2010
Online Status: Offline
Posts: 14
Quote pnini1000 Replybullet Topic: cross-tab summary
     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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.