How to Show the Missing Dates in the Second Chart

[ashrafseiff]

How to Show the Missing Dates in the Second Chart as per the attached Image

 

[Madawc]

Are you able to get tables / datasets added to the database? If you got a table of DATE set up, this could be linked to the activity using LEFT OUTER and you'd still get a slot when there was no activity. (But note that any selection on the second table must do an IsNull test first, otherwise you'll not get the dates with no records, null value for the second record.)

This is based on your text description: security where I work prevents me from accessing the attached chart.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

Please don't create multiple posts on the same topic. So far, none of your images have appeared in the file, so you are not attaching it correctly. Try testing the link.

-LB