Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Discontinued Products
  • InventoryControl
  • Version 7
  • I am using Crystal Reports to try and create custom reports for my Wasp product; I keep getting a log in screen when trying to access the database.
Subscribe Download PDF

I am using Crystal Reports to try and create custom reports for my Wasp product; I keep getting a log in screen when trying to access the database.

Internal User
2017-08-14
in Version 7

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.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

1 of 6 people found this page helpful

Related Pages

  • Multiple Products: Custom Reports

Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro