GR55, Report writer expert needed

[Former Member]

Dear all,

I have to maintain a report based on a custom library in which the period (month) is a  characteristic, means it should be used in a selection or in a row. Anyway customer wants the columns of the report (key figures of the libary) to be restricted to certain periods or period blocks  (e.g. turnover YTD). In the underlying DB table summarized fields are not available (e.g. YTD) just a value for the period. DB table and library cannot be changed since other report are based on them. I know it means mixing up rows and columns but it is the given situation.

An example of the requirement:

Selection period: 5-9 (May to September)

Result should be like:

                         selected period          YTD          Year

turnover               100                         200               300

This result is of course not possible if only records from May to September are selected, which is the standard behaviour of report writer when the period is entered at the selection screen. But if the entered period is not used for selection but only stored in a variable for later use there could be a way out.

It is possible to restrict columns to a period block (e.g. YTD) by using "from to values" in 2nd level Basic Sets! I tried and it works.

So my question is: Is there any way to get Information about the period from the user and this information should NOT restrict the records selected. The Information should just be stored in a variable for later use.

I hope the question is somehow clear.

Thanks a lot in advance

Michael

[Former Member · Accepted solution]

Hi..

I created report painter by your requirement as below picture.

[Former Member · Accepted solution]

Dear Big Choi,

thanks for the reply.

Although period is marked as a characteristic in the library - which is a custom one - it is not shown in the available element characteristics in Report painter. There might be something wrong with the library. There is no Evolution structure for that library (MCB2), so maybe T804x tables have been edited directly.

On which library is your example based?

Thanks

Michael

[Former Member · Accepted solution]

Hi..

I created the report painter using library "1VK".

[Former Member · Accepted solution]

Hi Michael,

I agree with Big Choi's suggestion. In your case Period should not be used in General Data Slection but rather in column definition.

You can create sets with variables.

Thanks,

Szymon

[Former Member]

Hi,

so at least I know what I cannot do.

Anyway thanks a lot

regards

Michael