Net-informations.com

Sample Database for running Crystal Reports tutorials

In the following section you can see , how to create a sample Database and Tables and data for running Crystal Reports Tutorials . All examples in the VB.NET Crystal Reports Tutorials are based on the following database . First we have to create a database . Give the database name as "crystaldb"

Create a DataBase "crystaldb"

In the crystaldb database , create three tables.

  1. OrderMaster
  2. OrderDetails
  3. Product

OrderMaster

  1. OrderMaster_id
  2. OrderMaster_date
  3. OrderMaster_customer
  4. OrderMaster_createduser

OrderDetails

  1. OrderDetails_id
  2. OrderDetails_masterid
  3. OrderDetails_productid
  4. OrderDetails_qty

Product

  1. Product_id
  2. Product_name
  3. Product_price

The following picture shows the relations of each table :

crytal_report_table_relations.JPG

SQL command for creation tables are follows :

Enter data to the tables :

Order Master Table Data

crytal_report_ordermaster_data.JPG

Order Details Table Data

crytal_report_orderdetails_data.JPG

Product Table Data

crytal_report_product_data.JPG








net-informations.com (C) 2019    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.
SiteMap  | Terms  | About