----Original Message----- Subject: Report Painter,Relationship between Report Groups and Reports
Dear Report painter gurus,
What is the relationship between Report Groups and the Reports assigned to them ? My problem is that, when I leave EMPTY characteristics in one Report, I cannot Execute ALL other reports assigned to the same Report Group as the First Report (the report with the empty characteristics)
So it seems that whatever mistakes I make in one report, affects ALL the other reports within the same Report Group. Can someone verify this for me ?
Thanks in advance !
-----Reply Message----- Subject: RE: Report Painter,Relationship between Report Groups and Reports
I have found that by far the safest way to proceed is to have a one to one relation ship between a report group and a report. otherwise all sorts of strange things start to happen.
----Original Message----- Subject: Library for Report Painter/Writer
Hi Sappers I just have one question regarding Report Writer/Painter Is it possible to create new library based on whatever table we want which is not SAP installed. For exmaple, in PCA, there is standard library 8A2 which si based on GLPCT. Is it possible to create new library based on table say GLPCA? If so, what's menu path to add table in Library? I am on 3.1H.
TIA
-----Reply Message----- Subject: RE: Library for Report Painter/Writer
As consultants always say: "Do you really want to create reports on table GLPCA?". All the information is in GLPCT and in addition performance with reporting on GLPCA would probably be very bad.
I wanted to get period information form PCA. And it looks like GLPCT does not give records per period (period field is 16 or other value) but only the cumulative values per period are stored in specific fields. So i thought I needed a report on GLPCA, but I use libraries based on GLPTC to get the information from GLPCA. Apparently by selecting periods (RPMAX) in reports, SAP will show all the GLPCA records for that period, but it will get it from the summary record in GLPCT. Don't ask me how, but it works.
hope this helps.
Regards,
-----Reply Message----- Subject: RE: Library for Report Painter/Writer
You should be able to make a dd table available to Report Painter / Writer if you can create an Evaluation structure for the table.
To create an Eval structure In Logistics: Tran MCS7 - Create evaluation Structure. (Path: Logistics >Sales & Distribution >Sales Info System >Flexible Analysis >Evaluation Structure >Create)
You could name the Eval Structure "ZFGLPCA", (must begin with "ZF"). Then click
( if this is a table and not another Eval structure.) Enter the DD table "GLPCA". And click the check mark. Then click and mark all the characteristic fields you want to report on, (if you right click you can
-----Original Message----- Subject: Report Painter, How to reverse +/- signs
Dear Report Painter gurus,
I am trying to reverse the +/- signs in my P/L statement, which I created using Report Painter. Could someone please help me out ?
Regds,
-----Reply Message----- Subject: Report Painter, How to reverse +/- signs
Try using the Absolute value in your formula as follows:
Ex: (X003 / ABS X002)) * 100, or whatever variables you need to use.
I find that this usually reverses the appropriate signs.
In the report, there is also formatting available that will reverse the signs. Do: In Report Writer: Change report screen, (transaction GRR2), Formatting-->Row-->reverse signs.
However, this will reverse all signs in the statement. You may not want that.
