Architecture:

Technology Used:

• MS Visual Basic 6.0 SP6 & MS Visual Studio 2012 VB.Net and C#
• 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 installation program for Winswim will not overwrite existing Crystal Report files and if installed over another version will cause version confusion with Crystal Reports. Because of the architecture for Crystal Reports, another version of Crystal Reports on the computer will cause conflicts causing WinSmim reporting not to work.

Other software may install Crystal Report files in different folders than Winswim for both prior versions or newer versions. If any of these files are duplicated in \WINDOWS or \WINDOWS\SYSTEM32 folders, they will cause conflicts if they are not at the same version levels. Crystal Reports only will support one version of Crystal Reports installed at a time on your computer.

To correct multiple version issues, you will need to rename or remove the files below from the computer manually with Windows Explorer and then reinstall Winswim to install the correct files for Crystal Reports 8.5. Be aware that other software using Crystal Reports may then not work with this version.

Required Runtime Files

The following files are required for all runtime configurations and Winswim installs the files in the locations below. Be aware that other software may install these files into other locations than specified below.

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

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

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