Before creating a report with QPR Add-In for Microsoft Office, you need to provide connection details to QPR Web Services Foundation. This is done via the Server Connection button as follows:
Provide a valid QPR Web Service Foundation URL in the QPR Web Service URL field. This setting is saved between sessions, so you only need to enter when you use QPR Add-In for Microsoft Office for the first time. Input your user name and password into the corresponding fields. Use the same credentials as you normally use when you log in to QPR. If Integrated Windows Authentication (IWA) is in use in your organization, check the corresponding checkbox.
Using SSL with QPR Add-In for Microsoft Office
The following configurations should be done in order to use SSL with QPR Add-In for Microsoft Office:
•Enable SSL for QPR Web Services Foundation. See QPR - Developer's Guide for instructions on how to do this.
•Make the following modification to Qpr.Reporting.Word2007.AddIn.dll.config:
oIn the "<wsHttpBinding>" element, comment the "<security mode="Message">" tag and replace it with "<security mode="Transport">"
Note that these configurations need to be reversed in order to be able to use http connection again.