nrajasekhar7
asked on
How to Display the Record as null
Hi All
iam having the table with date column , if any date is missing in that month,
then i want to display the date but at the same time , i want to show the record count is zero for that date.
Please suggest!!!
Regards
Raj
iam having the table with date column , if any date is missing in that month,
then i want to display the date but at the same time , i want to show the record count is zero for that date.
Please suggest!!!
Regards
Raj
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See attached.
query.txt
query.txt
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
The answer provided is certainly a valid solution for Crystal Reports. However, the question was also posted in the Oracle zone and my response provided an Oracle solution. I'm not objecting, just making a comment.
Can you explain what it does?
mlmcc
mlmcc
Yes, the subquery simply creates date values from the first day to the last day of the month previous to the current month, which can then be left joined to the table on the date fields being equal. Where the date field doesn't exist in the table, the count will be zero.
I gather what you are saying is
Data is
Customer Date of Sale AMount
Cust1 1 Oct 11 100
Cust1 3 Oct 11 150
You want to see
1 Oct 11 100
2 Oct 11 0
3 Oct 11 150
mlmcc