Sitemap

Amicuk Programming Answers

Formatting report in excel format

2015-10-11   Views:1

Advertisement

Hi, I have to generate report in excel format but I don't know how to format it for example to add a dynamic title, and to add a logo in the top of the excel sheet... any help.. thanks in advance.Hi, Oracle Portal Reports generated do not pick up the

Hi,
I have to generate report in excel format but I don't know how to format it for example to add a dynamic title, and to add a logo in the top of the excel sheet...
any help..
thanks in advance.

The replay answer
Advertisement
Hi,
Oracle Portal Reports generated do not pick up the foramting conditions which you would see in HTML/ASCII format .Hence ,TITLE ,FOOTER or number ,date formats wouldn't work in Excel format .Incase you needed formatted output ,you can use HTML/ASCII foramt.
Incase you want to use the EXCEL format.Save the Excel file and right macros to do so.
Thanks,
Anu

Go to See the other 3 answers

Issue while exporting report in Excel Format

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am facing problem while exporting the report in Excel Format. After analysis, I think that it could be due to two reasons, either we are using wrong versions of Jars, or we are using wrong API. Here is the code, approaches and problems we ar[More]

Need to convert AP Invoice Aging Report in Excel format

Category:DefaultRelease time:2015-10-11Views:130

Hi, Need to convert AP Invoice Aging Report in excel format..there was an existing Invoice Aging report in AP and that was in paper format. That we need to convert to rtf template.. There was an other concurrent program called 'Invoice Aging Report ([More]

How to create a report in excel format having two tab

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have Business requirement where customer wants to create a report in excel format having two tab. Please let me know if it is possible? I am using 10.1.4.3.2 version of BIP. Thanks & Regards, Edited by: 862749 on May 20, 2013 7:36 PMI have[More]

Cells merge issue when extracting webi report in excel format

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, We have some WEBI reports in BO XI 3.1. The reports have header where we are showing report name and some values which user selects in prompt. Now the issue is that when we save our webi report in excel format, many cells get merge. I hav[More]

Help me to download my report in excel format.

Category:DefaultRelease time:2015-10-11Views:130

Here is my code below. On selection screen I am giving three inputs. And There are two radio buttons present on my selection screen. first one is for display the report. second button name is generate(to export the report). Clicking on the generate r[More]

Subject: How to get MB5B report in excel format

Category:DefaultRelease time:2015-10-11Views:130

Dear experts, Please help me how I get automatically MB5B Report in excel format. In Layout there is no option to convert excel format. regards, rss Edited by: rs_sharma on Jun 26, 2011 10:16 AMDear experts, Please help me how I get automatically MB5[More]

How can i convert oracle report in excel format using 8i

Category:DefaultRelease time:2015-10-11Views:130

hi, I want to convert oracle report in excel format using 6i reports. please give the solution with emp table. millons of thanks in advance.You'll have to use the destype DELIMITEDDATA to render your Report in CSV format. Then set the mime type to Ex[More]

Unable to print xml publisher report in excel format in R12

Category:DefaultRelease time:2015-10-11Views:130

Hi All, We are unable to print xml publisher report in excel format in R12. We were able to see the excel output but it's printing junk characters while printing and it's printing without any issue with PDF format. Please let me know how to fix this[More]

Unable to save webi report in excel format

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a question. I recently upgrsded my internet explorer from IE 7 to IE 8. Previously, i was able to save webi reports in excel format without any issues.Even after upgrading to IE version8, i was able to save webi reoprts to excel withou[More]

How to send ALV Report in excel format from SAP

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, We are using SAP 4.7 and using different SAP reports.Now I want to send SAP ALV report in excel format directly from SAP in background.Now we send these reports in background weekly by using autimetic scheduling but this is PDF format.Now I[More]

Urgent- o/p of report in excel format

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I want to generate o/p of my report in excel format. Please send me the sample code for it at [email protected] Thanks in advance bhushanRajesh, yes, with BI Publisher (formerly known as XML Publisher) it's easy. But with Reports you don't ne[More]

Hot
Hello all , Its hooked up with a dvi cable from mac dvi port to dell monitor dvi port. My macbook is running mountain lion. The Monitor light on the front  blinks green and then goes into " power save mode" a black screen. Thanks for any ideas o [More]
Hi, I am new to user exits and function modules and don't know any ABAP, but I need to make use of a user exit to pull in 4 cost center values (0COSTCENTER) based on a single profit center (0PROFIT_CTR) value.  For example, in the planning layout use [More]
I am trying to connect my MacBook pro to my bt home hub but despite entering the correct password I am told I have no Internet connection. The wifi sign in system preferences is orange, and says I have a self assigned ip address. The hub is working o [More]
i have sharepoint 2013 and sql server 2012 in one server . how to configure workflow manager 1.0 on the same server ?Please follow below technet article : http://technet.microsoft.com/en-us/library/jj658588(v=office.15).aspx Installing and Configurin [More]
Hello, I have a switch-C960X version 15.0 (2r) EX, and I was looking at the securit config guide for 15.0(2) EX.There's suppose to be a command to force a port to re-authenticate itself as I'm trouble shooting 802.1X issues. The command is "dot1x re- [More]
Hi Experts, Our ECC Production system was upgraded to EHP5 last weekend. Since then Delta load for datasource 2LIS_06_INV is failing. This is the only datasource got impacted. Full Load and Initialization Loads are running fine. Only Delta load is fa [More]
I recently updated to iOS 5.1.1 and found a glitch.. itz when you open a folder on the homescreen...and then when you edit the name of the folder the keypad comes up...however ,,,it does not retract back again unless -Lock/unlocked- Apple....Please c [More]
My son tried to install Windows XP into a 50GB partition on a 13" black MacBook (2.4GHz, 250GB HD). The installation failed and now the MacBook wont boot. It gives a message "No bootable device insert....". The extended hardware test on the [More]
After recently upgrading Thunderbird to 17.0.2 I created a new event. When the event notification appeared, I was not able to dismiss or delete it. It continually pops-up as a reminder and I can not edit it or delete it within Thunderbird. After seve [More]
Photoshop (nor Acrobat Professional) from CS3 will not recognize my Epson 3200 scanner. I've installed it through System Preferences, rebooted, but still nothing. How do I get them to see my scanner? Mac OS X.6.8 ThanksStart with: http://en.wikipedia [More]