I am trying to import a Reporting services report into excel 2003 using an IQY (Web Query) file. I have figured out how to create the IQY file and have gotten it to prompt me for the 2 parameters (Dates) for the underlying Stored Procedure
Every time I put in the beginning and Ending dates, in the following format 03/01/2009, I receive the following errors in Excel.
Your browser does not support scripts or has been configured not to allow scripts. Click here to view this report without scripts.
And after I click on the above error I receive:
Unable to Open
Cannot download the information you requested.
I have also tested the IQY theory with a more generic Report/Stored Procedure which just requires a last name(String) to be provided and I am receiving the same error.
Any pointers to resolve these errors would be appreciated.