How to configure Web Query for Reporting Services and Excel?

All,

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.

Error:
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
http://[Report_Server]/Pages/Report.aspx?ItemPath=%2fSite+Reports%2fCustomerDemo%2fWebQuery+Customer+test&res:command=Render&rs:Format=HTML4.08&rc:LinkTarget=_top&rc:Javascript=False&Toolbar=False

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.
drumphAsked:
Who is Participating?
 
drumphConnect With a Mentor Author Commented:
All I found my own solution .  Here is Generic version of the the syntax I placed in my IQYfile.

http://report.Server.com/reportserver?%2fSALES%2fGeneric_Company_numbers_by_date&StartDate=["StartDate","Enter the value for StartDate:"]&EndDate=["EndDate","Enter the value for EndDate:"]&rs:Format=mhtml

The Key piece was the "&rs:Format=mhtml"  . This is the clause that returns standard html instead the SSRS's rendered version the does not convert well to Excel in this situation
0
 
QPRCommented:
http://dobrzanski.net/tag/reportingservices/

Scroll down to the section titled Reporting Services - Your browser does not support scripts or has been configured not to allow scripts.

You may have to add the report server to your trusted sites
0
 
drumphAuthor Commented:
That did not fix the error.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.