Here I am using Standard Report
Then create new connection. In order to establish the connection select OLE DB (ADO) as datasource.
Then select a provider from the list. Here I am selecting a SQL Server Native Client 10.0 because i am using SQL Server as a database. After selecting the provider click on next button.
After selecting the provider, you have to provide the server name, user id and password of the database and select the database. If don’t want to provide userid and password then check Integrated Security. After providing the necessary information click next to finish the process.
After selecting the database you have to select the table and add it to the selected
table list, in order to show the details. Here I am selecting a customer table
from the database workbook where some customer records are present and it to
the selected tables list.
Then click on next button.
After selecting the table you can select the fields from the table which you want to display in the report and click on the finish button. If you won’t to select the field you can drag the fields of the table from the Database field and drop it into the Details section.
After finshing the process you can see the preview of the report from Main Report Preview or just run a application.