Crystal display every date in date range on report

[JSHoltsIT]

in version 8.x, I have a report that pulls data from two date ranges (this year and last). The problem is, there is no data in my database for days where there is no data entered by a user.

How do I display in my report a date from the range that does not have data with a Zero in place of the missing data? I also need to pull data from previous date ranges and display to the right of the individual days from the current period.

TIA

Jason

 

[dgillz]

You can't. Crystal does not report on non-existent data. Your database must include every date.

So you need to find or create a table with every date in it, and left outer join it to your table with the transactions in it. Grab the date from this table, not your existing table, and the report will work as desired.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Madawc]

If you can't find such a table and are not allowed to create it, you can do a 'mock-crosstab'.

A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back.

Each running total will count the record if it was within the criteria - in your case, the day. If it's for a whole year it will be a lot of work but there may be no alternative in Crystal.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10