Search results for query: *

Right. Thank you. Have posted elsewhere.

Using Crystal Reports for BlackBaud, Version 8.5. I am attempting to write a formula for a cross-tab and insert it as a row. The first step I took was to open the formatting box and hit New Formula. I used this formula (which had no errors): If {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong} =...

Using Crystal Reports for BlackBaud, Version 8.5. I am attempting to write a formula for a cross-tab and insert it as a row. The first step I took was to open the formatting box and hit New Formula. I used this formula (which had no errors): If {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong} =...

LB - I'm sorry, I'm not sure what you mean, I do believe that I showed all of the ID fields that I exported from the database - do you mean that I should export more fields? I showed all the fields that I exported - the only remaining fields in the field explorer are the link and key fields - do...

When I looked at the results - I saw that gifts were repeating themselves. When I looked further, I see that this field GfApls_1ApApP_1.GfApls_1ApApP_1_Package will repeat for every gift with every appeal (regardless if that package was the one assigned to that gift. I found that I had to use...

This is what I did: 1. In the Field Explorer, created a new running total field. 2. Named the running total field 1Stor50. 3. Summarized on the no. solicited formula field, the formula is: tonumber({GfApls_1ApApP_1.GfApls_1ApApP_1_No_solicited}) 4. Evaluated using a formula: ( onfirstrecord or...

Okay, I have followed the instructions closely and double-checked but am coming up with only 1.53% when it should be just over 60%. Above, when you say, Reset on change of group: appeal id. This assumes you have sorted by package id. Do you mean that taking the step to reset on change of...

To be clear, the type of summary drop-down list includes: maximum minimum count distinct count Nth largest Nth smallest mode Nth most frequent Thank you for your help.

Sum is not on the drop-down menu.

Oh, I see. I've almost got it - just one more question - what is the type of sum on the no. solicited field - choices being maximum, minimum, count, distinct count, etc.? Thank you.

It tells me that #1stor50 field name is not known - and I did name the first formula this. Also, what do you mean by Reset on change of group: appeal ID? Thank you.

I do think you are genius - this is much further than I could ever get on my own and that you're not looking at the data is even more impressive. I am again, however, stuck. After following the instructions, I'm coming up with a retention rate of 28.57% and it should be 60.13%. I do know what...

Thank you, LB - and sorry it has taken so long to get back to this. I successfully created the first formula above but when I try to create the second formula, the cursor goes back to {@1stor50} and says that the field name is not known.

Thank you, LB. I am still having a problem with this. I tried to insert the formula above and it said that the field name is not known. Then I tried using this //{@1stor50}: if {table.GfApls_1ApApP_1_Package} in ["1st Package","50+ Notice"] then 1 Because this looks like the name of the field...

Sorry, I just made a mistake - the Field name is 'Package ID' and the values are 1st notice or 50+ notice (or 2nd notice, 3rd notice, etc.). They are not fields themselves but the values of the fields in the database. But 'Package number solicited' is a database field.

'Package number solicited' is an actual database field. The package ID field is named '1st notice' and I would like to to add the no. solicited from this field to the package ID field '50+ notice' and divide that number by the total count of gifts (but the count of gifts should include all...

In Crystal I'm struggling with how to design a report that will pull from a field when the field is a particular value. More specifically, I'm trying to find the percentage of gifts that came in from the no. of people solicited. The problem is that a person could have received up to 5...

Genius - thank you! I was selecting the wrong row (or the right row but it wasn't giving the right results). Thanks for your help!

I'm wondering if there is a way to remove a total row in a cross-tab in Crystal? I have suppressed the text which I can live with but I would prefer to not have the blank cells showing at all. More specifically, I want to show the date field but I do not want to subtotal by this field. Thank you!

Wow! Thank you!