Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How do I create a group when data is blank Post Reply Post New Topic
Author Message
Juststarting
Newbie
Newbie
Avatar

Joined: 30 Dec 2010
Location: United States
Online Status: Offline
Posts: 8
Quote Juststarting Replybullet Topic: How do I create a group when data is blank
     Posted: 05 Apr 2011 at 5:27am
I want to create a new group for Supplier and maintain current grouping of Vouchers. Problem, supplier not on account 2010's.   I then want to sum by Supplier and trns cd 51.
 
voucher   journal  seq  account supplier   amount       trns cd
1212       
               1000      1     1010      32         100.00          50
               1000      2     1010      32         300.00          50
               1000      3     2010                 -400.00          51
1222      
               1000      9     1010      99          15.00          50
               1000     10    2010                  -15.00           51
2525        
               3653      1     1010      32          163.00         50     
               3653      2     1010      32          200.00         50
               3653      3     2010                  -363.00         51


Edited by Juststarting - 05 Apr 2011 at 5:29am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Apr 2011 at 6:03am
you can change the value to what yuo want usinga formula field and then group on that formula field rather than the supplier field
if isnull(table.supplier) then 'None listed' else totext(table.supplier,0,"")
IP IP Logged
Juststarting
Newbie
Newbie
Avatar

Joined: 30 Dec 2010
Location: United States
Online Status: Offline
Posts: 8
Quote Juststarting Replybullet Posted: 05 Apr 2011 at 8:20am
Thanks for the response.  Using the suggested formula the isnull has been replaced with 'None Listed, I need the nulls to be replaced by the  supplier number associated to the trns cd 50's for the same voucher.  In the case, I would need 32, 99 , 32 to replace the nulls in the formenation example.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Apr 2011 at 8:25am
i doubt you will be able to do that in crystal. You would need to use a previous() function which cannot be used and then grouped on.
IP IP Logged
Juststarting
Newbie
Newbie
Avatar

Joined: 30 Dec 2010
Location: United States
Online Status: Offline
Posts: 8
Quote Juststarting Replybullet Posted: 05 Apr 2011 at 8:27am
OK- Thanks for your feedback
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.