Search results for query: *

One more question...is there a way to add 2 spaces before the {table.org} after the else statement? Not sure how to add that to the forumla. Sorry...I am new to all this. So it would show up City, Org 1 Org2 Org3 City, Org 1 Org 2 Thanks a bunch!

Thank You!!! That worked like a charm!

Thanks for your quick reply. I created the formula if onfirstrecord = True then {CnAdrPrf.CnAdrPrf_City} + "," + {@Alias - Initial Caps} else {@Alias - Initial Caps} and put it in the details section, but it only worked for the first city & org group. Then for all the rest of the cities, it...

I am using Crystal 8.5 with Raiser's Edge. I have two groups: City and Org Name. Is there a way to put both fields in one text box, but only show the city the first time. For example, I have the City of Abilene with 5 orgs in that city. Now, it is showing up Abilene, Org X Abilene, Org Y...

I think that works! You all are lifesavers on this forum! I will test it more in a bit.

I tried putting the following forumla in the select expert based on {Gf.Gf_Date}. (if {Gf.Gf_Type} = "Pledge" then {Gf.Gf_Date} > dateadd("yyyy",-12,currentdate)-1) and (if {Gf.Gf_Type} in ["Cash","Pay-Cash"] then {Gf.Gf_Date} in {?Start Date} to {?End Date} I am getting no errors for the...

I am using Crystal 8.5 with the Raiser's Edge. In the gift export from Raiser's Edge there can only be one set of criteria for all gifts. So I left off criteria and exported all gifts so I can manipulate in Crystal. I put in a parameter based on gift date: {Gf.Gf_Date} in {?Start Date} to...

Sorry about that...below is an exact copy of the formula I tried. if isnull({@Contributions this Period}) then {@Annual Commitment} else Sum ({@Annual Commitment}, {GfCnAttrCat_1.GfCnAttrCat_1_Description}) - Sum ({@Contributions this Period}, {GfCnAttrCat_1.GfCnAttrCat_1_Description}); if...

Thanks so much for responding. I am getting an error of "The ) is missing" and used the exact formula. Any thoughts on where it's missing from? Thanks a bunch...I will also check out more info on totext as well.

Hi. I am working in Crystal 8.5 and The Raiser's Edge. I am trying to put parenthesis around a Variance if it is less than Annual Commitment. My formula looks like below as of now, but I am stuck with what to put after "then" to have it put the ()in. if isnull({@Contributions this Period})...

Hi. I actually ended up rethinking and altering the export out of Raiser's Edge and I ended up with the correct info. The formula works great on the other two conditional formulas which is wonderful. Thanks again for all your help!!!

You are a life saver!!! The first two formulas worked...the third formula is not totaling. It is pulling something - it looks like it is only summing the portion of the formula after "else" if isnull({CnGf_2.CnGf_2_Amount}) then {CnGf_1.CnGf_1_Amount} else Sum ({CnGf_1.CnGf_1_Amount}...

You are really going to kill me now...so sorry. I pasted the top formula in exactly as is and am getting the "A Number is Required Here" error when I check it? The cursor moves between the = and sumformula1.

Thanks lbass for the reply!!! I feel like I definitely am doing something wrong. I put the following formula in the group header and suppressed. //{@accum} numbervar sumformula1 := sumformula1 + {@Commitment to Date};numbervar sumformula2 := sumformula2 + Sum ({CnGf_2.CnGf_2_Amount}...

I am using Crystal 8.5 along with data from Blackbaud's Raiser's Edge. I am very new to Crystal and just realized that when I try to sum my conditional formula's it says they cannot be created. I need to get a sum/grand total on each of the following conditional formulas to put in the report...

Thanks so much for the tips. This is my first time on. I am running Crystal 8.5 with Blackbaud's Raiser's Edge. The field is a numeric/currency field in the group header. The report is actually displaying a total pledge amount for each selected church. Some do not have pledges yet (no data...

I am trying to place $0.00 in a column where the fields are not being fulfilled, which seems simple enough. I have tried a bunch of formulas, but am not getting anything...just errors. I am sure I am putting in the wrong forumla. Any suggestions on the correct format. Thanks a bunch!

I am trying to grand total on a forumla, and it is not allowing me to do so (as you can see I am very new to Crystal). The forumla is in my group and is Sum ({CnGf_1.CnGf_1_Amount}, {CnAttrCat_1.CnAttrCat_1_Description})-Sum ({CnSmryGft_1.CnSmryGft_1_Total_Gift_amount}...

I am very new to Crystal and I have a question that I hope has a pretty easy answer. I am using Crystal 8.5. I have a Commitment(Pledge) $ amount for the year. I need to put in what the Commitment $ to date would be based on the date parameters of the report. So, for example... Commitment...