Posts

Showing posts from April, 2022

How to Create a Crystal Report MySQL Database Report

Image
  In this lesson I will discuss "How to Create a Crystal Report MySQL Database Report" this tutorial is very suitable for those of you who are learning VB 6.0 or VB .Net programming with reports using Crystal Report. Below are the steps: Make sure you have installed = Crystal Report and Xampp Because you will create a report, make sure you have created a database and table: Create a database on Xampp with the name: DBJNM Then create a table with the name: TBL_PRODUCT Create data as shown below:   If so, please open your Crystal Report     Click File - New     Select Standard - OK   Select Database - OLEDB - Make New Connection Click Add     Click Connection - Use Connection string - Click Build     Click New     Klik Next     Select MySQL ODBC 3.51 Driver Click Next - Finish     Create data as shown above (Connect DBJNM - root - dbjnm ) Click OK  Click OK again     Then it will appear li...

How to Create a Crystal Report SQL Server Database Report

Image
  Back again in the Crystal Report Report tutorial, this time I will discuss about "How to Create a Crystal Report SQL Server Database Report". For those of you who are learning VB 6.0 or VB.Net whose database uses SQL Server, this tutorial is perfect for you. So that you understand better in making Crystal Report Database SQL Server reports, we use step by step so that you understand it easier. Below are the steps, please follow...   Make sure you have installed SQL Server and Crystal Report. this time I'm using SQL Server version 2008 R2 Create a database with the name: DBJNM Create a table with the name: TBL_CUSTOMER Here's the design and please fill in the sample data:   If you have, please save and let's continue in making reports with Crystal Reports Open your Crystal Report Click File - New     Click Standard - OK   Select More Database Sources - Make New Connection Click Add   Pilih SQL Server Native Clinet 10.0   Click Connection Selec...