CR 2013 - Dynamic Label change for the feilds from HANA

[Former Member]

Hi ,

We are using CR 2013 and HANA as our data base..

We have an requirement where I need to dynamically display th ebelow labels for the report with the user eneterd date .

EX ( Feild Name : CY New Offices as 2015 New Offices and PY New Offices as 2014) and this should change according to user enetered Year ( EX: 2010 ) then it should be PY as 2009 New Offices and CY as 2010 New Offices

Can Anyone help me in writing a formula to display the Dynamic Feild Labels ? the folmula is just to change the Label name dynamically instead of static CY or PY in the label.

Thank you in Advance !

Regards,

HR

[abhilash_kumar · Accepted solution]

Hi Sruthi,

For Previous Year use:

Year({?Date_prompt})-1

For Current Year use:

Year({?Date_prompt})

-Abhilash

[Former Member · Accepted solution]

Thanks for the Reply Abhilash . but, when I created this formula in Formula Feilds and dragged it to my Report this is changing the Data along with the Feild Label .

I would Want only my Feild Label to change as " Year({?Date_prompt})-1 New Office "is this possible ? I did not know how to apply this only to the feild label .

[abhilash_kumar · Accepted solution]

1) Remove the existing Field Label

2) Modify the formula I provided to:

Year({?Date_prompt})-1 & ' New Office'

3) Drag and drop this formula field and position it as the label.

-Abhilash

[Former Member]

Thank you very much ! Its worked

[Former Member]

Hi,

Try this formula..

if  {user enetered Year} = {current year} then current year + + 'New Offices'

else

(current year -1) + + 'New Offices'

thanks,

dj

[Former Member]

Thank you dj !

Im looking for only change in the Feild Label and I alredy have the year seperated and calculated at backed but ,would want to apply the year dynamically in the feild Label as PY New Offices to 2014 New Offices

[Former Member]

Hi,

You just create a formula like this

User entered year that means you have to give the input parameter as Year..

({?Year_prompt})-1) +' New Offices'

Drag this formula into your report...same as apply to Current year

Thanks,

dj