A Note On Crystal Report and Pervasive Server - Create Connection
1) Go to START/All Programs/Crystal Report 2011
2) “ODBC Data Source Administrator”.
4) Go to Start Page Tab/ Start a new report Section/ click Blank Report.
7) Insert fields to Details Section
12) A Query-based data connection
Steps
1) Go to START/All Programs/Crystal Report 2011
Notice that there is a shortcut “ODBC Data Source Administrator”
2) “ODBC Data Source Administrator”.
- Click the “ODBC Data Source Administrator”.
- Go to “System DSN” tab.
- If Pervasive Server has been installed correctly, DEMODATA should appear in the list of System Data Sources. This indicates that connection would be ok.
3) Run Crystal Report
4) Go to Start Page Tab/ Start a new report Section/ click Blank Report.
5) Select Database
- Select ODBC(RDO) Connection.
- Select DEMODATA. (Make sure the Data Source Name is clicked i.e highlighted)
- click Finish.
6) Select Person Table
7) Insert fields to Details Section
- Press and hold [CTRL] key
- Click ID, First_Name and Last_Name
- Release [CTRL] key
- Drag the items to the Details Section
8) View the SQL query
9) Copy the SQL code
10) Create another new report
Go to File/New
11) “Add Command” Option
- Click “Add Command”
- Paste SQL code
- Click OK
12) A Query-based data connection
- Go to Field Explorer
- Notice that the Database Fieds contain an item “Command” which is comprised of three sub-items ID, First_Name, Last_Name
