Prompt Dates

[system]

Hi,

I have 2 prompts in a report. Begin Date and End Date

Begin Date: 07/01/2007 and end date : 06/30/2008

How do I get all month(s)-year between those 2 dates…

I mean… JUL-2007, AUG-2007, SEP-2007… and so on…

Thanks

BO 5.x

---

eye_candy (BOB member since 2005-03-18)

[system]

You obviously must be having objects for
Begin Date and end date.

Set your prompts such that
Begin Date >=07/01/2007 and End Date <= 06/30/2008

Then in the report… Use one of these objects (Start or End Date) to extract the month and year

“=Formatdate(Date,“Mmm - YYYY”)”

---

chander165 (BOB member since 2005-12-20)

[system]

The only way to ensure that you get every date - no matter what is in your database tables - is to use an extra data provider that imports only the calendar structure. It’s covered (with not much detail, as I see now that I review it) in this FAQ post:

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…

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

Veena:

If you are using Full Client, you can create an EXCEL FILE and add it as a second data provider in your report.

You can create/load the whole time dimension table values in excel(for 1 or 2 years) and use it.

Note : This is not possible in BO XIr2 WebI.

---

BO_Chief (BOB member since 2004-06-06)