Skip to Content

year table update issue

Jan 03, 2017 at 06:11 AM


avatar image

Hi All,

Report have 12 tabs , each tab fetch data for single month eg(2016M1 , 2016M2,.. 2015M12 ) We manually applied filer on each tab . We are using oracle database , every year, year table will be updated Now table is updated to 2017, now i need to change manully month tab .. there is not alternate solution

advance thanks ,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jan 03, 2017 at 10:36 AM

Instead of changing manually create individual variables for each tab and apply filters.

e.g For V current Month=if([your month/Year]=formatdate(RelativeDate(CurrentDate();-1;MonthPeriod));"yyyyMM") then 1 else 0

Apply filter where V current Month is equal to above formula you have to make sure your both objects datatype should be same.later you can use similar type of variable for each month.

10 |10000 characters needed characters left characters exceeded