Search results for query: *

Hello, I am using Crystal 8.5, I schedule the reports through Peoplesoft scheduler. I pass the parameters that I need for the report into a process definition in Peoplesoft which then calls the Crystal report. Is there ANY way I can pass the parameter of print 2 copies into the process...

Hello, I'm trying to write a procedure that inserts into a table the total hours worked by dept and area summed by months using YYYY-MM as the date format. The date field I'm looking at is in YYYY-MM-DD format. Currently I'm using AND A.L_DATE_UNDER_RPT >= SYSDATE - 60 and A.L_DATE_UNDER_RPT <=...

I am trying to create and insert statement that looks at data for a month and sums it by dept, area and month. I want to have it run automatically on the first of every month for data that is 60 days ago. How do I do that so that I get all the data for months that have 31 days?? I was going to...

I have a Crystal Report (version 8.5) that is using the following formula. if {L_NAE_PRICE_LIST.Formula} = 'Y' then x := If Truncate({L_NAE_PRICE_LIST.Cost}*1.485,2) <> ({L_NAE_PRICE_LIST.Cost}*1.485) then Truncate({L_NAE_PRICE_LIST.Cost}*1.485,2) + 0.50 else...

I have a Crystal report version 6. The report has a subreport and in the subreport I'm getting a production efficiency based on total hours paid(in subreport) verses total hours worked(in main report) I'm passing the total hours worked in as a parameter field and am using a formula to get the...

I have a Crystal report version 6. The report has a subreport and in the subreport I'm getting a production efficiency based on total hours paid(in subreport) verses total hours worked(in main report) I'm passing the total hours worked in as a parameter field and am using a formula to get the...

I have a report in Crystal 6 that I'm trying to suppress duplicates on. I'm having a problem with part of it though. I'm trying to suppress duplicates in a quantity field. The problem is there is one qty that is double all the other quantities and I don't want to suppress that quantity also. I...

I have a Crystal Report that is using a Peoplesoft query. The report is called by the process scheduler in Peoplesoft. The report has a subreport and the main report and the subreport both have the same six parameters that the user must enter in on a panel in peoplesoft. that panel then calls...

I have a Crystal Report that is using a Peoplesoft query. The report is called by a process scheduler in Peoplesoft. The report has a subreport and the main report and the subreport both have six parameters that the user must enter in on a panel in peoplesoft. that panel then calls the process...