Im trying to create a line graph which plots how many orders/Quotes are made each day in regards to salespeople.
It plots fine but any dates that are missing are not included so im getting no gaps at weekends which i do actually want to show. The only solution I can think of is to create a temp table with all the dates from the month that I want to report on then using union to include them with my data. Its a real pain in the arse though and it kills some processor time. anybody know of a better way to pack the data out?
It plots fine but any dates that are missing are not included so im getting no gaps at weekends which i do actually want to show. The only solution I can think of is to create a temp table with all the dates from the month that I want to report on then using union to include them with my data. Its a real pain in the arse though and it kills some processor time. anybody know of a better way to pack the data out?
