The standard SalesLogix 7.5.x “SLX Web Reporting” site can only be used for one database because it contains a Connect.Config file that points to a single database. You can switch between databases by re-deploying the “SLX Web Reporting” site, but in a development environment it is more convenient to set up multiple reporting sites, one for each database. The below procedure explains how to setup reporting dedicated to one database. (The following assumes that the Crystal Reports Server and standard Web Reporting components have already been installed on the Web Server.)
1. Instead of using the default “SLX Web Reporting” site (normally port 3334), you need to setup a slxwebrpt virtual directory under the web site you create for your custom database (i.e., in the same location as the slxclient virtual directory). Add the slxwebrpt virtual directory with these settings:
A directory located on this computer, the local path pointing to C:\Inetpub\wwwroot\Yoursubdirectory, allow Read, Log visits, and Index this resource. Make sure the application pool is pointing to the SLX Web Reporting.
2. The aspnet_client folder and all of its contents must be copied to the Inetpub folder that contains the slxwebrpt virtual directory folder. The folder can be found in the location pointed to by the standard “SLX Web Reporting” installation (usually “C:\Program Files\SalesLogix\Web Components”).
3. Deploy web reporting pointing to your new slxwebrpt virtual directory
4. Set the slxclient Web Dependencies to point to your new slxwebrpt and deploy slxclient.
5. Run IISRESET