Skip to Content
author's profile photo Former Member
Former Member

scheduling the report to Excel 2007

Hi Team,

is there any possible of scheduling the report to Excel 2007 format in BO as per my knowledge we dont have such option like to confirm with Gurus 😊.

Thanks,

Shiva Gunturu

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2013 at 11:32 AM

    Hi Shiva,

    In XI 3.1, when we see schedule format options then we see excel 2003. Not sure about the schedule format options for BI 4. Please confirm the version of BO used at your side or in question.

    Thanks,

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2013 at 12:30 PM

    I believe that normal scheduling still uses binaries of excel 2003 format in BO 3.1 for all patch upgrades.

    You might be concerned of various issues which might be occurring due to the excel sheets opening in different versions of MS installed for different clients. However most of the issues with excel columns , header, formatting have been resolved in higher versions.

    Check

    1911477 - Excel 2007 output of XI 3.1 SP6 WebI report shows shrunk
    data and reduced font size for some rows

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 08, 2013 at 12:33 PM

    Hi Shiva,

    check once either you are able to save in the format of XLSX or not.

    By Saving it as CSV Format and then we can access same data in EXCEl 2007.

    From SAP BO 3.1 Service pack 6 on wards 2007 supports.


    For more information related to excel vesrions which are supported to bo .

    https://service.sap.com/pam

    Regards,

    Seshu.P

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Note that the xlsx output format in 3.1 SP6.2 is for WEBI only. For Crystal Reports, xlsx format is not available until 4.x.

      For Crystal Reports, if you want a plain, no formatting spreadsheet, writing the data in csv format and loading into Excel 2007 may be a good solution. I have found that to work better than the xls format, if only the raw data without formatting is desired.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.