Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: How to group the data Post Reply Post New Topic
Author Message
chiran22
Newbie
Newbie


Joined: 07 Sep 2012
Location: United States
Online Status: Offline
Posts: 3
Quote chiran22 Replybullet Topic: How to group the data
     Posted: 27 Nov 2012 at 9:42am
Hi,
   I am learning Crystal Reports and got the following requirement. I need group total for each record.   Please help me.
 
             Record1                   Record2
============================================
Group 1
          Test1         5                              7
          Test2         3                              4
          Test3         6                              6
Group 2
          Test1         2                              8
          Test2         4                              9
          Test3         7                              3
==================================
         Test1         7                            15
         Test2          7                            13
         Test3         13                             9
 
How can I get the above output? Tried to do Running total but adding all records.
 
Now I need seperate totals of Test1,Test2 and Test3
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 27 Nov 2012 at 9:56am
first, is TEST1 an field/record in table?

if so, group on that field, and sum based on that group and reset it after group change
IP IP Logged
chiran22
Newbie
Newbie


Joined: 07 Sep 2012
Location: United States
Online Status: Offline
Posts: 3
Quote chiran22 Replybullet Posted: 28 Nov 2012 at 3:52am
TEST1 is just a Text field object. It is just the text to that row. the data comes database.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Nov 2012 at 3:56am
you would have to use 3 running totals, each with an evaluate formula to only look at items where your type = "Test x"
 
or use a crosstab
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 | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.