visual studio 2017 tutorial visual basic

Select Form's source code view and put the code on top. Select the default form (Form1.vb) you created in VB.NET and drag a button and CrystalReportViewer control to your form. Now the designing part is over and the next step is to call the created Crystal Reports in VB.NET through Crystal Reports Viewer control. Your screen look like the following picture. You can arrange the design according your requirements. Then you can see the Crystal Reports designer window. Select all fields from Product table to the right side list.Ĭlick Finish Button. Then you will get your Server name under OLEDB Connection from there select database name (Crystaldb) and click the tables, then you can see all your tables from your database.įrom the tables list select Product table to the right side list. Click next, Then the screen shows OLE DB Property values, leave it as it is, and click finish. Select your Sql Server name, enter userid, password and select your Database Name. Next screen is the SQL Server authentication screen. This tutorial requires that you have running SAP HANA instances. Select Microsoft OLE DB Provider for SQL Server. This tutorial describes how to use SAP HANA with Microsoft Visual Studio 2017. 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).

Visual studio 2017 tutorial visual basic