{"id":123,"date":"2022-06-09T17:58:45","date_gmt":"2022-06-09T17:58:45","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/configure-xlreport-report-server\/"},"modified":"2022-06-12T16:16:35","modified_gmt":"2022-06-12T16:16:35","slug":"configure-xlreport-report-server-2","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/setup\/report-server\/configure-xlreport-report-server-2\/","title":{"rendered":"Configure XLReport Report Server"},"content":{"rendered":"<ul>\n<li value=\"1\">To setup the XLReport Report Server click &gt;<span class=\"DoIt\">Report Server<\/span>&gt;<span class=\"DoIt\">Configure <\/span>on menu bar.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/6.png\" \/><\/p>\n<ul>\n<li value=\"1\">If your XLReport queries &#8211; Excel sheets should be able to be accessible on the Internet you need to select the <span class=\"DoIt\">Report Web Server<\/span> option.<\/li>\n<\/ul>\n<p>You have two options to configure the Report Web Server:<\/p>\n<ul>\n<li value=\"1\">XLReport Server\n<ul>\n<li value=\"1\">Use this option for testing purposes and on the Intranet.<\/li>\n<\/ul>\n<\/li>\n<li value=\"2\">Internet Information Server\n<ul>\n<li value=\"1\">Use this option for Internet access and production purposes.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p class=\"note\">Note! To use the IIS option you need to open Excel as Administrator user.<br \/>\nTo run Excel as Administrator do the following:<br \/>\n1.) Look for the Excel shortcut either in the Desktop or the Start Menu.<br \/>\n2.) Right click it and select Run as Administrator<br \/>\nIf you don&#8217;t see the option to run it as administrator, you can press Control + Shift + Enter (if you&#8217;re over the shortcut) or click it (in the Start Menu) or double click it (in the Desktop) and it will be run as administrator.<\/p>\n<ul>\n<li value=\"1\">Select either option and click <span class=\"DoIt\">Apply<\/span>.<\/li>\n<\/ul>\n<p>XLReport will configure the Server for you.<\/p>\n<p class=\"note\">Note! For IIS configuration it might be necessary to configure &#8211; adjust &#8211; manually.<\/p>\n","protected":false},"featured_media":0,"parent":83,"menu_order":1,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/123"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":3,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/123\/revisions"}],"predecessor-version":[{"id":353,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/123\/revisions\/353"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/83"}],"next":[{"title":"Connect to an existing Report Server","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/setup\/report-server\/connect-to-an-existing-report-server\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/99"}],"prev":[{"title":"Internet Information Server (IIS)","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/setup\/report-server\/internet-information-server-iis\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/128"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}