Search results for query: *

I do have it grouped by the person already and it can result in nulls. Looks like it'll be long formula for all 40 potential options. I appreciate the help!

Unfortunately, I can't use a cross-tab for formatting purposes. The formulas aren't complicated, but they're each set to super-specific output criteria and formatting based on the data. Essentially, it will end up in almost a spreadsheet-like column format. The person's name would be listed in...

I need to build a comma-separated list with the data that is output from the formulas I've setup. There are 40 different groups (based on 40 different formulas) that people can fall into. Each person can be part of more than one group. I need to build a list summarizing the groups that they fell...

I am trying to get certain data from a row into a column. I would like to move a variable # of scholarships linked to one individual all to a single line item with multiple columns for each scholarship. It currently looks like this: Person_1 ID | Person_1 Name | Scholarship_1 ID | Scholarship...

Thank you. I got so focused on trying to get it to work from the initial table linking that I didn't see the obvious option of filtering them out through the select expert.

I am trying to limit the outcome of my report that has 3 different data sources. Table 1. All individual contacts Table 2. Financial Report 1 Table 3. Financial Report 2 The tables can link on a common account number. I only want to pull individauls (Table 1) that have financial activity in...

Can someone help me build out a limit for payment terms on our website. I'd like to limit the number of installments that you can pay your balance in, depending on the date. Our year goes from 9/1/20XX - 8/31/20XX. If you sign up pre-September, you can choose UP TO 12 installments, anytime in...

You are a life saver. This is exactly what I needed.

I am building a report from a donation database that needs to include various benefit detail for each gift. I need to create a sentence from several multi-valued database fields that exist for the benefits. In the database, there could be multiple benefits for each gift-- each benefit would...

I've been able to get what I needed with subreports.

It is a one to many table linking, but the type and sub-type options are in the same table.

I feel like there is an obvious solution that I am missing, and I am hoping someone can help me out of this Monday rut! I have a report of donations to our organization for the year. I have the donations grouped by type and subtype, and I want to pull in the detailed donation information into...

I'm trying to match the value of a field in 'Column A' to any row of data in 'Column B', not just the fields corresponding row. Column A Column B Match? 1 6 Yes - "1" matches in row2 2 1 No - no match for 2 3 7 No- no...

I am struggling to write a conditional statement that would allow me to write a different sentence in one field based on several different fields, and potentially building that sentence. If the gift type is {Gift-in-Kind} then "Sentence about gift-in-kind." If the gift type is {Stock} then...

Thank you! I think I finally got it working. I actually had up to 12 different memberships, each with the output of conditional messaging. I appreciate your help.

Hi, I want to move a field into a column at each change in [condition]. For each person in my data set, I want to put each of their memberships for the year in a new column. Basically, each person has a single row, even if they have multiple memberships. Each membership would become a new...

You have just made my entire week. It works! Thank you so much. I'm an accountant trying to teach myself Crystal Reporting.. you are a lifesaver!

It is MDB extracts from Raiser's Edge. I don't think it could be pulling from a separate MDB-- all the data was pulled into a single MDB extract out of RE. I recreated the export from RE as a .csv export and it is correctly pulling the department field onto the proper transaction, but not doing...

The field name that corresponds with the department is: GfFnds_1FnAtrCat_1_Descr SELECT `GfCnBio`.`GfCnBio_ID`, `GfCnAdrSal`.`GfCnAdrSal_Addressee`, `GfCnAdrPrf`.`GfCnAdrPrf_Addrline2`, `GfCnAdrPrf`.`GfCnAdrPrf_Addrline1`, `GfCnAdrPrf`.`GfCnAdrPrf_City`, `GfCnAdrPrf`.`GfCnAdrPrf_State`...