Greetings, I've made a report in CR that shows the package description, number of gifts and total gift amount. I have them grouped in specific orders and have them subtotaled by group (which is why the canned appeal analysis report doesn't work for me). Anyway, now I need to include number solicited...

Thanks. That worked great. The only problem I have now is that I want to add the notes field and there are multiple notes. Where do I put that field in order to ensure that the gifts all don't split between the notes? What is the rule of thumb for inserting fields with multiple values?

I am trying to create a new crystal that includes the last 12 gifts (along with date, type, appeal). The report is grouped by the Constituent's sort key and I have included address information in the details section. I am trying to enter the gift information in the detail section. It has been a long...

Here is the situation: I have exported the following tables from RE: CnBio CnGf_1 CnGf_1_Attr_Cat1 CnGf_1_Attr_Cat2 Joe 20 4 1 Steve 10 1 5 Kate 30 6 3 The sitatuon is that Joe only bought 4 adult tickets (did not have data in CnGf_1_Attr_Cat2), so Crystal XI pulled Steve's adult ticket purchase...

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 am doing some testing and here is what is occuring: I export First/Last Name of the constituents and the name of individuals that are one kind of individual relationship. When I open the .mdb file CR XI only sees CnRelind_1_01_Name, but not CnRelind_1_02_Name, etc... Instead it puts the names from...

Been searching and finding no answer to my question: how can I display the last modified date of the underlying mdb file in the actual report? Any smarties out there with a suggestion?

I have three tables that I exported from RE: CnBIO, CnGF_1, CnGF_1Note1_1, that contain the following fields: First Name, Last Name, Gift Amount, Gift Balance, and a Gift Note The issue I am having is that if a record does not have data in one of the fields, such as the Gift Note, it does not show that...

Can anyone help please? I am writing a crystal report from an Event Participation export from Raiser's Edge which includes Registration Fees and Other Donations. The report is grouped by Event with summaries for total participants, total donations and registration fees, the first two summaries return...