Efficiency of using the Running Total Function in Crystal Reports vs an If Then Else vs Select Case statement.

Working with an Oracle database and Crystal Reports.

I have to get a series of values from a common field and put them in column "buckets" so to speak.
As seen in the Excel spreadsheet.
If the field {TableName.Labor_Code} = "FMG" then {TableName.Total_Cost}  else 0
If the field {TableName.Labor_Code} = "HNG" then {TableName.Total_Cost}  else 0
If the field {TableName.Labor_Code} = "SUP" then {TableName.Total_Cost}  else 0
For all Type Codes = FMG, HNG, SUP, FIN, CLN.....you get the point!

My question is would it be more efficient to build these columns in an individual formula like above
or use a Running Total from Crystal Reports to generate the columns so that they are totaled at the right interval.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

How about using a crosstab

Not sure what you are using to separate it into rows
DO you have different sections based on a field that isn't shown?

As far as  your question, I don't think you will notice any appreciable difference between the 2 methods.
I personally prefer the formula method since I feel I have more control but I know people who like running totals.
A little less work on you part to setup


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Thank you sir. I thank you for the support. Had a problem with my Hosting company and did not realize I was not getting emails from them. Looks like I got hacked and my identity compromised My bank even found fraud on my accounts. Multiple purchases I did not make. Sorry for the delays gentlemen. Fixing that problem so I can get emails again.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.