BusinessObjects Board

CR 2008 - How to display list of days

building reports crystal reports legacy
#1

Hello,

I’m in a quandry. I need to be able to display (output) dates as days in a list or string. I have a Start.Date, and want to increment seven weeks from that date, and list all of the days consecutively, on the same row e.g. 01,02,03,04… I have tried using a formula field to take Start.Date and increment by adding one, then two, then three, and so on, but that only adds one day at a time. I need a way of getting the whole seven weeks worth.

Start.Date =“01/01/2012”
newdate1 = day({Start.Date})+1

That gives me: 2 (which is the next date and I would pad so that I could then display: newdate1 = “02”)

Now I want to put the dates together to get: “0102” and hopefully get to “01020304050607”. My ideal result would be “01|02|03|04|05|06|07”.

Lastly, I do not want to have to create so many new fields. Is there a way to hack this together in one formula field? Or maybe I just confused the heck out of everybody. Thanks for any help.

aaronbrooks@emcc (BOB member since 2009-08-31)

#2

Hello

I would try to use an array and fill them in a loop.

Beat

beat77 :switzerland: (BOB member since 2008-04-29)

#3

Thanks for the reply! I’ll give that a try.

aaronbrooks@emcc (BOB member since 2009-08-31)