key date display.

[Former Member]

Hi

Our report displays data according to key date given in the variable.

When a user enters a key date, the report displays the following data

col1=keydate sales

col2= MTD

col3=YTD

Here our requirement is when a user gives keydate and execute, The key date shuld be displayed in the report. Is it possible in report to display the keydate.

REgards

Annie

[Former Member · Accepted solution]

hai,

Go to formula...create new formula...in that use customer exit...u can able to get the report which user feed the date....

Thanks & regards,

prakasu

[Former Member]

Hi Annie,

In v3.5, this requires that the query is saved in a workbook. Once you have the workbook saved and the data refreshed, choose the 'Layout' button from the BEx toolbar. Choose 'Display Text Elements.' Finally choose 'All.'

You will see all text elements appear. Deleted the rows that do not need to be displayed, leaving Key Date. Then 'Save existing workbook.'

I Hope this helps,

Larry

[Former Member]

i am not sure if any other better way exists.. but we have done as below

create a formula variable(IX_KEYDT) - customer exit varibale with date dimension, and in the exit, make it as a copy of ur key date.

CASE i_vnam.
WHEN 'IX_KEYDT'.
 IF i_step = 2.
  LOOP AT i_t_var_range INTO loc_var_range WHERE vnam = '0P_KEYDA'.
   CLEAR l_s_range.
    l_s_range-low    = loc_var_range-low.
    l_s_range-sign   = 'I'.
    l_s_range-opt    = 'EQ'.
    APPEND l_s_range TO e_t_range.
    EXIT.
   ENDLOOP.
 endif.
endcase.

.

create a new column - selection - just drag drop ur formula variable..

*'0P_KEYDA' is the technical name of key date.

hope it helps

[Former Member]

Hi

Thanks for the code, its running fine.

But the problem is the user dont want that to be displayed in the column. Client wants that date to be displayed at the top of the report.

Ex: The chara which we put in Free characterists. In the same way he wants that the date to be displayed there.

Is there any possibility.

Regards

Annie

[Former Member]

in this case, i think u have to go for WAD.. there u can bring in text elements to show the input variables..