Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Force date with no data onto report

Status
Not open for further replies.
Mar 14, 2003
5
0
0
US
I have a report which allows the user to choose a month and then displays a single metric, by day, for that month. Unfortunately, if there is no data for a particular day, then this day does not appear on the report. How can I force all days for the month to appear?
 
in Report Data Options, Calculations, change the Attibute Join Type for "Time" to an outer join. change the Preservation setting to the final option ("w/filter")

you may also want to indicate to the user that data does not exist for that day, so in Report Data Options, Display, Null Values change the values to display something appropriate.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top