BusinessObjects Board

date

building reports desktopintelligence
#1

Hi
I am working on some reporting database, where OLTP data will be replicated. OLTP has some transactions and the date when they will be created. Date will be there if there is a transaction on that day .

In my report, i need to display the count of transactions for each day.
How can i get sequence of dates ? is there any way in the designer that i can get sequence of dates ? (my object can point to date column in a table but they are not sequential)

Thanks for any tips
Harsha

reddyyvs (BOB member since 2004-08-24)

#2

Mods - may I suggest a move to Reporter?

On with the answer.
Firstly, make sure that your object strips out time.
For example, use

trunc(date)

in Oracle.
Then break on the date object in your report, select a column and click on the count smarticon.

I hope your question is that simple!

#3

Done.

One solution (talks about months but could be applied to days) is discussed in this FAQ entry.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#4

Hi Dwayne
Its working fine with other data provider.
i created some dates in excel and linked that to my report.

But i don’t to insert a year of dates in Excel. Do you have any tip to create sequential dates in excel ?

Thanks

reddyyvs (BOB member since 2004-08-24)

#5

Autofill works quite nicely. Type the earliest date in a cell and format as desired. Grab the autofill handle on that cell (little block on the lower right) and drag down as far as needed. The dates will automatically increment by 1 day.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#6

Thanks dwayne
i got series of dates.

reddyyvs (BOB member since 2004-08-24)