prbolem in variable

[Former Member]

Hi Expert,

We have to place a variable value at the end of the report heading and the value should get refreshed whenever we change the variable by using "Change Variable Value". I have created a macro and the value will get triggered unless and until we click on any where on a sheet. But, we want to automate this one by using a macro.

Ex: Quarterly PA Host Country Details As Of (Variable Date). Please refer the attachment for further information.

Please suggest me on how to place variable value at the end of report heading by using a macro.

Thanks in advance,

Amruth.

[Former Member · Accepted solution]

HI Amruth,

No need to use macros here. Just create a text variable at querry properties.

Khaja

[former_member189638]

Goto the Query Description and click on the Text variable icon.

Create a text variable of processing type as REPLACEMENT PATH and replace it with the characteristic for which you have a ready for input variable that will be eneter by the user.

This will populate the text variable with the value entered by teh user.

Use this text variabkle along with the Query Description. So your description will look something like REPORT_TITLE&TXT_VAR&

Hope this helps.