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!

  • Congratulations TouchToneTommy 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: *

  • Users: envirodata
  • Content: Threads
  • Order by date
  1. envirodata

    Using formulas in cross-tabs in crystal reports 8.5

    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} =...
  2. envirodata

    If-then-else statements in crosstabs

    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} =...
  3. envirodata

    How to pull a value when a field equals a value - Crystal 8.5

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

    Cross-tabs - removing row subtotal Crystal 8.5

    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!
  5. envirodata

    Changing header with formula using internal clock Crystal 8.5

    Is it possible to change the text object in the header area to display a month prior to the month in the internal clock? For example, I would like the header to read 'May Foundation and Restricted Gifts' this month but next month to read 'June Foundation and Restricted Gifts'. Thank you!
  6. envirodata

    Formula for renaming group header with null value in Crystal 8.5

    I have tried several different formulas but nothing seems to be working. The formulas are still returning a null value for the group header. This is what I have tried: If IsNull ({GfMem_1.GfMem_1_Program}) Then ({GfMem_1.GfMem_1_Program}) = " Other Contribution " Else...

Part and Inventory Search

Back
Top