Moan about Reports ability to output to Excel

Advertisement

Hi there
This is more of a general moan on this topic, but am I the only person who thinks that Oracle Reports' ability to output to excel should be WAY better than it is at the moment?
I've just looked at the 9i demo, showing how to get report output into excel. It was horrific - grubbing round in raw html code and setting up an Excel template with dummy data doesn't make Reports the slick reporting tool that we'd all like.
Guys @ Oracle - have a look at Cognos Impromptu - I'm definitely no fan of Cognos, as I prefer to be able to define exactly what I want in SQL. However, one thing they have got right is the facility to save report output into formatted Excel - Oracle Reports should have this too!!
At the moment, if I'm asked to produce a report in Excel format, I have to either use PL/SQL to generate a CSV file with the results I want, or Oracle Reports to produce a similar CSV file. I then have to open the CSV file in Excel and format it, change column widths etc, so that it looks presentable. If it's a regular-running report, I have to manually intervene every time the report is produced. Producing a similar report in Cognos (for all its faults) would require no manual intervention once it's set up, and the whole process can be controlled with macro language and the Cognos Scheduler.
So please, improve this feature of Reports!
Andrew Woodward
UK

Advertisement

Hello again
All I'd like to be able to do is to write an Oracle Report and have the figures from the report delivered in an Excel spreadsheet. (A number of report users here specify that they want their reports delivered in this way.)
Oracle Reports (I'm on version 6i) allows me to generate a .csv file which will open in Excel, but there's no formatting present. My point was simply that I have to manually intervene to produce a .xls which is formatted properly. In Cognos Impromptu, after the report has been run, you just select SaveAs->(input filename) and select 'Excel with Format' for SaveAs Type. The output is a pretty good approximation of how the output appears on the screen. You can run reports automatically using a scheduler, and with macro language, you can deliver the report in this format with no further intervention needed. If Cognos can do this, then so can Oracle!!
Incidentally, I've noticed that every post on this forum which mentions Excel receives a plug from Lion Van for his RepExcel product. I had a look at his website and it looks pretty good - perhaps Oracle should approach him with a generous offer?! I'm not sure however that these forums should be used for advertising in this way.
Best regards
Andrew
UK

October 11, 2015

Moan about Reports ability to output to Excel

Hi there This is more of a general moan on this topic, but am I the only person who thinks that Oracle Reports' ability to output to excel should be WAY better than it is at the moment? I've just looked at the 9i demo, showing how to get report outpu

Reg. J1INEMIS report (problem with output in excel)

Dear Experts ,                          In J1INEMIS report , when i save the output data in Excel file , last digit of vendor codes are missing in vendor code column even i optimized the width of column. Kindly provide some guidance. Regards shailesh

The best way to get reports 6i output into Excel 97

Hi there, I have a number of graphical reports that have a few group levels. These generate HTML or PDF output ok. I want to get the output to look as close to the HTML/PDF output from Report Server or Runtime into Excel 97. Outputting as HTML and im

Report Builder: output to Excel removes leading zeros

I'm trying to use the Report Builder to output a numeric field to EXCEL , but on numbers that start with zero EXCEL removes the leading zero's. ex. 00123 becomes 123. Is there something that I can put in the expression builder on the field to overcom

How to Generate HTML Report Output in Excel

Dear Experts, How to convert HTML report output in Excel. I have reports which output is coming in HTML format & the same I want to use in Excel. So tell me how I can covert the same in Excel. Thanks Sudhirhello, in your case, you might want to make

Oracle reports output in excel format does not display the graphs

Oracle reports output in excel format does not display the graphs: "linked image cannot be displayed". The output file in PDF format the graph is supported.Do you have any header and footer on your template? If you have any header and footer the

I want the ebs report to give me an output in Excel

i am a bit new i can only view txt and pdf files as output from my ORACLE ERP. I am able to change the file in the concurrent request definition window to XML but when i run the report from my HRMS resp. it gives me TAGS and not the output in excel.

Sending report output to Excel

Dear buddies I'm using OLE Object in my report to send its output to excel. I find this way from an example at the same forum. But I feel that this example is for very small sized reports which have to send a few cells to excel because in this method

Report output in excel format.

Dear Friends, I have created a report in character mode and I want to store the output of that report into an excel file. So that data of each column with heading will be stored in seperate coulmns(with each row of output in each row in excel file).

Problem when dowloading the ALV report output to Excel Sheet.

Hi , I am dowloading the ALV report output to Excel Sheet. There is field Condition Unit(KOMP-KMEIN) in the output of the ALV, this has values PC and CSE , but when I download to Excel Sheet, CSE is appearing as CSE ,but PC is appearing as ******. Ca

XML Publisher report default output in Excel format.

Hi, We have defined one concurrent program whose output format is text, this concurrent program executable is PL/SQL and in this PL/SQL program we are generating XML data and displaying XML using below fnd_request. l_conc_id := FND_REQUEST.SUBMIT_REQ

Why Reports format behaves different in Excel and browser(if desformat=html or pdf)?

1-Why Reports format behaves different in Excel and browser(if desformat=html or pdf)? 2-I made three queries Q1,Q2 & Q3 and linked them with proper field links but suppose Q3 returns no records for some Q1&Q2 records & when the report runs fo

Want to convert RDF output in Excel & Pdf Format.

Dear All, I want that when i run my report with showing the output report builder also convert that file or ask me an option in parameter that in which view you want to see the output of the report in Report Builder, In Excel, or In Pdf. when i choos

Report Manager - Template Conversion Problems Excel 2003/2007

Hello, We are having an issue in which templates created using excel 2003 are showing incorrectly formatted outputs in excel 2007. We have performed testing by creating new templates in Excel 2007 and most formatting is correct as long as we only mak

Urgent : output in excel from reports6i

I am running reports 6i on the web and we want the output in excel. we have applied the patch 11 so that we can output in excel. what r the things to be changed in reports and elsewhere so that i can get the report output in excel I have changed the

Output to Excel sheet

How to copy the contents of output into excel sheet?Hi, Check the below example, to download the ALV report output to an excel sheet. REPORT Z_CONCEPTALV . TABLES: KNA1,VBAK. DATA: ITAB TYPE TABLE OF VBAK, CONTAINER TYPE SCRFNAME VALUE 'ALVCONTROL',

Composing the URL to call a report to render in the Excel format - SSRS 2012

Hi, I've a report that I need to call by an URL. I've composed this link, using the rs:Format=EXCEL command, but I've an error because the max number of rows is 65.536 for the current version of Excel and the extracted data are more of 150.000 rows.

FSG output in excel

hello all, Is there any way to publish FSG report in excel? I remember we had one report to generate FSG in excel in 11i but that report I can not see in R12. Is there any patch that I need to apply? Thanks DJHi: You can try this. 1. Set the output t

XML output to Excel

From an XML newbie. Hi all If I generate a report in XML output from Reports10g, which contains data like 01, 02, 03, etc, and then import this into Excel 2003, how do I ensure that the format of the data is preserved, and not imported as 1,2,3, etc?

Getting swf  movie report n the output window?

i am getting a swf movie report in the output window and nothing else, cant get rid of it help please?when i test the movie the output window just displays a list longer than my arm with the title swf. movie report in the output window meta data or s