Sportzware Central - Reports Maintenance

Sportzware Central - Reports Maintenance

The Reports Maintenence area allows you to add, remove, configure and preview the reports you use.

Contents 1 Add a New Report to Sportzware Central 2 Edit An Existing Report 2.1 Editing General Report Options 2.2 Editing Report Paremeters 2.3 Editing Report Sports 3 Delete A Report 4 Print A Report 5 Preview A Report 6 Export A Report 7 Report Fields

Add a New Report to Sportzware Central

Follow these steps to add a custom report file (with an extension .rpt) to Sportzware Central.

1. Save the .rpt file to your custom reports folder (general location is C:/Program Files/Sportzware/Custom Reports).
2. Open your SWC database
3. Go to Configuration tab and click on Reports Maintenance
4. Click on Add
5. Locate the .rpt file you wish to add and click on Open
   
   
   
   
6. In the General tab, you are able to change the report category, header, etc. if you wish.
7. In the Parameters tab, you can change the fields you’d like to filter the report by – eg. Competition, Club, Round.
8. Click on Ok.

You can now run the report from either the Report Maintenance screen or the Reports area.

---

Edit An Existing Report

1. From the configuration module click on Reports Maintenance.
2. Click on Edit to bring up the 'Editing a Report' window for viewing the selected report. A window will be displayed with the properties of this report.
   
   
   
   

Editing General Report Options

At this screen you can change the title of the report. While there are other fields available to alter we suggest you do not make any other changes because they may affect the quality and accuracy of the report.

1. To change the Report Title click in the Report Title field and type the name that you would like to appear on the report.
2. Click OK to save the change.
   
   
   
   

Editing Report Paremeters

At the Parameters screen you can edit the parameter types the report uses to display information. By adding or removing a parameter you are restricting or allowing the report to show information relevant to that parameter type.

1. To add or remove a Parameter, check or uncheck the Use box next to the 'Field Name'.
   
   
   
   
2. Once you have made all the parameter changes click on OK.

Note: It is important to remember custom reports have been built around the mock up provided to SportingPulse. Therefore it is advised that you run the report as it has been sent to you first, check to see whether it is correct for what you need, and make changes as necessary afterwards.

Editing Report Sports

Editing report sports allows you to add or remove the sports that can utilise the report. The sport that your association is involved with will probably be the only one in the 'Active Sports' box when you receive the report because it has been built for this particular sport.

1. To add another sport highlight the sport you would like to add in the right-hand box and click Add.
   
   
   
   
2. To remove a sport from the 'Active Sport' list, highlight the sport in the left-hand box and click the Remove button.

Descriptions of fields are provided in the table below.

---

Delete A Report

1. From the configuration module click on Reports Maintenance.
2. Select the report you wish to delete by clicking on it once.
3. Click on Delete to delete the selected report.
4. You will be asked if you are sure that you want to delete the report. Click Yes to confirm or No to cancel the delete process.

---

Print A Report

1. From the configuration module click on Reports Maintenance.
2. Select the report you wish to delete by clicking on it once.
3. Click Print to print the selected report.
4. You may be asked to select some parameters for the report before the report can be generated and then printed.

---

Preview A Report

1. From the configuration module click on Reports Maintenance.
2. Select the report you wish to delete by clicking on it once.
3. Click Preview to preview the selected report.
4. You may be asked to select some parameters for the report before the report can be generated and displayed in the preview screen.

---

Export A Report

1. From the configuration module click on Reports Maintenance.
2. Select the report you wish to delete by clicking on it once.
3. Click on Export to export the selected report.
4. You may be asked to select some parameters for the report, followed by the export options for the report.

---

Report Fields

General
Field Name	Description	Example
Filename on Disk	The location of the report file. Click the folder icon to edit the location.	16Knockout_O.rpt
Report Title	The title to display on the report when it is run	16 Knockout Tree
Report Name	The name of the report, used internally to identify the report	16 Knockout Tree
Security Level	A security level number to determine which users can access this report.	50
Report Category	Determines under which lists this report will appear.	Competition
Member Report	N/A	N/A
Custom Report	Whether this report is specific to the league.	N/A
Show this report	This report is displayed in the Reports section.	N/A
My Report	This report has been bookmarked by the user and appears on the My Report tab.	N/A
Notes	Notes entered by the user relating to the report.	N/A
Built-in Filters	Shows the SQL code that this report uses to filter what is displayed.	N/A
Report Views	Lists filters that can be applied to the report to view it in different ways.	N/A

Parameters
Field Name	Description	Example
Fields depend on the report you are running	Lists fields that the user can filter the report by. Tick the box in the “Use” column next to the field you wish to allow the user to filter the report by this field.	N/A
Parameters Required	Parameters must be selected before the report is generated.	N/A

Sports
Field Name	Description	Example
Sports that the report can be used for	Add sports that this report will apply to into the left list	N/A

Export
Field Name	Description	Example
Mail Merge Report	Report is used for mail merge documents	N/A

Application Details
Field Name	Description	Example
Application Name	Application that the report exports to for merging	Microsoft Word
Master Document Name	Filename of the exported document	AddressListing.doc
Export Report	Report is to be exported by default	N/A

Export Options
Field Name	Description	Example
Format	Application that the report exports to	Word for Windows document
Destination	Destination of the Export report	Application (open in application on screen)
File Name	Filename of export report	TeamList.rpt
Character Separator	These settings apply to the format of text exports. In most cases the values here will be left as they already are.
Character Delimiter
Lines per page (Paginated Text)
Use Report Date Format
Use Report Number Format
Column Headings (Excel5 Tabular)

ODBC
Field Name	Description	Example
Source	Not currently applicable,reserved for future use.	N/A
User
Password
Table Name

Email
Field Name	Description	Example
Recipient(s) separate with semi-colons	Separates recipients in the email with a semi-colon	N/A
Message Subject	Default subject for emails	Email from Box Hill Football League

Exchange
Field Name	Description	Example
Profile	If you use an Exchange server, the name of the profile.	N/A
Password	Password for the Exchange server	Folder Default folder to use Outbox

Related: Reports Centre

<input type="hidden" id="gwProxy"></input><input type="hidden" id="jsProxy" onclick="jsCall();"></input>