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

Thanks a BUNCH!!! Worked like a charm.

Thank you!! That helped a LOT.. But it selects the right month now but it also select month and year of 2 years ago. So it will select 3/2004 and 03/2002 any suggestions as to how I can get to work correctly expecially when looking like in Feb. when you have to in Feb 2005 look at Dec. 2004?/...

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

lbass, Thank you!!! The formula now works EXACTLY as it should!!! I really appreciate the help.. Thanks again, Karma

This Formula is close to working but I need it to round UP to the nearest .50 cents... For example 328.50 on report with current formula 328.52 calculator 329 (this is what I want it to be on report) 289 on report with current formula 289.05 calculator 289.50 (this is what I...

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

Yes, I'm using Crystal 6. I got my problem figured out. I just had to change the way I linked my report to my subreport and then it worked just fine!! I just had to use my parameter field from my subreport as the field that I linked to the main report. Thanks, Karma

Ok, So I still am having a problem with this report. But it's not nearly as complex as it started. So now I have the total that I need on the main report and I have the total that I need on the subreport. My problem is I need to pass the total from the main report to the subreport with having it...

I have fixed the error but in the formula but it still doesn't give me what I'm looking for. I'm VERY new to Crystal so I know my questions are basic. But these are the formula's that I have. WhilePrintingRecords; NumberVar countHrs; if Sum ({PROD_EFF_SUBREP.L_EMPL_HRS}) <> 0 then countHrs :=...

Thank you for your suggestion. I'm getting an error when I try to put this code in as a formula. This is what I have. WhilePrintingRecords; Shared NumberVar ?dl; Globel NumberVar ?newdl; ?newdl := ?dl it points to the Shared part and then says that the remaining text does not appear to be part...

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