Hello everyone! I am working on a crystal report that is driving me bonkers! I want to list all the various phone numbers associated with a constituent in a custom profile report and have pulled the phone number types individually. I then embedded them into a text object to remove white space and, in...

I am new to Crystal and I need some forumla help. I would love to write a formula that changes a field that exports a year from RE to a text that represents the Class year of the Student. So, for example RE would export 2022 and I want my report to read Class K. Does anyone have any creative ideas how...

I have a column {@IF } that is based on a formula. It produces the following CnBiosName (formula created column) John Not Paid Paul Paid Ringo Paid Ben Rothlisberger Paid George Paid I would like a count of how many "Paids" and "Not Paids" Thanks so very much! Bryce

Greetings All, It is easy enough to use IF in this manner: If {CnGf_1Note_1.CnGf_1Note_1_Actual_Notes} = "Host Committee 2008 - Gala" Then "Host" Else " " But what function could be used to see if the field contatins "Host" rather than equals? I need this to be...

I'm trying to replicate what Canned Reports Demographic Reports does when it utilizes the Donor Age Range Table defined in Configuration. However the Donor Age Range table is not available to Export, so I'm struggling to write a formula for age ranges. Ideally it'd be, less than 20, 20-39...

I have a formula(Basic Sal) in my report to calculate basic salary of each employee.The formula is as below Maximum ({PMS_EmpBasicPay.Amount},{PMS_Employee.Name} ) I need to find the total basic/grand total of basic salaryin the page footer.How do I sum my formula field(Basic sal)??

Hello, My colleague and I are revising a good Crystal Report - Our source data contains duplicates (for a variety of reasons, which we're not planning to address right now). (Before this, we've been manually de-duping the Access database...no comments please!) Thus we're needing to write...

That's because everything within the quotes (") is treated as text. You'll need to concatenate the static strings with the field. Also, all parts of a concatenation need to be compatible types, so you'll need to convert the amount to a string. It will need to be something like "leaving...

It really depends on what your criteria are. You may simply be able to create groups on Campaign, Fund Category, and Dollar Amount and then total on the Gift Amount in the appropriate group header or footer. This requires that the sort order of the fields mirrors the order of the various sub-totals that...

I need to write a formula for a subreport which calulates gifts based on campaign, fund category and dollar amount. Do I need to create an if-then statement and then a summary? How do I summarize on a compound calculation (campaign, fund category, $ amount)? Any and all help would be greatly appreciated...