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

Advertisement

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 Excel. But this report is not as expected as it has many blank cells, misplacements etc and looks really ugly. so Is there anyway to get an excellent spreadsheet as output.
If anybody needs any more information on this, please let me know.
Thanks in advance.

Advertisement

Thank you so much Marwim. Your suggestion is very helpful. But I have some other Oracle reports which have only one .rdf file giving output in both pdf and Excel. This doubt might be silly. Almost same features were existing for the rdf what I am working now. For the remaining reports, it was given that DESFORMAT=SPREADSHEET , what this report lacks. I googled and found these links http://docs.oracle.com/html/B13895_01/orbr_paptoexcel.htm &
http://docs.oracle.com/html/B13895_01/orbr_paptoexcel.htm#CIHFDJAJ . But they are not intended for excel output. they generate only web layout in spreadsheet form. Could you please suggest any other ways to achieve this.
Thank you in advacne.
Edited by: user07960 on Jan 10, 2013 10:47 AM

October 11, 2015

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

How to get a wallet (like in Nokia 6600) for Nokia...

Dear All, Can you please tell me how to get a wallet (like in Nokia 6600) for my Nokia E63? Narottam Das Kolkata, IndiaUsing the data from your Excel spreadsheet, this is what I get from the curve-fit functions: Seems like a pretty-good fit to me. I'

How to get to see the usernames and passwords for wifi logins on iPad

How to get to see the usernames and passwords for wifi logins on iPad. You can't access that on an iPad. The iPad does not have a Keychain Access type app like the Mac has. Maybe an application like iExplorer on your Mac will let you see them, but yo

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 send a PDF file as a FAX from Oracle Reports 6i

Hi I want to know how to send a PDF file as a FAX from Oracle Reports 6i. Or please post any sample code in reports that sends PDF document as FAX Help need immediately. Thanks in advance. my email id is [email protected] Arun nullhello, there is no

Help!! How to get this effect in Photoshop?

How do you get this effect in PS7? http://www.cobrastarship.com/media/justblaize.jpg Thanks soo much!!Photomatix. http://www.hdrsoft.com/gallery/index.php    @ ChrisRead other 10 answers

RE: How To Get  More Effects, And Presets

Hello Everyone. How can I get more Effects, And Presets for Premiere Pro CC. Is It free, or we have to purchase them ? Thanks.Search for them . Google "Premiere plugins" Some are free and some are for purchase. You cant buy presets. Maybe you ca

How to get date appended in the filename of the IR reports

I have a requirement where in i need to generate the output for the IR reports with a date appended in the output name. The report is scheduled daily. The generated output should have a date appended to it. For example - if the report say 'abc' gets

How to get EBS Concurrent Request number (and more) into BIP Report Layout

hi, I have been using BIP for 9 months but have several years experience of Reports 6i development (matrix, drill-thru etc). We are beginning to use BI Publisher with EBS and would like to be able to incorporate the Concurrent Request number into the

How to get the measure total at row level for another measure calculation in DAX?

Hi There, Using DAX, I am trying to get an expression for a calculated measure as follow: So basically, I would like to get the AMeasure total highlighted in yellow in the A2Measure calculation: Smeasure -(Ameasure total * WMeasure) where Ameasure to

How to get maximal value from the data/class for show in Map legend

I make WAD report that using Map Web Item. I devide to four (4) classes for legend (Generate_Breaks). I want to change default value for the class by javascript and for this, I need to get maximal value from the class. How to get maximal value from t

How to get  the values of bdcmsgcoll to be printed in report

hi experts, I am updating Va02 using BDc .. this is done however  i m struck at this point.. I want to display the log i.e  messages  like data was updated ,, or any error ... As far as i know these logs are stored in BDcmsgcoll but how to get these

How to get the total number of pages printed in a report?

Hi All, I have a requirement where I need to print a frame of fields only in the last page. Unfortunately I cannot use the 'Print Object On' property as it doesnt work in my case. So, I am planning to write a format trigger on the frame to return TRU

How to check the row level security in TOAD for oracle

Hi , for ex, i have 2 types of users normal user and super user super user can see the group set (some column name) created by normal user but normal user can not see the set created by super user this set crestion aslso has 3 types "U','P',S' P &

How to send emails from of pdf's generated by oracle reports

I have several pdf documents , I want to email those pdf's . Please let me know how to send emails from oracle reports . Thanks, PrevinI have integrated Oracle Reports with Oracle Portal and used the scheduling feature via portlets. We have reports t

FCPX - How to get this effect

I am in total awe of the effect in this video. Can someone tell me how to achieve it in FCPX? A video is playing through the silouette of a man's body or so it seems. http://youtu.be/KLVq0IAzh1AI see Sting, a daylight shot of people walking around an

How to get itunes 10.5 to stop asking for admin password to play video files when telling them to open from windows explorer

how do i get itunes10.5 to stop asking for administrator password everytime i tryto open a .mov file from windows explorer. itunes is set as my default mov player.OK, lets do a complete overhaul to make sure it's working ok. First to check your Windo

How to get waves maxx audio, dolby sound room for other toshiba laptops?

Hi, I have a A205-S5803 toshiba notebook that previously had vista , then xp, now windows 7 32 professional. I had a problem with xp where the sound volume was quite low even though turned up all the way. However, when I installed windows 7 professio

How to get Current week and No of Weeks for each quarter!!

Hi, As a part of report development I have to derive Current week and No.of Weeks in Curreny Query. Based on these information I have to calculate Phased target (Calculated KYF). Phased target = (Target for Quarter / No of weeks in Current Quarter) X

How to get all kind of GP work items for all users

Dear all:    Basing GP implementation,we can only get the single user's work item. Is that possible to get all of the users' work items,and can filter the work item via time field?   thanks a lot.ISearchResult result=UMFactory.getUserFactory().getUni