SSRS reports using Excel work book as the data source RRS feed

  • Question

  • HI All,

    I have to create the Dashboard for which the the source data is in Excel work books .WE do not want to buy the license for Excel services . I was trying using SSRS integrating with share point .When i was creating reports using source as Excel works by creating DSN for the ODBC connection I was getting the following error

    I wrote  the the following query to get the report from Excel work book

    select * from [Activity $] where Activity is my work sheet name

    An errrror Occured while executingthe quesry

    ERROR[42000] [Microsoft] [ODBC Excel Driver ]Invalid Bracketing of name 'Activity $'


    Moderator Note: NEVER ask for quick; asap help or say your question is urgent. Wait your turn.

    • Edited by Mike Walsh FIN Monday, March 21, 2011 9:21 PM Moderator Note on not asking for quick help added and that request removed.
    Monday, March 21, 2011 8:19 PM


All replies