system
February 9, 2013, 7:37pm
#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)
system
February 10, 2013, 7:24pm
#2
You need to create a pre-defined condition in the universe, which will work out the last 6 months.
Nick Daniels (BOB member since 2002-08-15)
MarkP
February 11, 2013, 9:15am
#3
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
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?
system
February 11, 2013, 10:15am
#4
Maybe a similar approach as suggested here?
What is the formula in WEBI to filter my table/charts by the previous 12 FULL months of data?
mssbass (BOB member since 2010-07-13)
Darth Services (BOB member since 2007-11-20)
MarkP
February 11, 2013, 11:02am
#5
I was going to point them at the sticky topic
system
February 11, 2013, 2:42pm
#6
Nice sticky topic Mark!
Darth Services (BOB member since 2007-11-20)