BusinessObjects Board

last six months data in the schedule report

building reports webintelligence
#1

hi,

I’m using SQL Server db . I want report for last six month and it should change automatically when month change no hard coding .

i’m creating a variable for current month -6 but how do i applied it on the report.

Any ideas.

Thanx

Frankslate (BOB member since 2012-06-19)

#2

You need to create a pre-defined condition in the universe, which will work out the last 6 months.

Nick Daniels :uk: (BOB member since 2002-08-15)

#3

To take what Nick said a step further, do you want to report current month plus the previous five or the previous six. For example, if run today, would you want from February back to September or from January back to August?

#4

Maybe a similar approach as suggested here?

Darth Services :uk: (BOB member since 2007-11-20)

#5

I was going to point them at the sticky topic :wink:

#6

Nice sticky topic Mark! :+1:

Darth Services :uk: (BOB member since 2007-11-20)