Active TopicsMemberlistSearchHelpRegisterLogin

Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Group Total Post Reply Post New Topic
Author Message
Alexander
Newbie
Newbie


Joined: 10 Jan 2012
Online Status: Offline
Posts: 12
Quote Alexander Replybullet Topic: Group Total
    Posted: 11 Sep 2012 at 10:20pm
Hiiii,
I ve created one formula ToNumber ({IM_VS_STATIC_VALUE.VSSV_FIELD_01})
in the details it is showing correct numbers but when i m putting this formula in the group field it is showing me wrong total.
 
Pls someone help me Cry
 
Alex
IP IP Logged
zanyar-Jalal
Newbie
Newbie
Avatar

Joined: 06 Sep 2012
Location: Iraq
Online Status: Offline
Posts: 12
Quote zanyar-Jalal Replybullet Posted: 12 Sep 2012 at 9:15pm
Hi Alexander,

make sure your steps to create a summation of groups are correct.

Insert-> insert summary -> in calculate this summary choose sum->choose Add all group levels

this url below illustrate this more:
http://www.google.iq/imgres?q=insert+summary+in+crystal+reports&num=10&hl=en&biw=1366&bih=624&tbm=isch&tbnid=-pjWJ5rIKjedQM:&imgrefurl=http://www.exea.nl/Docs/DocView.aspx%3FDocumentID%3D%257Bc749b25a-5c07-4081-8949-8a0eb1ce9f03%257D%26noheader%3D1%26nosubject%3D1&docid=k2yI7dJ_Zd-tIM&imgurl=http://www.exea.nl/Docs/DocBinBlob.aspx%253FID%253D%25257B4edffc84-f8d1-4288-9a3a-99b2e2ef0ab8%25257D&w=333&h=417&ei=VIZRUKWVF4vmtQa0joHYAQ&zoom=1&iact=hc&vpx=782&vpy=71&dur=3163&hovh=251&hovw=201&tx=95&ty=145&sig=105888902109916711805&page=1&tbnh=132&tbnw=105&start=0&ndsp=21&ved=1t:429,r:11,s:0,i:104
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 14 Sep 2012 at 8:31am
What do you mean by "wrong total"?  If you put the field in a group header, it will give you the first value in the group.  If you put it in a group footer it will give you the last value.  As zanyar-Jalal stated, you'll need to create a summary - although you may not need it for all group levels, depending on what you're trying to show on your report.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
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.