Crystal Reports 10: Nested Formula

Posted by Heather on Stack Overflow See other posts from Stack Overflow or by Heather
Published on 2010-04-01T19:09:33Z Indexed on 2010/04/01 19:13 UTC
Read the original article Hit count: 264

Filed under:

crystal-reports

|

formulas

I've a report which shows five different activity codes. I'd like to sum all like codes and place a total for each of the 5 activity codes in a group footer. I have it working for one activity code, but would like to write a formula which will look for all five and total each. This is what I have:

(if {@activitycode_id}= "Not Ready" then {iActivityCodeStat.ActivityTime}else 0)

What is the proper syntax to add additional ifs into one formula? And then the best approach to totaling each one?

Thank you!

© Stack Overflow or respective owner

Related posts about crystal-reports

Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More
Crystal Reports: 5 Tests for Top Performance

as seen on ASP alliance - Search for 'ASP alliance'
Your masterpiece report is now complete. It doesn't just meet your customer’s expectations, it blows them out of the water. All they want is a beautifully-summarized report that can be displayed in a myriad of ways. Then disaster strikes! You try to run the report for a month against the live database… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More

Related posts about formulas

How to write subscripts in Microsoft Office formulas

as seen on Super User - Search for 'Super User'
I have to write equations that have a lot of subscripts. What is the shortcut key in Microsoft Office to write subscripts in equations? >>> More
How to extend iWork's Number'09 formulas?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have specific formulas that I'd like to write (in Objective-C perhaps) and integrate with Numbers'09 of Apple's iWork suite and wonder if there is such a way to do so? >>> More
Oracle: error while trying to use formulas

as seen on Stack Overflow - Search for 'Stack Overflow'
I created an element with an input value of type "Day" , when i write a formula i get this error. Any idea what's wrong? APP-FF-33232: EATC_EXTRA_DAYS_ENTRY_EFFECTIVE_DATE_ENTRY_VALUE has null or not found allowed, but no default set specified. Cause: If a Database Item has … >>> More
excel formulas..........................................

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear Experts, Kindly check below written formulas ,if the formulas is not correct then pls provide me correct one releted to this. IF(A1:AV7000=F1,vlookup(f2,B1:C7000,2,0),0) As i have tride above written fromluas,but its not working. Pls help. Regards sant >>> More
How do I lookup a 'quantity' of items in excel?

as seen on Super User - Search for 'Super User'
Let's say I have a quatity of items: 1 2 3 4 5 4 3 2 1 2 3 4 in a column of cells. What I want to be able to do is count the quantity how many unique "items" there are in this array: 1 -- 2 2 -- 3 3 -- 3 4 .. 3 And so forth. I want the table to look like this: Also… >>> More