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...

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...

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...

Lambda Legal is a national organization committed to achieving full recognition of the civil rights of lesbians, gay men, bisexuals, transgender people, and people with HIV, through impact litigation, education, and public policy work. Founded in 1973 and headquartered in New York City, Lambda has regional...

I am trying to export data from RE to use in a Crystal Report and a RE Custom Report. I can export the data I want in Excel format and it works fine but when I change the Export Options to use Access or MDB format, although all Output fields are identical, I have problems. I'm trying to export a...

Hello, I've been using RE for a few months and am finally ready to delve into my first custom report for our fall appeal. It will be a list of donors/prospects grouped by solicitor showing the 0-4 gifts made by the donor/prospect. I have a lot of experience with Access, which is serving me well with...

I am trying to create a directory in Crystal Reports and want to export photos of members from RE. I can't seem to find a way to get the pictures into MDB format. Export does not have an option that I can find to get the pictures out.