If you are using ReportDesigner
for designing report, follow these steps
1)
Click on File Menu>Add New
Report
2)
This will show a dialogue box for creating
connection string, click on Build Connection String button.
3)
Here choose Microsoft OLEDB Provider for SQL
Server in Provider tab.
4)
In connection tab, select name of your
Sql Server and DataBase name.
This will create a connection
string and wizard will allow you to proceed further and create complete
report.
If you are setting connection
string in code, you will need to set ConnectionString property of report, it
will look like this-
Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial Catalog=DataBaseName;Data
Source=SQLServerName
I hope this helps.
-Dave.
How to add a connectionstring to connect to sqlserver database
http://helpcentral.componentone.com/cs/forums/p/74792/203364.aspx#203364