Connect Crystal Report with MS SQL DB

Environment details:

=====================================

Crystal Reports 2008 Sp3.

SQL server 2005.

Steps:

=====================================

A) Creating a DSN:

--------------------------------------

          1. Go to 'Administrative tools' -> 'Data Sources(ODBC)'.

          2. Select the 'System DSN' tab. Click 'Add'.

          3. Select 'SQL Server' driver and click 'Finish'.

          4. Provide the DSN name, say ProjectVegas. Select the database from the dropdown list.

          5. Click on 'Next' and provide authentication.

          6. Click 'Next' and 'Finish'.

B) In the Crystal Reports 2008 designer:

--------------------------------------

          1. Open the report in Design mode.

          2. Go to the 'Field Explorer' -> right click on the 'Database Fields' -> 'Set Datasource Location'.

          3. Create a new connection with the DSN created in Section B.

          4. Update the main report connection.

          5. Preview the report.

          6. Pass the parameter value and click on Apply.