Excel Output For Standard Report In R12


Hi Experts,
My Client wants Excel Output for Standard Reports ( ex:-Open Purchase Order Report (by cost center)_xml)
I changed the default output to Excel in Template of xml publisher administrator Responsibility.
Now it is showing the Excel output, but The layout of report is not same as layout which in text output of standard report.
Please guide me is there any solution to develop the reports layout in ms-excel using xml file rather than rtf template.


Hi Alex,
Thanks for your replay.
Generating the new rtf template which is same as standard layout is difficult task for us. Actually we have 120 reports which have same requirement.
Is there any other solution for this . please guide me
Edited by: 805567 on Jan 23, 2012 12:33 PM

October 11, 2015

Excel Output For Standard Report In R12

Hi Experts, My Client wants Excel Output for Standard Reports ( ex:-Open Purchase Order Report (by cost center)_xml) I changed the default output to Excel in Template of xml publisher administrator Responsibility. Now it is showing the Excel output,

How to define PO Output for Communication Report

Hi, I want to edit and add some features in the PO Output for Communication Report with 'POXPOPDF' short name by the xml publisher is there a way i read some where i found a document id Note:387670.1 but i found nothing but i want a detailed descript

How to get an effective EXCEL Spreadsheet as output for Oracle report 10g

Hi All, I am a newbie in Oracle reporting. I am using 10g. I have an oracle report whose output format is PDF from the user interface. User asked for Spreadsheet output. I changed the JAVA CODE "desformat" = Spreadsheet and got the report in Exc

Excel Output for rtf template

Hi I have a query of obtaining the output of a XML Publisher report in 2 formats (PDF and Excel). Depending on the user option (parameter),i have two query for pdf and excel output. the request should generate the output in the specified format. I ha

KSBB transaction - text to be added for standard reports

Hi, We have a requirement of changing / filling the texts for the Statndard reports and User defined reports in the KSBB report tree. Client has provided an excel sheet containg the report texts for Languages DE, EN, ES, TR, ZH and KO. We could see t

Combine multiple JPGs into 1 JPG for standard report

All I am creating a standard report and I have to include some pictures. Since I cannot align or using any of those functions, is there a way I can combine two pics (place them side by side) using picture functions and call them as 1 picture into the

Data source Infocubes for standard reports

Hello Everybody, Can you please assist - how to understand which data source will feed - which info-cube - which standard reports? I am planning to activate standard reports in various module. How do I decide corresponding data source and info-cube r

Adding Vendor Descrption for  standard report in  mb51.........

Hi Experts....    i am using MB51  Standard Report.. i want  to add the vendor description to  this standard report... please suggest in  any procedure.. hw can i write coding  for  add the descrption in  satndard program. Thanks & Regards.. Spanadan

Templates Availability for Standard Reports

There are some seeded templates are available for GL product like 'Trial Balance Detail' report. Customer wants know if the Oracle is planning to provide the Seeded templates for other Standard reports. If Yes what are the timelines. Pl. let me know

Create FM for Standard Report RM07DOCS

Hi, I am creating FM for the std report RM07DOCS. so for that i have written this following code ""Local Interface: *" IMPORTING *" VALUE(MATNRFROM) LIKE MSEG-MATNR OPTIONAL *" VALUE(MATNRTO) LIKE MSEG-MATNR OPTIONAL *" VALUE

'XML Report Publisher' not producing Excel output

when i run a report from SRS window, selecting output format as EXCEL, output comes out great in EXCEL format(no problem here) but when I run 'XML Report Publisher' and select the Request ID of the above report and give EXCEL as output format, output

Excel output display error

Hi Experts, I have an Standard Report Materials Account Distribution Report that I have converted to XML report (excel output). The report shows correct values for about 4100 lines. After that, I find that the merged cells have split and hence partia

PO Output for Communication :: Modified XSL-FO not reflecting

Hi, As per the requirement we need to add some fields in the PO Output for Communication report. I have modified the Standard PO XSL-FO and I am able to see the changes in the first page but the changes are not reflecting in the remaining pages. I ha

SAP Standard Report:  Trial balance that include trading partner

Good Morning Guru's- To avoid creating a custom report, does anyone know of a standard SAP report trial balance that includes trading partner? Thank you.  Points will be awarded promptly!Hi You can use Trading partner in the selection screen but not

XSL-FO for Standard Purchase Order, doesn't print page number

Hi, I worked on XSL-FO code to custom the PDF output for Standard PO. Everything works great: I added company logo (in a different position of the standard commented code <!-- Too easy just to uncomment... :-)--> ), i created new attribute sets to h

Searching Standard Reports

Can any one tell me as to how to search for Standard reports for modules like Fi, SD,MM etc ?Hi Transaction SE84 may be useful. Choose Program Library -> Programs Enter the application component you need (for instance MM) and run. Also find the list

Report VS Excel output using XML Publisher tool (DBMS_XMLGEN)

Hi All, Currently I am working on report generation in MRP module with Excel output using XML Publisher tool. XML tool works based on query. I have developed PLSQL block by using DBMS_XMLGEN – database package, to generate XML output of query. My que

Excel output of report on client machine

excel output report on client machine hello i am running report from app server, output is excel file... using following URL web.show_document(rpt_url ||'&report='||rpt_path||'batch_idcards_print_excel.rdf&desformat=spreadsheet&destype=file&am

1099 Misc reporting for US in SAP Standard report not containing any value

HI All, In my current clients requirement is to get the SAP Standard reprort for 1099 Misc reporting for US 1) Accordingly i have done configuration for Withholding tax for US with tax type FE 2) There are 14 WHT Tax codes under FE , like 01 = Rent ,

Asking for the standard report or function module or class  for determining no of employees under a client

Hi, Advance thanks for ur reply...... Is there any module function or class or standard report which gives the no of employees under a specific client based on country group and also gives percentage of employees belong to the client? Regards, selwin