Search results for query: *

yes, I did not see the opening parens. That solves the trouble, because now all I am doing is comparing a # to a #. I did have to make a slight adjustment so I did not miss the records that were equal to 0. The user input might be 20 (%) and if the Period 1 = 0, that would be a decrease over...

That is exactly the same formula as what I posted above. For a normal formula that works great and returns a 0 instead of a div by 0 error. But for an alert, it is looking for a true or false. Even when you try to save that formula in the alert condition screen, you get an error that says...

I have used alerts for groups in the past & it is pretty slick. I think I have determined why I am having trouble with this alert. In the past my condition statements did not have a need for division. Sales Period 1 < Sales Period 2. The nature of alerts, the way I understand them is they...

My report compares the # & $ Sales between a user-defined Period 1 & Period 2. The alert is triggered for any customer whose Sales have decreased by a ?Parameter amount. The condition statement I used was >> (((Sum ({@Row Sale 2}, {Customers.Customer_Type})-Sum ({@Row Sale 1}...

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.

OK, I'll check with them, thanks

Thanks Dell, Most of my experience lies with report development. I don't really get under the hood of crystal itself. Can you please tell me how do I verify whether she has the 32 bit driver installed? Where do I get that driver & where do I put it? I think that may definitely be the...

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

if it were not a complex issue, I probably wouldn't be asking for help. Thanks for the related thread.

I haven't heard from anyone on this formula for a 12 month moving average.

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

This is still an open issue for me. My datasource is Peachtree Quantum 2010. I am stockpiling quite a number of issues related to Q2010. Peachtree seems to think there is something going wrong during the 09 to 10 conversion. In 09 & before, Peach used BTrieve. As of 2010, Peach now uses OLE...

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

Thanks Jason, Not sure if this will work for me, because I am using Crystal for Peachtree. I got a tip from a friend on LinkedIn and it involves building a variable. It worked for me. Thanks for your response. Dave whileprintingrecords; local stringvar myText := {table.field}; myText :=...

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)

Thanks lbass. I am using and always use left outer joins. I will check into my use of selection criteria on the "to" table. Quite sure I AM using some to remedy detail duplication.

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

Each of the 2nd Hdr & Row have alias names. Hdr_Purchase and Row_Purchase. If you just write a check to the cleaning lady, without 1st putting in her invoice, that is what I mean. New to this site, is there a CR for Peachtree forum? Just Peachtree would not be sufficient. Most Peachtree...

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