I was asked a question on one of the comments.
How to make XML output to be displayed in excel spreadsheet, when the report has been registered to run using XML Publisher?
Thankfully my friend Fabio kindly sent me these screenshots/steps
Add highlighted line using System Administrator > Install > Viewer Options
Add the following for each listed user.
Comments
This is fine, But what about the Template?
How will we develop the template for excel output
Thank s
Tony
W hen setting up the template we opted for RTF as the type, however this will need to be amended at run time using the Options... button prior to submitting the Concurrent Request.
Once clicking on the Options button, you should see the template you have assigned to this concurrent request, you will need to change the format from PDF/RTF to EXCEL. Click OK and submit your concurrent request.
This should then allow you to open the output directly into Excel.
Than ks for sharing this.
Regard s,
Anil
Thanks for posting such useful information.
I tried the same and it is working .
I have a small doubt in this.
I have set the viewer text at my user level.
But when I login as different user and use
tools-->copy , i am getting viewer option.
What should I do that it will not affect any other users?
It will also be useful if you explain the different levels wherein the viewer option can
be set.
I got the solution, thanks for the patience,
I am getting the Excel Output now, but with a white background(as the template is rtf and has a white backgroud), How can we avoid this white background
T hanks
Tony
You can amend the background on your .rtf document which will then change how the excel spreadsheet looks.
Thanks
Fabio
How can we customize any Report 6i to produce .csv file output enabling the user to open it in excel?
Thanks.
Hariom..
I have tried the same as explained by u, but i couldn't get the outpout in Excel sheet.
The output file is empty.
The log file has the error: REP-3000: Internal error starting Oracle Toolkit.
What should i do to overcome this.
Kindly help me out.
Thanks in advance.
Is there anyway we can set default Preview mode from PDF to excel so that while submitting XML report for excel output we need not to go to option screen to set Format as excel.
Thanks,
Vineet
I have been stuggling to get reports to output to an Excel spreadsheet for some time, so I was hoping this would solve my problem. Still no luck. Output file is empty. PDF output is fine, so process/templat e is not the problem. Is XML publisher version relevant to the solution? According to Metalink Note 358296.1, Excel output problem is a bug that has been solved in version 5.6.1. I am working on version 5.0.1
Anyone got any suggestions?
C heers
MicheleC
Hope you are well, it was great to catchup with so many friendly people in SA.
If you are using Excel 2002, then you must be on at least XMLP 5.6.1
Also, if you are on CU2, excel output will not work from FNDRSRUN (View Requests).
This issue was fixed in CU3.
Thanks,
Anil Passi
Sorry for the delay in replying but thanks for the feedback. Will be upgrading XML Publisher soon. Then will retry.
And glad to have you in South Africa. It was great to share tech info with you. Hope you will return someday.
Cheer s
Michele
We get asked this a lot as well. Does anyone have any ideas? As far as I know it is not possible.
Than ks!
Janel
Once I had my friend calling me of such requirement to work on a Oracle report. They wanted the o/p to be displayed on Excel rather than on the browser. They did not have Excel installed as an option in Install- Viewer Options. It was an older version of EBS where there was no XML publisher.
Sol ution: Once the report o/p is generated, Just ask the user to Save the o/p file as .csv. This would resolve the issue.
It works irrespective of user.It is a simple solution. But those were old days, but now since we have XML Publisher in place, I would defintely like to try and explore ways suggested by you all.
Thanks,
R C Pandre
;D ;D
Is it possible to create editable PDF reports in Oracle applications?
Thanks in advance,
Ram.
You might like this post also:
http://garethroberts.blogspot.com/2007/10/excel-file-output-from-oracle.html
Gareth
I have the rtf template (preview shows me excel output as desired) attached in XML publisher , alsofollowed above steps but once i submit the concurrent request (set the option as excel) i get a warning "unable to find the published output for your request"..where am i going wrong
Thanks
Currently I am developing a XML report.This is my first XML report. I have a requirement to pass a parameter for order by from the concurrent program. I designed the template in RTF format. Everthing is working fine. But, I have no idea how to create a dynamic sort in XML report. If anyone has any idea please share with me.
Thanks in advance
Vathana
------ ----------
chicagohouses.cn
my data is varchar2(tax code) as :00123456789
when output excel display : 123456789 loss 00 (excel is number)
Please, give me solution
thanks
quang
I have a simple XML report whose output I want to show in EXCEL format. I have followed the steps below:
1. Set the profiles for the Excel (for which the screen shots were provided).
2. Entered the concurrent program name in the SRS form
3. Before Submitting the request, I changed the Format to EXCEL.
4. Submitted the request.
The request completes normal but when I click on the View Output button, it says NO DATA FOUND and in the Details with the below error:
ORA-014 03: no data found
-------- --------------- --------------- --------------- ---------
FRM-4 0735: WHEN-BUTTON-PRE SSED trigger raised unhandled exception ORA-06502.
Ple ase suggest.
Thank s
Sudhamsu Josyam
I hope for this problem you need to install the patch (4334965)
I hope this is the solution if you are using 11i.
I hope this may solve your problem.
I hope you can see the output in Excel Format.
Regard s
Raghu
i Want to get the value for supplier code, supplier site, beneficaiare name etc.
pl. let me know where will i get these information
I have a doubt on the screen shots attached...
In the set up steps : 1) Does it mean by setting up the first step...always outputs of XML reports are in Excel format?
2) In the second step, by setting browser in the user level. It overrides the setting up of Excel in Site. Please let me know what is
the purpose of setting up of Browser in user level.
Thank you
Ashwini
Firstly Thank You for sharing such useful information in a detailed way!!!
I created a report with output type XML and also created the required data definition and the template . When I run the report through SRS ,I choose the output type to be EXCEL. Even the preview style in the datadefinition is EXCEL . The report completes successfully but when I click "View Output" browser opens up and then it closes off but no data is seen .
Not sure where I am going wrong . I even tried the same report registered as the new concurrant program with output type as "TEXT" but even in this case if I select "Microsoft Excel" in viewer option that is seen a browser open and it closes off . No excel sheet is seen .
Please suggest .
Thanks and Regards
MP
I have a XML Publisher report, when I run the request for the report I change the option to Excel format and sumit the request. But the output in Excel format has all fields wrapped and also the amount fields does not behave as Number field to summarize. Please help
Thanks
Welcome to xlspe.com
Thank you very for sharing this useful information.
Could you please let me know how we can zip the file before bursting the file to the user?
Thanks,
Baksh.
thanks for the info..i have a query.
I am getting 'unable to find the published output for this request' error when running my xml report.
fyi please...i am able to run the same report with same setup in once instance but not in other .
Can you please help me in this.
Regards
G opal
I tried in this process, My programs gets completed and Normal, Whenever I am going to view the output it is showing that No Data Found.
Please let me know where I have gone wrong....
Thanks
Karunakar.
RSS feed for comments to this post