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 [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.
View Complete Post