Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Labeling Report Group Post Reply Post New Topic
Author Message
pattersong
Newbie
Newbie
Avatar

Joined: 25 Sep 2007
Online Status: Offline
Posts: 2
Quote pattersong Replybullet Topic: Labeling Report Group
    Posted: 02 Oct 2007 at 8:01am
All,
In crystal (v.9) I created a report that has two grouping of information.  It first groups by type and then iod_hifi as you can see below:
 
Example:

  Acct           Typ         IOD_HIFI         BL_DDA

   915
1506877      117            915                  14451.45
1500672      117            915                  35178.92
                                                              49630.37
 
    918
1500923      117            918                  29482.83
1500888      117            918                  88209.64
1500842      117            918                  79344.00
                                                             197036.47
    
 
I need to add a fifth column for title and/or labels.   Say Column heading= Rate Details - 1.0%, 2.0%,  3.0%, etc. The labels are not in the database.  I know I can use the formula “If (IOD_HIFI = 915) and (type=117) then “Rate 1.0%” else 0, but I need to do this with each different grouping and there are about 347 of them.  I was reading up on using an array, I'm not 100% certain if this is the way to go?  I desperately need help!!
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 02 Oct 2007 at 11:52am

I think you are will need to create some form of a formula. It appears you have three percentages, so you may be able to get by separating your 347 categories into the three rates.

The better solution is if there is something else in the database besides that single number that sets the applicable percentage. It seems this would be the case or the percentage would be something that exists outside the database and would be prone to user error.
 
Regards,
 
John W.
IP IP Logged
pattersong
Newbie
Newbie
Avatar

Joined: 25 Sep 2007
Online Status: Offline
Posts: 2
Quote pattersong Replybullet Posted: 02 Oct 2007 at 12:37pm

John W:

>> I think you need to create some form of formula.  It appears you have three percentages, so you may be able to separating your 347 categories into the three rates.<<

 

I did create this formula:  but it only works on the specific criteria 

 

If (IOD_HIFI = 915) and (type=117) then “Rate 1.0%” else 0,

 

I need to have it on about 300 lines with different criterias and I have more than three rates.  The rates do not necessarily need to have the percentage sign with it.

 

 
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 03 Oct 2007 at 8:39am

In  Looking at your formula  what tells you this needs the Rate be 1%. Is there a list or is it a type? My point is this there is way you know what percent goes with what type and code.  Hopefully it is something we can take to convert to a formula for example something like this.

If {code) in (915,978,873) and {type} = "117" then Rate = 1%
else 0
 
Regards
 
John W.
 
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.