Skip to Content
0
Former Member
Feb 14, 2011 at 06:34 AM

Period in report painter report

1522 Views

Hi Experts,

I use a report painter report where certain variables are used.

In report, I have two columns. First column shows details of current period and second column shows immediate prior period.

Say 1st column shows details of period 2, 2011 then 2nd column shows period 1, 2011.

Here, the problem I am facing is, if I execute for period 1, 2011 u2013 I expect period 1 of 2011 in column 1 and period 12, 2010 in column 2 u2013 but in 2nd column, instead of period 12, it shows heading as period u20180u2019 and no details are displayed. This is happening only if I execute for period 1. From period 2 onwards its fine.

The variables I used in column 1 and 2 are

Column 1

Fiscal year : Variable u2018ZYEARu2019

Period : ZPERTO

Column 2

Fiscal year : Variable u2018ZYEARu2019

Period : ZPERT-1

Details of formula variables

ZYEAR: From field (GLPCT- RYEAR) with formula (IF '#S006' = 1 THEN '#S001' - 1 ELSE '#S001')

ZPERTO: From field (GLPCT- RPMAX) with formula (IF '#S006' = 1 THEN 12 ELSE '#S006' u2013 1)

ZPERT-1: From field (GLPCT- RPMAX) with formula ('ZPERTO' -1), also Internal variable check box is checked in this variable.

Could someone explain me how to solve this. I would like to se the system right with minimum changes because these variables are used in some other reports too. So would like to make the thing possible with minimum changes.

Thanks.