Post reply

How can I create the reporting services report from Excel Sheet?

  • December 15, 2004 at 3:20 pm

    #112660

    Hi

    How can I create the reporting services report from Excel Sheet without using DTS or SQL Server Data Source?

     

     

    Thanks in Advance

     

     Vijay

  • December 16, 2004 at 12:05 am

    #534084

    Reporting Services should be able to create reports from any OLEDB/ODBC source. If you can manually create the ODBC connection string, with the Excel driver,  Reporting Services should be able to access the Excel file as the data source.

    Not done it myself, I've only been reporting from SQL Server sources. But the option to select an ODBC data source implys that it could be possible.

    Julian Kuiters
    juliankuiters.id.au

  • December 16, 2004 at 2:43 pm

    #534245

    Hi Julian Kuiters

    Thanks for your Help

     

    I have Done Some think Like this and working fine,Reporting Services Data sources configuration Like this

     

    Provider=Microsoft.Jet.OLEDB.4.0;Mode=Read;Data Source=C:\Customer\Reporting Services Reports\ExcelReporting\GFK Excel Reports\ExcelGFK.xls;Extended Properties="EXCEL 8.0;HDR=YES"

     

    Regards & Thanks

    Vijay

  • December 16, 2004 at 10:59 pm

    #534272

    Thanks for posting back the connection string, Vijay. I'm glad to hear its possible.

    Julian Kuiters
    juliankuiters.id.au

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply