Select Options, Report Painter

[Former Member]

How can I create "Select Options" for a variable in the "General Data Selection" of the report painter screen.

Thank You.

[Former Member]

Hi Nagaraju,

1. Are u talking about this select-option

functionality in normal SE38 program

or module - poool.

Regards,

Amit M.

[Former Member]

The question is for the selection screen of a report painter object ( created via transaction GRR3 ) and not for normal reports ( created via SE38 ).

[andreas_mann3]

Hi Nagaraju,

have a look here: http://help.sap.com/saphelp_47x200/helpdata/en/5b/d22d7043c611d182b30000e829fbfe/frameset.htm

regards Andreas

[Former Member]

If you specify selection parameters for several years and periods in a

Report Writer or Report Painter report, the characteristics year and

period are taken into account independent of each other.

A report with the selections:

From-year : 1997

To-year : 1999

From-period : 003

To-period : 008

will hence select all the following data:

003/1997 .. 008/1997, 003/1998 .. 008/1998, 003/1999 .. 008/1999

This is the standard behavior of Report Writer and Report Painter

reports.

However, reports which directly display the data for the period

003/1997 ............................................. 008/1999

are required in some cases.

You can achieve this in the report definition using the following

procedure.

Additional key words

several years several periods GS274

rolling periods, rolling

SUPPORTGUIDE 20010330131459

REPORTWRITER, SGRW_DOCU_CONS_NOTE,

SGRW_OM SGRW_PS SGRW_PC SGRW_SL SGRW_PCA SGRW_EC SGRW_LIS

Cause and prerequisites

This is a standard behavior of the Report Writer.

Solution

A procedure is described below to implement the selection over a period

of several years and periods. This is merely an example which should

serve as a support for experienced users of the Report Painter and

Report Writer when defining their own reports.

1. Definition of auxiliary column 1: 'All-periods'

Period: 0 ... 17

Year: From-year .. To-year

000/1997.....................................................017/1999

Definition of auxiliary column 2: 'Periods before'

Period: 0 ... From-period - 1

Year: From-year

000/1997..002/1997

Definition of auxiliary column 3: 'Periods after'

Period: To-period + 1 .. 17

Year: To-year

009/1999..017/1999

Definition of the formula column:

Formula = 'All-periods' - 'Periods before' - 'Periods after'

000/1997.....................................................017/199

9

000/1997..002/1997

009/1999..017/1999

003/1997............... 008/1999

Hide the three auxiliary columns. The formula column now correctly

shows the required period

003/1997............... 008/1999

Note:The new reporting table RWCOOM is also available as of Release 4.0

for reports which were, up to now, defined in table CCSS. RWCOOM

contains the characteristic FISCPER which represents a combination of

year and period. You can directly define reports over several years and

periods using characteristic FISCPER without having to follow the

procedure described above.

Please take into account that you cannot call reports via report

Interfaces in the formula columns (see Note 98187).

If you have any query, you may reach me

Dr. Ravi Surya Subrahmanyam, PhD Finance,

SAP FICO Consultant,

Answerthink (India) Limited,

Hyderabad. AP. India

Phone : +91 9848550024

Email : fico_rss@yahoo.com