It Starts With The Source

Start your exploration of direct access reporting by creating a data source. This is the heart of the whole thing. Crystal uses the data source as a conduit to the MISys SBM database, giving you access to the tables in the database.

To create a Data Source:

1. Click Start, point to Control Panel, double-click Administrative Tools, and then double-click Data Sources (ODBC).
2. Click the System DSN tab, and then click Add.
3. Click on SQL Server and then click Finish.
4. Type the data source name (e.g. MISYSSBM). Remember what you choose. You will need to use it in Crystal.
5. Select the Server where MISys SBM is installed. If you are using the instance of SQL provided with MISys SBM, the you would be looking for \MISYSSBMSE, and then click Next.
6. Select With SQL Server Authentication for verifying Authenticity. Then use the User Name and Password of the SQL Server that will have access to the database. If you are using the instance of SQL provided with MISys SBM, contact technical support for this information.
7. Click Next through the next windows and then click Finish.

Now you have a data source to use in Crystal Reports to access the MISys tables directly.

Visit MISys Manufacturing Support at www.misysinc.com/support.php

Remember that you can use Crystal reports to report directly from your MISys SBM database.

It is a standard MS-SQL database, so all you need to do is make a System data source for SQL and then direct it to the database engine where the MISys SBM database resides. Then create a new report in Crystal using an ODBC (RDO) data source and select the data source you just made. Fill in the information and select the database to use and you’re off and running.

Oh, and If you are interested in our table layouts start SBM and go to Administration Housekeeping Print Data Tables.

For MISys Support, visit us online at misysinc.com/support.php