Search results for query: *

lbass Thanks for your help. I really appreciate it. synapsevampire Thanks for your help as well. Sorry I am not as "tekkey" or "techy" or know as much as you (you will notice my tag says MIS). I am not a brainiac when it comes to programming, this is the reason why I post my issues on tek -...

(Sorry about the ALL CAPS, by the time I had realized that it was all caps, I was on the last sentence.) WORK FOR A PRINTING COMPANY THAT USES EFI/PSI V. 11.2.4 AND CRYSTAL 8.0.1.0. HAVE AN EXISTING REPORT THAT GIVES ME A SUM OF 'ACTUAL' HOURS PER JOB (PROFITABILTY REPORT) AMONGST OTHER DATA...

Were are comparing ytd sales of 2006 and 2007 on a report. We are noticing that regardless of whether the customer has sales for 2007, if the customer was not a customer in 2006, they will not show up on the report. Sorry, I hope I explained it a little better.

Hello, I have what is called a combined sales report. The report compares sales of our customers for the years 2006 and 2007. The report runs just fine. What is happening is if there is a new customer as of 2007, it will not show them on the report and I am guessing it is due to the fact that...

Ok, thanks for your help. Also, I did provide my Crystal Version...if you will notice I put it in the title "Query Engine Error Message - Crystal 8 , PSI 11.2.4". This is what I was told to do. Next time I will mention it in the posting as well.

Yes PSI with Macola. It is to run from the PSI interface. It PSI version 11.2.4, Macola Progression 7.6.300, and Crystal 8.0

Created a custom report from an existing report, report runs fine outside of PSI software, but when insert into PSI and run it get the Query Engine Error Message within the Crystal Report Viewer dialog box. Can anyone help with this?

Duane, Ok well I tried it and it does not work. I wonder if it has something to do with the less than sign and maybe is will work with greater than? Don't know? But will try to figure it out. Also, I did not expect you to create the whole formula for me and actually I was talking about the code...

Duane, Can you explain your code to me? Maybe I am using it wrong...where do I put this code? I guess I am a little confused.

Created a query. One of the fields calculates Sales year to date for 2006. It is a simple formula, see below. 2006ytd: nz([Jan-06])+nz([Feb-06])+nz([Mar-06])+nz([Apr-06])+nz([May-06])+nz([Jun-06]) The formula works as it should and captures the correct data, but if there were negative sales it...

Max, thanks for your help. I really appreciate the percentage formula, that will be very useful. My report looks good and is ranking the customer correctly based on the largest increase, but I have a column that says "2007 Rank" and I need the numbers 1-20 to enter that column based on the way...

Designing a report to rank the top 20 customers by the increase in sales. We have thousand of customers and some will always be in the top 20 and some will not. I would like to know how to create a formula or code that will rank based on the the change(increase)in sales. For instance, today at 1...

Wow! I think it works now. What I did was group by customer as you suggested, and then took the formula out of the report header and placed it into the newly created group header for the customer and voila! I cannot believe it was just that simple. I have been pondering over this all day. Thanks...

Using subreports within main report, need to get a subtotal for shipped quantity. Using formulas below: 1. WhilePrintingRecords; Shared NumberVar GTotal:=0; Put this in the main report header 2. WhilePrintingRecords; Shared NumberVar GTotal:= GTotal + Sum ({ARJOB.SHIPQUANT}, {ARJOB.LJOB})...

Report works fine in Crystal but when post to PSI (integration software) and run it I get a Query Engine Error: that comes up, does not give a code or anything just says Query Engine Error. I used Shared NumberVar's to total the subreports. All tables are using the OLEDB drivers. Any ideas why?

Thanks. You all have given good advice. This works!

Thanks, I figured out my fix!

Hi, Using Crystal 8.0.1.0. Windows XP. I have taken a existing report and which has 2subreports. The subreports each have subtotals. Is there a formula that will add two of the subreports to get a grandtotal onto the main report? In other words, I would like to sum the two subreports to show a...

Hi, Using Crystal 8.0.1.0,and PSI intergration software. Took a canned report, customized it and put it back into PSI. The report works fine, but my parameters look like... (1)@tuseopenPO (2)@tlpespExclued (3)@tinclfreight When they should come up in a box prompting you to put a check in a...

Oh sorry. We are using version 8.0.1.0, Would there be something about this version that is keeping me from getting the data I need?