Text Varialbe question

[Former Member]

Hi Gurus,

I am customizing query 0FIAR_C02_Q1003. We have one query variable for fiscal period which user enter before running the report. We want to concatenate this user entered fiscal period with a report column.

I have created a text variable with replacement path and used source as the variable. But when I run the query I see the tecnical name concatenated with the column heading text.

e.g. Fiscal period variable input : 08/2008

I want to see column heading as 08/2008 Period Balance

But I see as ' variable tech name' Period Balance.

Please help.

Regards,

Anil

[Former Member · Accepted solution]

Thanks a million Arun. Can you give me any link to a how to guide. I am trying this since last 10 hrs..but no luck...

Regards,

Anil

[former_member184494 · Accepted solution]

Anil,

I am not sure if there is a how to paper for the same and I do not have access to a system at present - but did use text variables to dusplay user selected values some time ago.

[former_member202718 · Accepted solution]

Hi Anil,

Create text Variables,For Example ,say 0CUSTOMER.

1)Right Click on the 0CUSTOMER and Create a input Variable say YCUST and save.

2)If ur using 0CUSTOMER in the RKF,then drag both the 0CUSTOMER and KF say 0QUANTITY in the new selection.

3)After the Description of the RKF there is a = sign click on that to VIEW and CREATE Text variable.

4)Create New Variable ,enter the tech name(say YCUSTMER) and dscription and in the same screen choose type Replacement PAth after which u will get a set of infobjects.

5)choose 0CUSTOMER

6)In the Next screen choose the Tech name of the Input variabble(0CUSTOMER) and save.

7)In the description of the RKF ,type as CUSTOMER &YCUSTMER&.

Get bak if get stuck up.

Rgds

SVU123

[former_member181964]

Hi,

See the Blog regarding Text Variables.

/people/surendrakumarreddy.koduru/blog/2009/02/26/using-text-variables-with-customer-exits-in-report-headings

Thanks

Reddy

[former_member184494]

in the header for the column - create a text variable filled by replacement path and point it to the variable that the user enters... select replacement path with characteristic - fiscal period and then select your variable and you should get the fiscal period in the column header...