RPOWER.Reports Server Configuration

From RPOWERWiki

Jump to: navigation, search

RPOWER.Reports is an IIS Web Server module allowing reports to be run from a Web browser over the Internet from the RPOWER.SQL reporting database. Users can log on to their own corporate reporting Web site and retrieve reports in PDF, MS Word, MS Excel, or HTML format.

View some samples of the reports available.

Contents

Required Components

If this computer is also the RPOWER.SQL Multi-Store Database you can use these directions.

If you are using Remote Desktop, it is imperative that you click on the link above. Installation instructions for each of the other components can be found on their respective pages.

Installing the RPOWER Reports Module

The latest version of the RPOWER.Reports module can be downloaded here. Push Save and save the file to C:\RPOWER.Central\Installation Files.

After downloading the file, create the following directory structure:

C:\
|
+-- RPOWER.Central
    |
    +--RPOWER.Reports
       |
       +--Inetpub

Navigate to C:\RPOWER.Central\RPOWER.Reports\Inetpub and right-click on the RPOWER.Reports zip file and click Extract All.... When the Extraction Wizard appears,push Next. On the Select a Destination panel push Browse... and navigate to the Inetpub directory you just created. Push Next. Push Finish.

Configuring IIS

Navigate to Control Panel\Administrative Tools\Computer Management, or just right-click My Computer and select Manage.

Double-click Services and Applications and then Internet Information Service and then Web Sites. Right-click Default Web Site and select New, Virtual Directory.... The Virtual Directory Creation Wizard will appear. Push Next.

  • On the Virtual Directory Alias wizard panel, enter reports in the Alias textbox. Push Next.
  • On the Web Site Content Directory wizard panel, push Browse... and navigate to C:\RPOWER.Central\RPOWER.Reports\Inetpub. Push OK. Push Next.
  • On the Virtual Directory Access Permissions wizard panel, check the Read and Run scripts (such as ASP) checkboxes. Push Next.
  • Push Finish.
  • (Server 2003 only) Under IIS, there is another item called Web Extension Services. Click this and navigate through the list of services until you get to an item or items whose names begin with ASP.NET. For each item, click on the item to highlight it and then push Allow. By default, Windows Server 2003 does not enable ASP.NET services. If you don't do this step, the reports website will throw a 404 error.

Configuring the Virtual Directory

If you double-click Default Web Site, you should see a reports underneath it. Right-click reports and select Properties to bring up the reports Properties dialog.

  • On the Virtual Directory tab:
  1. Check that the Local Path is pointing to C:\RPOWER.Central\RPOWER.Reports\Inetpub.
  2. Ensure that the Read, Log Visits, and Index this resource checkboxes are checked.
  3. Push Configuration and confirm that .ascx and aspx are in the Application Extensions list. if they are not, this typically means that IIS was installed after the .NET Framework was installed, or the ASP.NET option was not selected when IIS was installed. If this is the case, either run a repair on the .NET Framework, or uninstall and then re-install it. Push Cancel.
  4. The Application Name should be set to reports. If not, make it so.
  5. Set Execute Permissions to Scripts only.
  6. If working on Windows Server 2003, ensure that Application Protection is set to DefaultAppPool. If working on Windows XP Pro, make sure that the Application Protection is set to Medium (Pooled).
  • On the Documents tab:
  1. Push Add.... Enter Logon.aspx in the Default Document Name textbox. Push OK.
  2. With Logon.aspx highlighted, push Move Up (the up arrow in Windows XP) until Logon.aspx is at the top of the list.
  • On the ASP.NET tab:
  1. Find the ASP.NET version dropdownlist, and push the down arrow to view the list of appropriate options. Select 2.0.50727.
  2. Push OK

Setup Shortcuts

In Windows Explorer, navigate to C:\RPOWER.Central\RPOWER.Reports\Inetpub. In that directory you should find a file named ReportRunner.exe. Click on that file, and right-click and drag the file out to the desktop. Select Create Shortcuts Here.

To copy the ReportRunner shortcut on the desktop to the Startup directory, click Start mouse up to Programs, and then over to Startup. Right-click on Startup, and select Open All Users. Right-click and drag the ReportRunner shortcut to the Startup directory. Select Copy here.

Configure Web Site Port

It is possible to change the port for the reports website. What you have gone through above are the steps in setting up a Virtual Directory called reports. To change the port for this site, you need to go back to Default Web Site, right-click it, and select Properties. On the Web Site tab, you will see a textbox labeled TCP Port. Place the port number in this textbox and click OK. The default port is 80.

If using Windows Server 2003, if you already are hosting a default website using port 80 and you want to assign the reports Virtual Directory a different port, you can always create a reports website. You just navigate to Web Sites and right-click. Select New | Website... and set up the website much like the Virtual Directory was set up above.

In any event, if you want people outside the LAN to be able to use the RPOWER.Reports website, you will need to open a port on the gateway router.

Setting up User Permissions

Navigate to C:\RPOWER.Central\RPOWER.Reports. Right-click on RPOWER.Reports and click $Properties. When the $Properties dialog appears, you should see a Security tab.

If you do not see a Security tab, close the Properties dialog, click the Tools menu in Windows Explorer, click Folder Options, and click the View tab. In the Advanced Settings listbox, navigate down to Use simple file sharing (Recommended) and uncheck the box. Push OK. Navigate back to C:\RPOWER.Central\RPOWER.Reports and open the Properties dialog. The Security tab should now be there.

Click the Security tab, and search for Everyone in the Group or user names list. Click Everyone and in the Permissions for Everyone listbox, check the Full Control box under the Allow column. Press OK.

Testing the Installation

The easiest way to test the installation is to right-click on the virtual directory and select Browse. The website should start up. You can also test from another machine by appending '/reports' (sans quotes) to the IP address or computer name (ex: http://192.168.0.1/reports).

Setting Up User Accounts

Once you get the RPOWER.Reports website installed, you will want to set up user accounts so store owners can log in and view reports. Information about this step can be found on the User Account File page.

Verify Internet Explorer settings

If you are having problems viewing a report because a pop-up bar/information bar keeps appearing, you can change the security settings for a zone by:

  1. With Internet Explorer open go to the Tools menu (press Alt + a in Internet Explorer 7) and then click Internet Properties.
  2. If dealing with problems when displaying a pdf report, click on the Programs tab, then press Manage add-ons. In the Add-On list, you should see an Adobe PDF Reader and an Adobe PDF Reader Link Helper in the list. The status for these items should be Enabled. If it is not:
    1. Click Adobe PDF Reader and click on the Enable radiobutton inside the Settings box under the Add-Ons list.
    2. Click Adobe PDF Reader and click on the Enable radiobutton inside the Settings box under the Add-ons list.
    3. Click OK.
  3. Click on the Privacy tab. Press Advanced. If the Override automatic cookie handling checkbox is checked, click it to uncheck it. Press OK.
  4. Click on the Security tab. Click Sites. Click Add to add the RPOWER Reports Website to the Trusted Sites list. That way, you will be changing the browser settings only for Trusted Sites and not for the whole internet.
    1. Press Custom level...
    2. In the Security Settings dialog, scroll down until you see the Downloads category.
    3. If Automatic Prompting for Downloads is disabled, click the Enable radiobutton.
    4. If File download is disabled, click the Enable radiobutton.
    5. Press OK to save your changes.
  5. Press OK to close the Internet Options dialog.

The report should display after doing this. Be aware that a dialog will pop up asking you whether to open or save the report if you had selected xls at the Format prompt on the Select Report page in the website.

Views
Personal tools