Group Total
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17543
Printed Date: 28 Apr 2024 at 10:17pm
Topic: Group Total
Posted By: Alexander
Subject: Group Total
Date 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  Alex
|
Replies:
Posted By: zanyar-Jalal
Date 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 |
Posted By: hilfy
Date 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 http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |