• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1004
  • Last Modified:

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.
0
drumph
Asked:
drumph
  • 2
1 Solution
 
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
 
drumphAuthor 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now