Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Summarise Formula Field Post Reply Post New Topic
Author Message
reneek
Newbie
Newbie


Joined: 30 Oct 2012
Location: New Zealand
Online Status: Offline
Posts: 1
Quote reneek Replybullet Topic: Summarise Formula Field
    Posted: 30 Oct 2012 at 5:08pm

hi there

 

i need to total/summarise a formula field in crystal reports.

 

i know crystal cannot do this but was hoping someone could help me with a work around.

 

the formula in the column/field i need to summarise is:

 

if{@Trade CAP}<0 then {@Trade Capacity per Month} else

Sum ({ps_20MonthSpreadSum.MANHRS}, {ps_20MonthSpreadSum.Resource})

 

Thanks in advance

 

regards

Renee

IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 31 Oct 2012 at 3:47am
use shared variables
-----

shared numbervar totalsum:=0;

if{@Trade CAP}<0 then
totalsum:={@Trade Capacity per Month} else
Sum ({ps_20MonthSpreadSum.MANHRS}, {ps_20MonthSpreadSum.Resource});

totalsum

Edited by comatt1 - 31 Oct 2012 at 3:47am
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.