How to show all days of month in lines?

[system]

Hi,
I need to run monthly a report, showing a number of occupied locations per each day (also Sautrday and Sunday).
I want to run this report always at the last day of the month before midnight.
How can I show/list all the dates of the month in lines? I know how many days are in the month (function DaysBetween).

e.g.

1.2.
2.2.
3.2.
etc.

thanks,
jezko

---

jezko (BOB member since 2010-10-12)

[system]

Why don’t you use Date as a column? You can always format that Date into whichever format you like viz MM:DD etc.

Thanks

---

SAP_BO_Addict (BOB member since 2003-09-18)

[system]

Hi Jezko,

This Reporter’s FAQ can help:

FAQ: Reporter

How can I include data for all months in a crosstab, even if a particular month has no data? One way to do this is to create a second data provider using only the months. Then link (or “merge”) the second data provider (query) with the first data provider. Use the month column from the second data provider in the cross tab. This should bring in all months even if there were no data for that month. However this technique does not work if you have sections in your report. Dave Rathb…

---

Marek Chladny (BOB member since 2003-11-27)