Selection Screen Dymnamic varient

[Former Member]

I have a Date field as my selection Options. I need to save a variant where my date would between the first and the last day of the previos month.

When i check the selection varibable check Box for the date and click the selection variable button it takes me to a different screen and and i have selected dynamic date calculation.

In the drop down i see first day of the first month and its gets selected but I can select both the first day and the last day. It works as a parameter, but i want it as a select-options.

Any suggestions.

Bob

[Former Member]

I have a Date field as my selection Options. I need to save a variant where my date would between the first and the last day of the previos month.

When i check the selection varibable check Box for the date and click the selection variable button it takes me to a different screen and and i have selected dynamic date calculation.

In the drop down i see first day of the first month and its gets selected but I can select both the first day and the last day. It works as a parameter, but i want it as a select-options.

Any suggestions.

Bob

[former_member194669]

You have 2 options

1. Use table TVARVC for setting the variant values (The transactions STVARV and STVARVC are available for maintaining the table variants) then use that entries while creating dynamic date variant

or

2. If your report is custom one, then in the INITIALIAZATION event , set the date default values

ie

initialization.
call function OIL_LAST_DAY_OF_PREVIOUS_MONTH  " Find the last month end date and first date 

s_datum-low = <last month first date>
s_datum-high = <last month end date>
s_datum-sign = 'I'
s_datum-options = 'EQ'.
append s_datum

a®

[Former Member]

Thanks ARS,

I would do that but how come this valus in the table will be changed for every month. DO i have to write for an updation of this and run on the last day of every month..

Bob

[former_member194669]

May be you need to check this

I find this will help you out.

a®