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
Hi All I am trying to make few changes in B2B application for CRM 2007. I have created projects for crmisawebb2bsap.com and  crmhomeshrextsap.com But whenever I try to build anyone of them. There is a error. Build log - Development Component Build (2 [More]
I want to know if there is a way to view two pdf's in one window as a 'left and 'right'. I have set the format to 'two page continous' but would like the left column to be the first pdf and the right column to be the secnd pdf.As TSN has mentioned, t [More]
Hi, My imac keeps shutting down my programs when I'm using them. For example I can change my screensaver image to images from a chosen, when I try the program shuts down, same as safari and mac the ripper. Some of my other programs do not even open f [More]
Hi , I am researching about the automactic form validation processing and i hv found these ..FPAPI http://www.javaworld.com/javaworld/jw-10-2001/jw-1005-forms.html The documentation appear to very complex and many steps need to be done ... Any expert [More]
I can successfully run applications that use the AI Sample Channel vi, however when I use the AI Acquire Waveform vi the following errors are generated:- Error -10401 occurred at AI Hardware Config, followed by Error -10401 occurred at AI SingleScan. [More]
Need help controlling animation in Acrobat 3D.  Looking to control the playback of the animation by steps, not have it playback all at once. Please help!You have to use Acrobat 3D JavaScript to control the playback. There are two options, neither of [More]
Brand new to the iPad. It's asking for a password to the WiFi network in my home. There is no "password" as such associated with this WiFi network. It uses WEP 128 bit encryption where each byte is a hexadecimal number and is called a "key& [More]
OK folks, For the last couple of days I'd been searching this site for resolving my issue. Help me out Pleeeeeeeeeease. Environment Webserver: IIS OS: Windows 2000 (Needless to say) Language: Javascript Issue: communicate the jsp application to Micro [More]
Hi, I'm new to socket in java and dunno if there is a mechanism which is similar to using the select () system call in unix ? What I mean is that how can we know there are some data to read from a socket ? Thanx a lot to any one that can help me.The [More]
I have a 3 in 1 camera connection kit but it no longer works now that I have installed ios7 and it's fixes on my ipad mini. Any suggestions?Restart your iPad by holding the power and home button until the Apple logo appears.Read other 2 answers [More]