on 12-04-2009 10:36 AM
Hi everybody,
I am working on a report to view the profitability of project. I took report S_ALR_87013566 - Actual contribution margin.
My requirement is as follows,
1. Separate column is required to capture the cost elements
2. To export the report to EXCEL. I am able to do only HTML export.
Please suggest and advice.
Thanks,
Rahul
Dear Rahul
Export the report in DAT format. Then open the DAT file with Microsoft excel and your will be able to view the report
Regards
Abhijit Sen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Go to CJE5, select report 11ERL1B, Go to drilldown report ---Change
Select output type tab----Click on Classic drilldown, then Basic list:Detail and Available on the selection screen.
Then save it
After this output type will be available on the report secreen
Regards
Abhijit Sen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
run report in classic output
you should be able to export it to excel output .xls
to add column you need to buoild a custom report
however you can call up line item report to display cost elements from the classic output
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Virendra,
Thanks for the reply.
In my Sandbox & Quality server, am not able to view the Output Type radio buttons in the front screen of report. So am not able to select classical drilldown report output. It comes in graphical report output automatically. But the radio buttons are displayed in IDES server.
Do i have to configure for getting those radio buttons in Sandbox / Quality? Please advice.
Regards,
Rahul
User | Count |
---|---|
88 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.