Search results for query: *

Which version of CR are you using? Version 8 has a dateadd function that should work. DateAdd ("m", -1, {YourDateField})

Thanks for all the help. It's going to be a challenge, but now I feel like its one I can handle. s-)

This option is not available (greyed out) on my report. Any other suggestions?

I think the point on my previous thread got lost. Ken, You stated: "When you run a report against a QRY that doesn't have saved data, it will refresh automatically". Did you mean that the report doesn't have saved data?...Or the QRY doesn't have saved data? How do you run a...

Got it! To include the last day of the month, the code is: WHERE . ' AND YOUR_DATE_FIELD BETWEEN TRUNC(ADD_MONTHS(SYSDATE, -1), 'Month') AND TRUNC(SYSDATE,'Month') ' ' (without the last -1) .

The SQL snippet posted above does not return the data for the last day of the month. For the month of May it includes May 1 through May 30 (May 31 does not appear). How do I include May 31?

I'm confused...Right now I'm opening Crystal SQL Designer, running my 4 reports (1 for the main report and 3 for the subreports) and saving them to different files, and then I'm opening Crystal Reports to run each of the reports separately. How do I run the reports against 4 QRYs that don't...

Thanks jjames, that's very helpful. But how do I make it automatically refresh the data each month?

I need some general info (where to look?) or any tips & tricks. I have a report in CR8.5 with an Oracle backend. I'm using 4 subreports within the report; so, to get my dataset smaller (+100K records/month), I am using the Crystal SQL Designer to create qry files. This works OK, however, I...

Using CR 8.5, I have a report with a calltype field and a cost field. I need to summarize this info for total cost by calltype. I created a conditional running total, which works pretty well except: Some of the entries appear as 0.00 and others are blank. I need to have 0.00 appear when...

I'm selecting records from Oracle by LastFullWeek using CR 8.5. This works great. My question: How do I get the dates of the last full week on the report header (ie, Data From: 06/02/2001 - 06/09/2001)? Is there a simple way to do this or do I have to do a calculation? If so, any hints on...

Thanks Geoff, That had occurred to me yesterday, but I didn't know if I was missing something else. I've got my work cut out for me.

I have a report which lists the incoming and outgoing phone calls to the company. I have grouped the report by Extension. I need to create a 1-page summary of the data in the following ways for each extension: 1. 10 most frequently dialed numbers by extension 2. 10 longest outgoing calls by...