Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hbarbs

    Suppressing Field

    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!
  2. hbarbs

    Suppressing Field

    Thank You!!! That worked like a charm!
  3. hbarbs

    Suppressing Field

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

    Suppressing Field

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

    Parameter Formula Help

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

    Parameter Formula Help

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

    Parameter Formula Help

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

    Parenthesis Help

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

    Parenthesis Help

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

    Parenthesis Help

    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})...
  11. hbarbs

    Sum of Conditional Formula

    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!!!
  12. hbarbs

    Sum of Conditional Formula

    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}...
  13. hbarbs

    Sum of Conditional Formula

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

    Sum of Conditional Formula

    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}...
  15. hbarbs

    Sum of Conditional Formula

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

    Formula Help

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

    Formula Help

    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!
  18. hbarbs

    Grand Total on Formula

    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}...
  19. hbarbs

    Need help with YTD formula

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

Part and Inventory Search

Back
Top