The DBxtra Report Web Service

DBxtra offers you two choices to consume end-user Reports:

The DBxtra Desktop Report Viewer

Learn more here about the DBxtra Desktop Viewer.

The DBxtra Report Web Service

The DBxtra Report Web Service allows you to automatically publish your reports to a Web Server.

The Web Server can be on a PC, LAN or on a Internet Web Server.

Once a report or Query si saved it can immediately be viewed through any web browser.

Important!

When you created the DBxtra Server database - the first time you used DBxtra - then you had the choice to either create it as a file path or as a Report Web Service.

If you chose to run it as a Report Web Service then the setup should be done.

If you chose to run it through a file path then you can install it from within the DBxtra Designer.

Install the DBxtra Report Web Service

 

Click Configure Web Service  on the Web Service menu.

 

 

 

Hint! If you use DBxtra in a multi-user environment then you should install the Web Service  on a server; either a Intranet or Internet server.

To do that install DBxtra  on the Server to create the Report Web Service.

All DBxtra users should connect to that web service.

 

You have two options installing the Report Web Service.

Option 1.) DBxtra Web Server

The DBxtra Web Server is a integrated Web Server.

The main advantage is that you don't need to have the Internet Information Server installed or configures  on your PC or Server.

Recommended for:

Demo use or local / LAN Report Web Service use.

Not recommended for:

Internet access.

Advantages:

No need to install or configure the IIS - Internet Information Server.

Quick installation; ideal for trial use.

Disadvantages:

Might not be secure over the Internet.

Might be a bit slower then the Internet Information Server.

The DBxtra Designer must be running on the PC or Server where the Report Web Service is installed.

 

If you use the DBxtra Report Web Service on a Web Server exposed to the Internet  we strongly recommend not to use this option. It might not be secure.

 

Hint! You can later change from the DBxtra Web server to the IIS - Internet Information Server.

Just repeat this procedure and select the IIS installation option.

All required files will be re-directed and updated automatically.

 

Option 2.) Internet Information Server - IIS

Recommended for:

Production environment and exposure to the Internet.

Advantages:

Might be faster then the internal DBxtra Web Server.

Disadvantages:

The Internet Information Server must be installed and running on your PC or Server.

Although the DBxtra Report Web Service installer will take care of the IIS configuration it might require adjustments.

 

Select Report Web Service.

 

 

Select either "DBxtra web Server or Internet Information Server.

In case you install the Report Web Service on the internal DBxtra Web Server also choose the port number.

In most cases the default port 8080 will work fine.

 

Assign a Alias  name. By default DBxtra suggest DBxtra .NET.

Select a directory where to place the files. DBxtra will create a folder named DBxtra .NET (or the name you assigned) inside the selected path.

Click Create.

 

This will create a Virtual Directory and assign the Report Web Service path to it.

It will also automatically assign the ASPNET (or the NETWORKSERVICE  user if you install DBxtra on a Windows 2003 Server) window user privileges for the Virtual Directory.

 

See also: Report Web Service on a Shared Hosting Server

Run the Report Web Service Installer option

 

Assign a name and click Create Virtual Directory.

This will create a Virtual Directory and assign the Report Web Service path to it.

It will also automatically assign the ASPNET (or the NETWORKSERVICE  user if you install DBxtra on a Windows 2003 Server) window user privileges for the Virtual Directory.

DBxtra will close and open again.

Open the Report Web Service

You can open the Report Web Service from DBxtra.

Click Open Web Service on the Report Web Service menu.

The DBxtra Report Web Service will load in your default Web browser.

Login with your DBxtra credentials.

Watch the Movie

Repair a Report Web Service

Important!

The following only works if your Report Web Service is installed on the PC or Server where you're running DBxtra from.

If you need to update or Repair the Report Web Service on a remote or shared Server please read here.

 

Every time you upgrade to a newer DBxtra version the Report Web Service will be upgraded automatically when you logon to DBxtra.

If for any reason your Report Web Service got broken than you can repair it manually by clicking the Repair Report Web Service button.

 

Related

The Report Web Viewer

Report Web Service Functionality

Web Report Data Grid

Web Report Pivot Grid

Anonymous Web Report Logon

Install - Move - the Report Webservice on a Server

Report Web Service on a Shared Hosting Server

Modify Style - Report Web Service