The same information applies when you are trying to create reports or edit the reports included with the program, which will not have the correct server name until you update them.
To preview the data in Crystal Reports, you need to reset server names in the report:
In Crystal Reports:
Open a report,
Goto Database\Set Datasource Location
Create a New connection
Click OLE DB (ADO)
Select Microsoft OLE DB Provider for SQL Server
Click Next, and Enter
Server name: [Machinename]\waspdbexpress (e.g. TextComputer\waspdbexpress . This is the SQL server holding the database, which is not necessarily the WaspTime Server Service PC, or WaspTime client PC. Enterprise edition customers may have no SQL instance name, or a different instance name.)
Use the chart below for the Wasp program you're using, to find the appropriate UserID, password, and Database.
Program name | UserID | password | Database |
InventoryControl v6 & v7 | InventoryReader | ReadOnly@1ReadOnly@1 | WasptrackInventory |
MobileAsset v6 | AssetReader | ReadOnly@1 | WaspTrackAsset |
MobileAsset v7 (and v6 with strong password) |
AssetReader | ReadOnly@1ReadOnly@1 | WaspTrackAsset |
WaspTime v6 and v7 | TimeReader |
ReadOnly@01
(Note: this contains a zero,
unlike the other passwords)
|
WaspTime |
Click Next and Finish.
Highlight server name on the top pane and bottom pane, then click the Update button.
Repeat the above to replace all Server Names.