How to configure Web Query for Reporting Services and Excel?

Posted on 2009-04-28
Last Modified: 2012-05-06

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.
Question by:drumph
    LVL 29

    Expert Comment


    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

    Author Comment

    That did not fix the error.

    Accepted Solution

    All I found my own solution .  Here is Generic version of the the syntax I placed in my IQYfile.["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

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now