Search results for query: *

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

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

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?

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

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

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?

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

I am creating a custom Productivity report. We are using PSI/Macola packages. The report works fine except, some of the processes for our presses are not pulling into the report. For instance, "some" of the Run and Set-up processes will not pull into the report. Processes like Idle,Breaks...

Hello all! My custom report works just fine in Crystal outside of EFI(Electronics for Imaging)/PSI Software for printing companies. I can add it succesfully into PSI and select my criteria for parameter with no problem, but when it runs it get this error in the Crystal Report Viewer within PSI...

Hi all! I was wondering if anyone knew how to get rid of recurring data without doing it manually. For instance, I have imported a company name list from a database to excel and sorted it ascending. Within the list a company is sometimes listed 5 to 10 times. The spreadsheet has tens of...

Hi I was just wondering if there is a way to update a pivot table. I have data in for the month of march and need to input for the month of april. I am fairly new to pivot tables and every thing I know to do is not working (which may mean i do not know what I am doing). When I click on the data...

Working in a database that is generating data for year 2007. When open up the report the parameter prompt title asks for "2005" parameter. I have gone through the report to make sure everything is correct in design view as well as in the query. The report generates the correct data which is form...

I am trying to edit current reports in the Main switchboard, when in design view - properties - and am trying to view datasource so that i can find out what table the data is coming from to edit with current data, however, I cannot find the datasource. For instance if i have a report that has...

Hi! I am having an issue here I cannot seem to resolve. All data is correct. I have a chart that has using months and the data for that month. All the data is correct but when I go into Print Preview, the months are not alphabetized. April is the first month listed then, Aug, Feb, Dec. They are...