Running Dates for each row

[system]

Hi,

I have a user requirement to display the records in the following way as 1 day incremental for each next row:
E.G.
Account NO Date Transaction Amount
1234 11/06/2012 1000
1234 12/06/2012 0
1234 13/06/2012 0
1234 14/06/2012 0
1234 15/06/2012 5000
1234 16/06/2012 2000
1234 17/06/2012 0

In the database table this account has only 3 rows for which transaction is made(I.E. 11 june,15 june,16 June),but the user needs the report with data for all the days irrespective of transaction made or not.

I need incremental dates for each row in report.

May be this is too simple,but it is not striking me.Please help me urgently.

---

navneetkaur (BOB member since 2010-08-27)

[system]

Hi,

This Reporter’s FAQ can get you started:

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)

[system]

The function you need is TimeDim()

I documented it here :

The Awesome TimeDim function

Peter

---

pderop (BOB member since 2010-10-27)