cancel
Showing results for 
Search instead for 
Did you mean: 

Actual Contribution Margin Report - Export to Excel

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Abhijit,

I am able to do it now. Thanks.

Regards,

Rahul

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Abhijit,

Thanks for the reply. I am able to view the classical report now.

But am not able to export to Excel. Its asking me to enter a file in DAT, TXT or RTF format. Please suggest.

Regards,

Rahul

virendra_pal
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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