Print Page | Close Window

Grouping

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7807
Printed Date: 05 May 2024 at 7:13am


Topic: Grouping
Posted By: dnrwilbl
Subject: Grouping
Date Posted: 25 Sep 2009 at 1:32pm
I have a report that groups by vendor.  Now I want to put the vendor payments into two groups: one that contains all payments under $25,000 and one that have payment $25000 and over.  I want it to kind of look like this:
 
Vendor X      1,000
                       500
                  24,000
Total          25,100
 
Vendor X   25,000
                 30,000
Total         55,000
 
Can any one help?


Replies:
Posted By: DBlank
Date Posted: 25 Sep 2009 at 2:16pm
Create a formula field to evaluate the amount and then group on the formula as group 2. Do a sum of the amount field at group footer 2. YOu can hide the group header 2 field.
if {table.amount} <25000 then 'Under 25' else '25 and over'

Posted By: DBlank
Date Posted: 25 Sep 2009 at 2:19pm
Or include the vendor name in the formula and replace group one with the fomrula...
if {table.amount} <25000 then {table.vendorname} + ' (under 25k)' else {table.vendorname} + ' (25k and over)'


Print Page | Close Window