report painter
TRANSCRIPT
![Page 1: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/1.jpg)
Create (in your case add report group to my library ZA2) a library
GR21
![Page 2: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/2.jpg)
Create Account GrpsKDH1
![Page 3: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/3.jpg)
GRR1 Create a report
![Page 4: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/4.jpg)
![Page 5: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/5.jpg)
Click ON CREATE
![Page 6: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/6.jpg)
Go to EDIT and GEN DATA SELECTIONCheck and Confirm
![Page 7: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/7.jpg)
Dbl click on Row One
![Page 8: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/8.jpg)
And Insert Account check and click on text and confirm
![Page 9: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/9.jpg)
Go to edit rows and explode and expand
![Page 10: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/10.jpg)
Change the desc in lead column to Gen Ledger Account
![Page 11: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/11.jpg)
Dbl click on Column and select DR/CR indicator
Click on check and confirm
![Page 12: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/12.jpg)
Increase the width of lead column to 60
![Page 13: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/13.jpg)
Click on Execute
CREATE A NEW RPT GPGo to new session
T-Code GR51 copy from Rpt group ko07
![Page 14: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/14.jpg)
Click on Hat to add/change description
![Page 15: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/15.jpg)
Include the Rpt in your rpt Group
![Page 16: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/16.jpg)
Go to Extras report text and headers to add custom header fields
![Page 17: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/17.jpg)
![Page 18: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/18.jpg)
Create Rpt with Actual, Plan, Variance, %Variance, YTD Act, YTD Plan, YTD Variance and YTD %Variance.Final Report should look like this after executing in the screen Below:
![Page 19: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/19.jpg)
Final Report
![Page 20: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/20.jpg)
GO to TCODE GRR1
![Page 21: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/21.jpg)
Create a new report
![Page 22: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/22.jpg)
Go to Edit Gen Data Selection and select the following
![Page 23: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/23.jpg)
Enter the Values
![Page 24: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/24.jpg)
Check if follw has been updated
Click on Check and Confirm
![Page 25: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/25.jpg)
Double click on Row One
![Page 26: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/26.jpg)
Select Account Number in the ROW CLICK on Check and Confirm and click on pencil to input
Copy short text
![Page 27: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/27.jpg)
Click on Column and select Key Figure
![Page 28: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/28.jpg)
Select period and record type
![Page 29: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/29.jpg)
Click the Check Pencil for short text and then confirm
![Page 30: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/30.jpg)
Go to next column for Plan --- Just double click dummy!!!
![Page 31: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/31.jpg)
Enter Text as Plan
![Page 32: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/32.jpg)
Go to next column and double click and input Variance which uses a formula
![Page 33: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/33.jpg)
Formula as below and Check
![Page 34: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/34.jpg)
Enter Text and Copy short text
![Page 35: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/35.jpg)
Now go to next column for Variance % this is also a formula
![Page 36: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/36.jpg)
Variance% formula as below
![Page 37: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/37.jpg)
Now create a YTD-Act column
![Page 38: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/38.jpg)
Enter the Values as below in the YTD Char Values
![Page 39: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/39.jpg)
Enter Text and Copy short text
![Page 40: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/40.jpg)
Next go to YTD-Plan by double clicking
![Page 41: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/41.jpg)
Enter Values as Below
![Page 42: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/42.jpg)
Double click on Column for formula YTD Plan – YTD Act
![Page 43: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/43.jpg)
This a Formula, enter as shown below
![Page 44: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/44.jpg)
Enter and Copy short text
![Page 45: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/45.jpg)
Go to the AKHRI column to put YTD-Variance% it’s a formula
![Page 46: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/46.jpg)
Enter the formula as below
![Page 47: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/47.jpg)
Enter and Copy short text
Now click on Rows to explode
![Page 48: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/48.jpg)
Single click on Row P&L Account and go to Edit—Rows--Explode
![Page 49: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/49.jpg)
![Page 50: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/50.jpg)
Select Expand button as below and click OK
![Page 51: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/51.jpg)
Double Click on Lead Column AND change the short text to P&L account
![Page 52: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/52.jpg)
Copy and confirm
![Page 53: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/53.jpg)
Now Save your Report and now you can Format the report, for this Go to Formatting ---Report
![Page 54: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/54.jpg)
Change the lead column width to 60
![Page 55: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/55.jpg)
Now to beautify the reports goto Extras--Headers
![Page 56: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/56.jpg)
Enter Header
![Page 57: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/57.jpg)
Now Select Insert ---Std Variables to add variables like Author, Report Date etc.
![Page 58: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/58.jpg)
![Page 59: Report Painter](https://reader033.vdocuments.us/reader033/viewer/2022061104/5413c7687bef0a0e7b8b461d/html5/thumbnails/59.jpg)
The Final report shows the Following result.Here the Actual in column 1 is for Month 03/2008 but the YTD column shows the actual inclusive of Exp and Revenues in month of Jan, Feb and March to date.
Cheerrssss!!!!!