Include Period Values in Report Columns and Selection Criteria with Report Writer

  • by Csaba Radnoty, Independent Consultant
  • May 4, 2009
By converting a Report Painter report to a Report Writer report, you can allow for the multiple use of characteristics in the report. You can include a characteristic, such as period values, in both the selection criteria and the report itself.
Key Concept

Although Report Painter is similar to Report Writer, the main difference between the two tools is the graphical user interface of the Report Painter. The use of sets in Report Writer is another difference. Report Painter, though easier to use, lacks certain functions that are available in Report Writer, resulting in certain limitations, such as the ability to use characteristics, such as periods, in both the selection criteria for the report, as well as the report itself.

Have you ever tried to modify a report to include period values on the selection criteria screen, but were unable to do so because the characteristic Period was not available for selection in the General Data Selection screen? This dilemma is due to the Report Painter limitation of using characteristics only once. For example, if the characteristic Period is already used in the report layout itself, you cannot add period values to your selection criteria using Report Painter. Therefore, you need to convert the report to a Report Writer report because Report Writer allows for the functionality of using characteristics more than once. The key to accomplishing the solution lies in a setting within the header of the Report Writer report.

In my example, I am using a custom report that you can call using transaction ZC12 (Figure 1). Note that the selection criteria include Fiscal Year but not any selection for Period.

Csaba Radnoty

Csaba Radnoty is an independent consultant with more than 12 years of SAP experience in Financial Accounting, Controlling, and Project Systems. His work experience includes a year and half as SAP Financial Systems Manager for a linen and uniform rental company, more than five years as a senior consultant with Deloitte Consulting, four years as a senior SAP systems analyst with a small software development company, and more than five years as a senior financial analyst with a government contractor. He holds a certificate in systems analysis, a bachelor of arts degree in management, and master of science degree in international business.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.