Creating a role of dates

[mcallaghan]

I have to create a 14 day list of records.

09/17/2014 09/16/2014 09/15/2014 09/14/2014 etc....

Sometimes the field will have records in it. So the data will display

09/17/2014 09/16/2014 09/14/2014

But none is displaying [highlight #EF2929]09/15/2014[/highlight] because nothing happened on this day. I do have to display the 09/15/2014.

Any help will be great

 

[Phantek]

Hi mcallaghan,

Do you have a sample of the query that you are using? Depending on how you are doing it, it may just be to use an outer join, or to use a case when gathering the results.

 

[PeterDimitrov]

What is the database ?

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

 

[Charliy]

Is there another table that contains dates for every day?

If you have (or create) that, then the easy solution is to make it the primary table and left outer join your table to it on the date.

 

[BettyJ]

If you do not have another table that contains dates for everyday as Charliy mentioned, you can create an excel file with a column containing all the dates you need and do as Charliy suggested. This most probably won't work if your report has to run within another application.