About WinSwim

Technical Issues

This page is for describing some of the more technical architecture of WinSwim for the users that would like to customize the underlying reports, SDIF structures, MS Office Access tables and SQL statements used for controlling the application.

Architecture:

WinSwim is written specifically for a Microsoft Windows platform. If you are considering using the software for a Apple O/S, you might be able to use it under a virtual Windows OS running in VMWare Fusion for Mac. You can find more information at VMWare Site

Technology Used:

Visual Basic Components Needed

File Location Last Modified Size (bytes) Version
tdbg6.ocx \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 12/06/2000 8:59 AM 832448 6.0.0.253
MSFLXGRD.OCX \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 05/21/2000 11:00 PM 244416 6.0.84.18
comdlg32.ocx \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 05/21/2000 11:00 PM 140488 6.0.84.18
xarraydb.ocx \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 12/06/2000 8:59 AM 111552 1.0.0.12
msvbvm60.dll \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 08/29/2002 4:00 AM 1388544 6.0.92.37
mschart.ocx \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 06/26/1998 3:22 AM 979728 6.0.80.79
grid32.ocx \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 06/26/1998 3:22 AM 94744 4.0.29.8
MSCAL.OCX \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 04/29/2002 10:47 AM 121160 10.0.0.4024
tdbgpp.dll \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 12/06/2000 8:59 AM 316344 1.0.17.7
MSSTDFMT.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 07/14/2000 11:00 PM 118784 6.0.88.4
vb5db.dll \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 06/17/1998 11:00 PM 89360 6.0.81.69
mscomctl.ocx \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 06/06/2002 9:12 AM 1077344 6.1.95.45
scrrun.dll \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 08/29/2002 4:00 AM 147483 5.6.0.6626
vbSendMail.dll \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 09/05/2003 8:11 PM 139264 3.6.0.5
msvcrt.dll \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only) 08/29/2002 4:00 AM 323072 7.0.2600.1106

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:

FILE LOCATION DESCRIPTION
CRPE32.DLL \WINDOWS\SYSTEM32 Interface to the Crystal Report Engine
CCRAXDDRT.DLL \WINDOWS\SYSTEM32 Crystal Reports Database Objects
CCRAXDRT.DLL \WINDOWS\SYSTEM32 Crystal Reports Database Objects
CRDESIGNERCTRL.DLL \WINDOWS\SYSTEM32 Crystal Reports Report Designer
CRPAIG80.DLL \WINDOWS\SYSTEM32 Crystal Reports Repair DLL
CRVIEWER.DLL \WINDOWS\SYSTEM32 Crystal Reports Viewer
PG32CONV.DLL \WINDOWS\SYSTEM32 Crystal Reports Repair DLL
SSCSDK80.DLL \WINDOWS\SYSTEM32 Crystal Reports Charting Engine
CRXLAT32.DLL \WINDOWS\SYSTEM32 Crystal Reports ToWords DLL
MSVCRT20.DLL \WINDOWS\SYSTEM32 Microsoft Foundation Class Runtime Library
CRPAIG32.DLL \WINDOWS\SYSTEM32 Crystal Reports text object support
CTL3D32.DLL \WINDOWS\SYSTEM32 Version 2 of the 3D control implementation
IMPLODE.DLL \WINDOWS\SYSTEM32 Compression Library

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

FILE LOCATION DESCRIPTION
U2FCR.DLL \WINDOWS\CRYSTAL Crystal Reports format 32-bit
U2FDIF.DLL \WINDOWS\CRYSTAL DIF format
U2FHTML.DLL \WINDOWS\CRYSTAL HTML format
U2FODBC.DLL \WINDOWS\CRYSTAL ODBC data source
U2FREC.DLL \WINDOWS\CRYSTAL Record format
U2FRTF.DLL \WINDOWS\CRYSTAL Rich Text Format
U2FSEPV.DLL \WINDOWS\CRYSTAL Comma Separated Values format
U2FTEXT.DLL \WINDOWS\CRYSTAL Text format
U2FWKS.DLL \WINDOWS\CRYSTAL Lotus 1-2-3 format
U2FWORDW.DLL \WINDOWS\CRYSTAL Microsoft Word for Windows format
U2FXLS.DLL \WINDOWS\CRYSTAL Microsoft Excel format

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

FILE LOCATION DESCRIPTION
P2BDAO.DLL \WINDOWS\CRYSTAL Crystal Reports Physical DataBase - Access
P2CTDAO.DLL \WINDOWS\CRYSTAL Crystal Reports Physical DataBase - Access
P2IRDAO.DLL \WINDOWS\CRYSTAL Crystal Reports Physical DataBase - Access
P2SMON.DLL \WINDOWS\CRYSTAL Crystal Reports Active Data Reporting
P2SODBC.DLL \WINDOWS\CRYSTAL Crystal Reports Physical DataBase - ODBC
P2SOLEDB.DLL \WINDOWS\CRYSTAL Crystal Reports Physical DataBase - OLE

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

<Lists>
<addlabe2>
<title>Avery 5160 Parent Label</title>
<process>2</process>
<sql1 Error="Ignore">Insert SQL statement here</sql1>
<sql2 Error="Ignore">Insert SQL statement here</sql2>
</addlabe2>
</Lists>

 


Copyright © 2004-2007 WinSwim Software, All Rights Reserved
Site developed by GaryWebSoft, contact WinSwim Support for problems or comments
Last modified: Sunday July 22, 2007