Home » Fusion Middleware & Colab Suite » Business Intelligence » Need output option as Excel 2007 for Report in BI (Bi Publisher 10.1.3.4.1 released on 01-APR-2010 . RHEL4AS x86)
Need output option as Excel 2007 for Report in BI [message #450406] Wed, 07 April 2010 01:15 Go to next message
nileshbarhate
Messages: 3
Registered: April 2010
Junior Member

Dear All,

We are having Bi Publisher 10.1.3.4.1 standalone installed. We are having Excel 2007 installed on all user machines. Right now BI Publisher does not provide option as Excel 2007 as output format. There are only two options as Excel and Excel 2000.

I need Excel 2007 option here so that file will get saved as xlsx format only. I need this because right now users are getting excel file as xls on mail SO when user open this file in Excel 2007 he faces warning as "The file you are trying to open .xlsx is in a different format than specified by the file extension. verify the file is not corrupted and is from trusted source before opening the file. Do you want to open the file now?" and as the file is received by top management users,they dont want this warning.

This warning can be avoided by changes in registery i have tested that but we dont want this option as for how many mahcines we will keep on changing.


So is there any option so that we can get Excel 2007 option and file will get saved as xlsx?? We are on latest 10.1.3.4.1 released on 01-APR-2010

Thanks in advance

Regards
Nilesh

Re: Need output option as Excel 2007 for Report in BI [message #450421 is a reply to message #450406] Wed, 07 April 2010 02:47 Go to previous messageGo to next message
AlexAnd
Messages: 18
Registered: March 2010
Junior Member
you can save Excel 2007 as xls(Excel 97-2003 workbook) and then you may open it from Excel 2003 or Excel 2007
Re: Need output option as Excel 2007 for Report in BI [message #450423 is a reply to message #450421] Wed, 07 April 2010 02:58 Go to previous messageGo to next message
nileshbarhate
Messages: 3
Registered: April 2010
Junior Member

Hi AlexAnd,

Thanks for the reply. But I think you didnt got my problem. Actually right now as report is created in excel the file come by mail is in xls format. and it is getting opened in Excel 2007. No Doubt about it.

My Problem is when we click on the attachment of the mail(for that file) it gives warning as specifed in ma question. If we click yes to that warning file is getting opened with all data no problem with this.

But this report goes to top management and they dont want that click. So for avoiding that I need a solution

when we create a report we attach a template to it. While attaching template there are options like Excel and Excel2000 so if we get the option Excel 2007 then file will get saved as xlsx and user will not face that warning.

Now the question is how to get that Excel 2007 for template.


Regards
Nilesh
Re: Need output option as Excel 2007 for Report in BI [message #450451 is a reply to message #450423] Wed, 07 April 2010 05:40 Go to previous messageGo to next message
AlexAnd
Messages: 18
Registered: March 2010
Junior Member
Excel 2007 in principle for you?
or may be use Word 2007 (.rtf) for this goal
Re: Need output option as Excel 2007 for Report in BI [message #450453 is a reply to message #450451] Wed, 07 April 2010 05:55 Go to previous messageGo to next message
nileshbarhate
Messages: 3
Registered: April 2010
Junior Member

Hi Alex,

THis is the report for top management and thats why the requirement is. Many reports are sent by BI alerts in xls format and for every report its giving warning.

We also checked using rtf but its not working. Is there any way to customize for xlsx ??? If excel 2007 option is there while selecting output then it will resolve all the issue.

nilesh
Re: Need output option as Excel 2007 for Report in BI [message #450470 is a reply to message #450453] Wed, 07 April 2010 07:52 Go to previous messageGo to next message
AlexAnd
Messages: 18
Registered: March 2010
Junior Member
i think you can't use Excel 2007 as template
Re: Need output option as Excel 2007 for Report in BI [message #497737 is a reply to message #450406] Mon, 07 March 2011 00:41 Go to previous messageGo to next message
andrewhay
Messages: 1
Registered: March 2011
Location: ca
Junior Member
Excel 2007 is a nice software but it fails to deliver quality to those applications which are not able to integrate with it. I don't think there is a genuine solution to this except the one cited above and it requires tough brain to crack this down.
Re: Need output option as Excel 2007 for Report in BI [message #562454 is a reply to message #497737] Wed, 01 August 2012 09:39 Go to previous messageGo to next message
beinmyvicinity
Messages: 2
Registered: August 2012
Junior Member
Hi All,

Have we found any fix to this issue..??

[Updated on: Wed, 01 August 2012 09:42]

Report message to a moderator

Re: Need output option as Excel 2007 for Report in BI [message #566501 is a reply to message #562454] Sun, 16 September 2012 02:29 Go to previous message
skaundinya
Messages: 9
Registered: June 2010
Junior Member
Hi,

The following link may help .

https://blogs.oracle.com/xmlpublisher/entry/excel_2007_warnings

Rgds,
skaundinya
Previous Topic: How Do I Get OBIEE to Analyze a Column to Calculate Start-End Dates?
Next Topic: how to display an image based on a condition
Goto Forum:
  


Current Time: Mon Jul 28 12:36:11 CDT 2014

Total time taken to generate the page: 0.17759 seconds