|
NOTE: Spread Server is designed to
work with just about any database (Oracle, DB2, Sybase, Access, etc.). This
particular example, however, requires that you have an instance of SQL Server
available that contains the standard Northwind example database.
If you are in the process of evaluating Spread Server or if you want
to learn how to generate Excel reports that contain charts, then
the Northwind Product Category Report is a good example.
Spread Server generates the Northwind Product Category
Report by obtaining product revenue and unit data from the standard
SQL Server Northwind database and updating the Category Data sheet that in turn
updates the chart seen below. All of this can be accomplished with a template,
a SQL query and a simple Spread Server configuration file.
Scroll down to get the files and find out how to generate this report in a
matter of minutes.
To generate your own example report like the one shown
above, follow the steps below:
-
If you have not already done so, download
and install Spread Server
-
Download
the Northwind Product Category Report template, query and configuration
files
-
Extract the contents of the zip file.
-
Double click on the Example 1.sssc Spread Server configuration file
and the Spread Server configuration editor will open.
-
Double click on the pre-defined report highlighted in the screen shot shown
below.
A report editor form will appear, like the one seen below.
-
Click on the Import button to import the NorthwindProductCategoryReportTemplate.xls
file that is contained in the zip file. When the import is successfully
completed, the template field should appear as it does in the screen shot
below.
-
Double click on the pre-defined sheet highlighted in the screen shot shown
below.
An extraction editor form will appear, like the one seen below.
-
Click on the Import button to import the NorthwindProductCategoryReport.sql
query file that is contained in the zip file. When the import is successfully
completed, the SQL query file field should appear as it does in the
screen shot below.
-
Click on the OK buttons on the extraction editor and the report editor
forms shown above to return to the main Spread Server configuration editor
form.
-
Click on the Create Reports link, shown below, to run the report.
A progress window will appear while the report is being generated.
-
After the report is generated, close the progress window and examine the
generated file that will have been routed to C:\Test\SpreadServer\Reports.
NOTE: If an error occurs during processing the file will be routed to the Errors
folder (see the help files in this case for additional information on
file routing).
If necessary, you can refer to the help files and the
reference implementation to obtain more information on configuring and
operating Spread Server. Also, you can contact
a SoftWidgets sales representative for configuration and evaluation
assistance.
|
|