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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.