Search results for query: *

I know how to correct a div by 0 error by using If {Table.Field}=0 then 0 else... But I have a div by 0 error in a Report Alert. It does not seem to like If statements. Using CR v 2008.

Client has recently upgraded to 64 bit Win 7 machine at one workstation and also has new 64 bit server. Peachtree Quantum v 2011 is the db & CR 2008 SP2 is her v of crystal. She was running fine on an old XP 32 bit with same db + CR. Due to server being changed, the database path is changed...

I am reporting Unit Sales by Item and they are grouped by Month. I am trying to develop a formula that gives me the moving average unit sales for the previous 12 months. There will be 24 months on the report & I am currently using a Cross-Tab format and a Line Chart. I wish to have the actual...

I have written a fairly complex report with 4 groups and quite a few manual running totals (because Sums & Running Totals would not work on my field choices). Also, there are a number of if/then/else statements. The database is Pervasive SQL v10 & I wrote it in Crystal v2008. I have tried to...

How do I remove ALL punctuation from a field? I can take out commas and replace them with a space by using REPLACE (InputString, "," , " "). Fields have multiple punctuations including , . # ' " >> (writing in CR v2008)

Working on a crystal report using v9 and pulling from a Peachtree 2008 database. The report needs to display ALL disbursements during a period. I am using alias JrnlHdr & JrnlRow, JrnlRow linked to alias JrnlRow using LinktoAnotherTrx to PostOrder, then the alias JrnlHdr is linked to the alias...

Working on a crystal report using v9 and pulling from a Peachtree 2008 database. The report needs to display ALL disbursements during a period. I am using alias JrnlHdr & JrnlRow, JrnlRow linked to alias JrnlRow using LinktoAnotherTrx to PostOrder, then the alias JrnlHdr is linked to the alias...