C# Crystal Reports Tutorial

C# Crystal Reports sample databse For generating Crystal Reports from C# , we need to connect a database and some tables with data. In the following section you can see how to create a sample Database and Tables and the data for running of the following Crystal Reports - C# Tutorial . All examples in the CSharp Crystal Reports Tutorial is based on the following database . First we have to create a database named it as "crystaldb" Create DataBase "crystaldb" In the crystaldb database , create three tables. | C Crystal Reports Tutorial Crystal Reports sample databse For generating Crystal Reports from C we need to connect a database and some tables with data. In the following section you can see how to create a sample Database and Tables and the data for running of the following Crystal Reports - C Tutorial . All examples in the CSharp Crystal Reports Tutorial is based on the following database . First we have to create a database named it as crystaldb Create DataBase crystaldb In the crystaldb database create three tables OrderMaster OrderDetails Product . The Table Structure follows OrderMaster OrderMaster_id OrderMaster_date OrderMaster_customer OrderMaster_createduser OrderDetails OrderDetails_id OrderDetails_masterid OrderDetails_productid OrderDetails_qty Product Product_id Product_name Product_price The following picture shows the relation of tables in crystaldb database OrderMaster OrderMasterjd OrderMasterjdate OrderMaster_customername OrderMaster_createduser OrderDetails Prt Jduct Productjd Product_name Product_price A 1 1 1 A OrderDetailsjd OrderDetail5_masterid OrderDetail5_productid OrderDetails_qty http SQL command for creating tables are follows CREATE TABLE dbo . OrderMaster OrderMaster_id int NOT NULL OrderMaster_date datetime NULL OrderMaster_customername varchar 50 OrderMaster_createduser varchar 50 ON PRIMARY CREATE TABLE dbo . OrderDetails OrderDetails_id int NOT NULL OrderDetails_masterid int NULL OrderDetails_productid int NULL OrderDetails_qty int NULL ON PRIMARY CREATE TABLE dbo . Product Product_id int NOT NULL Product_name varchar 50 Product_price numeric 18 0 NULL ON PRIMARY Enter some data to the tables From the following pictures you can see some data in the table for C - Crystal Reports tutorial Order Master Table Data 0rderMa3ter_id OrderKaster_date OrderMa3ter_customernane OrderMaster_createduser 1 1 2007-01-01 a. . customerl user 2 2 2007-01-16 0. customers user 3 3 2007-02-06 0. customer user 4. . . 2 .