Select your Sql Server name, enter userid, password and select your Database Name. Next screen is the SQL Server authentication screen. Select Microsoft OLE DB Provider for SQL Server. Select OLE DB (ADO) from Create New Connection. Here we are going to select OLEDB connection for SQL Server Next step is to select the appropriate connection to your database. Select Report type from Crystal Reports gallery.Īccept the default settings and click OK. Then Add New Item dialogue will appear and select Crystal Reports from the dialogue box. The Product Table has three fields (Product_id,Product_name,Product_price) and we are showing the whole table data in the Crystal Reports.įrom main menu in Visual Studio select PROJECT->Add New Item. NET Project.Ĭreate a new Crystal Reports for Product table from the above database crystalDB. Please take a look at the database structure before you start this tutorial - Click here to see Database Structure. Īll Crystal Reports programming samples in this tutorials is based on the following database (crystaldb).
0 Comments
Leave a Reply. |