Recent content by hbarbs

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