I currently have a report that is generated from views within my MySQL database. These views summarise various figures to allow a quick view of overall performance. When I run my report, if there are no records for a particular area I am reporting on, the whole record for that 'day' doesn't appear.
My question is; Is there any way to force Crystal to display, say "0" if no records are found just so the other figures are displayed?
It could be that I am looking at this in the wrong way. My view "counts" available records as the field I am counting is text and not a number. I can 'sum' numbers fine and it will display '0' if no records are found but I have this issue with text where I count.
Any input would be much appreciated.