CRYSTAL SQL SERVER CONNECTION

Опубликовано: 25 Июнь 2026
на канале: Mr Zwain Code

How to connect to MSQL database from CRYSTALL REPORT.

Here are the queries to create the test database, table and insert records:

CREATE DATABASE ConnectionDemo;
use ConnectionDemo;
Create TABLE Student
(
ID INT IDENTITY PRIMARY KEY,
NAME VARCHAR(50) NOT NULL,
SURNAME VARCHAR(20) NOT NULL,
BIRTH_DATE DATE NULL
);

INSERT INTO Student(NAME, SURNAME, BIRTH_DATE)
VALUES('Nokuthula', 'Khumalo', '1995-03-12'),
('James', 'Smith', '1998-07-24'),
('Amina', 'Patel', NULL),
('Thabo', 'Mokoena', '2000-11-02'),
('Lindiwe', 'Ngcobo', NULL);