I know this topic has been posted quite a few times - but I am yet to find a clearly defined solution.
I have a simple chart counting the total number of accidents per month. The month is derived from the Event table >> Month ({Event.Event_Date}).
However, if there is no event corresponding to July or August or any other month in the Event table, then Crystal Reports simply skips to the next valid month where the number of events is > 1.
I know this can be achieved with a view - but I believe there should be a much more simple solution. I have tried a variety of different formulas but still no luck. Any Ideas?
Tech specs: Crystal 8.5
Database: Oracle 9.2, MSSQL 2000, ASA Sybase 8.2
Windows XP SP2
APB
I have a simple chart counting the total number of accidents per month. The month is derived from the Event table >> Month ({Event.Event_Date}).
However, if there is no event corresponding to July or August or any other month in the Event table, then Crystal Reports simply skips to the next valid month where the number of events is > 1.
I know this can be achieved with a view - but I believe there should be a much more simple solution. I have tried a variety of different formulas but still no luck. Any Ideas?
Tech specs: Crystal 8.5
Database: Oracle 9.2, MSSQL 2000, ASA Sybase 8.2
Windows XP SP2
APB