Architecture:

Technology Used:

• MS Visual Basic 6.0 SP6 & MS Visual Studio 2005 VB.Net
• MS Jet 4.0 Service Pack 8
  http://msdn.microsoft.com/data/mdac/downloads/default.aspx
• MS DCOM95
• MS MDAC 2.8 SP1
  http://msdn.microsoft.com/data/mdac/downloads/default.aspx
• MS Component Category Manager Library
• MS OLE 2.40 for Windows NT and Windows 95
• Crystal Decisions Crystal Reports 8.5
• ComponentOne True DBGRID Pro 6.0f
• vbSendMail

Visual Basic Components Needed

Reporting (Crystal Reports 8.5)

The reporting for WinSwim is based upon Crystal Reports.  The support files for Crystal Reports are included into the system folder.  Because of the architecture for Crystal Reports, another version of Crystal Reports on the computer used by WinSwim CAN NOT be installed and will cause conflicts.

If any of these files below are in the \WINDOWS folder, they can cause conflicts if they are not at the same release level. Right now, Crystal Reports only will support one version of Crystal Reports installed on one computer.

Required Runtime Files

The following files are required for ALL 32-bit runtime configurations:

The following files are required for exporting data from reports: (optional)

The following files are required for accessing the database: (required)

Crystal Reports (*.rpt)

The reports provided with WinSwim are located within the installation folder for WinSwim. This is typically called, "[drive]:\Program Files\GWS\WinSwim Meet Manager 3\1033". These files have the file extension of .rpt and are in the internal format used by Crystal Reports. By putting the file in the "[drive]:\Program Files\GWS\WinSwim Meet Manager 3" folder you can effectively override this file because WinSwim looks in the application folder for the language.xml and *.rpt files there first.

Controlling Reports (language.xml)

The report menus are controlled by the language.xml file contained in the "[drive]:\Program Files\GWS\WinSwim Meet Manager 3\1033" folder. This file contains the menu structure you see in WinSwim and the processing options invoked before the report is displayed. You can effect the reports displayed and the processing before the report is displayed by modifying this file.

You need to edit the 1033\language.xml file to add a new report. This file causes the report to show on the menus in Winswim and the <process> tag controls what tables are created before the report is evoked. The <Lists> is one of the report menu sections, <addlabe2> is the name of the file of the report without the ".rpt" extension; the <title> is the title on the menu; <process> is a preprocessing step to copy the meet data to a generic table name where all reports look at just 1 table. There’s a limit of 20 reports in each section.

• Process = 1 : "Meetxxx_Events" is copied to "Events" where xxx is the meet number
• Process = 2 : "Meetxxx" is copied to “Laneslips” where xxx is the meet number; "Meetxxx_Status" is copied to "MeetStatus"
• Process = 3 : "Meetxxx" is copied to "Laneslips" where xxx is the meet number; records with Time = 0 and Place = 0 are deleted; "Meetxxx_Status" is copied to "MeetStatus"
• Process = 4 : All "Meetxxx" that are completed are merged together into "Laneslips"
• Process= 5 : If "MembersBest" are not present, an error is displayed

Sample