Changed my function to Crystal Syntax. I thought it was giving me an error when running through RE. I also added a replace to deal with "," as a decimal separator. StringVar Result := {Gf.Gf_Currency_Amount}; IF InStr (1, Result, ".") > 1 THEN        (     Result := ...

Hi Drew,  Ccur did not work. Thanks, William

Hi Drew, You are correct. I am not adding different currencies together. I do however want to sum up amounts for each currency seperately, but they all appear on the same report. Example, my report could look like CAD = 10 000 USD = 10 000 EUR = 10 000 ... Each 10 000 of what ever can be comprised of many different gifts. RE exports the ...

For now, I am sumarizing on this function.... (basic syntax) Dim Result as String Result = {Gf.Gf_Currency_Amount} IF InStr (1, Result, ".") > 1 THEN        Result = Replace(Result,",","") END IF Formula = ...

I need to insert a summary field on the Currency_Amount field (exported from RE with Export). Thing is that RE exports this field fully formatted, therefore it is a string field. Crystal cannot summarize on a string field, so I would need to convert it to a number (ex: ToNumber() ), however, because of the various countries and number formatting, ...

Has anyone been able to use VBA to pull out extra data during a receipt run? More precisely for consolidated receipts?  My problem lies within consolidated receipts. Since RE does not export any kind of detail on camp fund appeal... for consolidated receipts, I have tried to devise a way to pull it out with VBA. Basically, I need to have the ...

Hi Joe, Looking into this myself. Have you had any luck in doing so? Thanks, William

I anyone else having issues with RE crashing after running VBA code that was just modified or added? I know this soulds like a "there is something wrong with your VBA" question, but it is not. I can add new code, test, modify, test again... Then , after one modification, when the VBA (whether it be the part I recently modified or ...

To add gifts from an excel list you might be better off using import. Find some way to put IDs on your constituents in excel. You can make yourself an excel macro that looksup data via ODBC and populates an Import ID Field in your excel spreadsheet. You can also look at the plugin that David Zeidman developed (ID Lookup). Just google ''Zeidman ...

I am looking for some fresh new ideas. As you have all probably experienced, the stock batch validation report is not exactly easy to read and, well, validate. I have done in the past custom validation reports that are quite optimized to the organization's validation process. These have usally been in Access or Crystal through ODBC with a ...