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