windows form bai 9

7/29/2019 Windows Form Bai 9

1/26

i Hc S Phm Tp. H Ch MinhKhoa Ton Tin Hc

LP TRNH WINDOWSLP TRNH WINDOWS

To bo bi u viTo bo bi u virys a eporrys a epor

Gii thiu cc cng c to report Thit kReport vi Crystal Report

Trn Ngc Bo - Email: [email protected]


2/26







3/26

Gii thiu mu bo biu trong ng dng

NDOW

NDOW

ORT

ORT

N

HWI

N

HWI

LREP

LREP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL

TRN NGC BOTRN NGC BO KHOA TONKHOA TON --TIN HCTIN HC I HC S PHM TP.HCMI HC S PHM TP.HCM ((33))

TRN NGC BOTRN NGC BO KHOA TONKHOA TON --TIN HCTIN HC I HC S PHM TP.HCMI HC S PHM TP.HCM ((33))


4/26


NDOW

NDOW

ORT

ORT

N

HWI

N

HWI

LREP

LREP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL

TRN NGC BOTRN NGC BO KHOA TONKHOA TON --TIN HCTIN HC I HC S PHM TP.HCMI HC S PHM TP.HCM ((44))TRN NGC BOTRN NGC BO KHOA TONKHOA TON --TIN HCTIN HC I HC S PHM TP.HCMI HC S PHM TP.HCM ((44))


5/26


NDOW

NDOW

ORT

ORT

N

HWI

N

HWI

LREP

LREP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



6/26

Mt s cng c to Report

NDOW

NDOW

ORT

ORT MS Access 2000/XP/2003

N

HWI

N

HWI

L

REP

L

REP

LPT

LPT

RYST

RYST ry r .

CPH

CPH

HVI

HVI

ActiveReport - DataDynamics

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL

C1Report - ComponentOne



7/26


NDOW

NDOW

ORT

ORT ccess

N

HWI

N

HWI

L

REP

L

REP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



8/26


NDOW

NDOW

ORT

ORT Crystal Report 8.5/9/10/11

N

HWI

N

HWI

L

REP

L

REP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



9/26


NDOW

NDOW

ORT

ORT ActiveReport - DataDynamics

N

HWI

N

HWI

L

REP

L

REP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



10/26


NDOW

NDOW

ORT

ORT C1Report - ComponentOne

N

HWI

N

HWI

L

REP

L

REP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



11/26

Crystal Report v ng dng

NDOW

NDOW

ORT

ORT Bc 1: Thit kreport

N

HWI

N

HWI

L

REP

L

REP S dng c ng cCrystal Report to v c c

report thnh cc tp tin *.rpt

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

dng

NGH

NGH

P

TRN

P

TRN

Sdng Crystal Report Control lin kt cc

tp tin report *.rpt vo ng dng

BIG

BIGLL



12/26







13/26

Thit k Report vi Crystal Report

NDOW

NDOW

ORT

ORT Run cng c Crystal Report to cc tp

tin re ort

N

HWI

N

HWI

L

REP

L

REP

Lin kt vi Data Source (MS Access/SQL

LPT

LPT

RYST

RYST Server,)

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN c u

BIG

BIGLL Sp xp/gom nhm dliu



14/26


NDOW

NDOW

ORT

ORT Run cng c Crystal Report to cc

t tin re ort *.r t

N

HWI

N

HWI

L

REP

L

REP

Khi ng chng trnh Crystal Report bngcch ch n ln l t Start/Pro rams/Sea ate

LPT

LPT

RYST

RYST

Crystal Report Tools/Crystal Reports

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



15/26


NDOW

NDOW

ORT

ORT Lin kt vi Data Source (MS Access/SQL

Server

N

HWI

N

HWI

L

REP

L

REP

Chn menu File New

LPT

LPT

RYST

RYST n tan ar

Click buttonDatabasechn Data source cho

CPH

CPH

HVI

HVI

repor

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



16/26







17/26

Lin kt report vo ng dng

NDOW

NDOW

ORT

ORT Sdng Crystal Report Control trong danh schActiveX controls lin kt cc tp tin report

N

HWI

N

HWI

L

REP

L

REP .

Report

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL Crystal Report ControlCrystal Report Control



18/26


NDOW

NDOW

ORT


N

HWI

N

HWI

L

REP

L

REP .

Report

LPT

LPT

RYST

RYST c p c u t n a og

Chn mcInsert ActiveX Controltrong popup menu

CPH

CPH

HVI

HVI

Chn mcCrystal Report Controltrong dialog Insert

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL

rys a epor on rorys a epor on ro



19/26


NDOW

NDOW

ORT


N

HWI

N

HWI

L

REP

L

REP .

Report

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL Crystal Report ControlCrystal Report Control



20/26

Sdng Crystal Report Control

NDOW

NDOW

ORT

ORT Khai bo bin x l Report

N

HWI

N

HWI

L

REP

L

REP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



21/26


NDOW

NDOW

ORT

ORT Xc nh tp tin *.Rpt

N

HWI

N

HWI

L

REP

L

REP

CString sTenFileReport;

C php

LPT

LPT

RYST

RYST m_cr.SetReportF eName sTenF eReport ;

CPH

CPH

HVI

HVI

void CReportDemoDlg::OnPrintPreview()

NGH

NGH

P

TRN

P

TRN CString sTenFileReport = ..\Reportsv.rpt;

m_cr.SetReportFileName(sTenFileReport);

BIG

BIGLL }



22/26


NDOW

NDOW

ORT

ORT Hin th report (Preview)

N

HWI

N

HWI

L

REP

L

REP

m_crm_cr.SetAction (1);

C php

LPT

LPT

RYST

RYST

V d

CPH

CPH

HVI

HVI void CReportDemoDlg::OnPrintPreview()

{

CString sTenFileReport = ..\Reportsv.rpt;

NGH

NGH

P

TRN

P

TRN m_cr.SetReportFileName(sTenFileReport);

m_cr.SetAction(1) ;

}

BIG

BIGLL



23/26


NDOW

NDOW

ORT

ORT Report c tham s

N

HWI

N

HWI

L

REP

L

REP

m_cr.SetFormulas(Index,"TenFormula = GiaTri)

LPT

LPT

RYST

RYST

V d


CPH

CPH

HVI

HVI {



NGH

NGH

P

TRN

P

TRN CString s = "Khoa= ";

UpdateData();

s = s + "\'"+ m Khoa + "\'";

BIG

BIGLL

_m_cr.SetFormulas(0,s);

m_cr.SetAction(1);



24/26


NDOW

NDOW

ORT

ORT Thay i connectionstring

C php

NHWI

NHWI

L

REP

L

REP

CString sConnect = "DSN=" + sServer +";UID=" + sUser & ";PWD=" +

sPass + ";DSQ=" + sDBName;

LPT

LPT

RYST

RYST

_ .

V d


CPH

CPH

HVI

HVI {



NGH

NGH

P

TRN

P

TRN //////////////////////////////

CString sConnect = "DSN=" + tnb-laptop +";UID=" + dhsp +

";PWD=" + dhsp + ";DSQ=" + ADO;

BIG

BIGLL m_cr.SetConnect(sConnect);

/////////////////////////////

m_cr.SetAction(1);


}


25/26


NDOW

NDOW

ORT

ORT Sdng Formula

NHWI

NHWI

L

REP

L

REP

Lc dliu

LPT

LPT

RYST

RYSTSp xp/gom nhm dliu

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL



26/26

NDOW

NDOW

ORT

ORT

NHWI

NHWI

L

REP

L

REP

LPT

LPT

RYST

RYST

CPH

CPH

HVI

HVI

NGH

NGH

P

TRN

P

TRN

BIG

BIGLL


windows form bai 9

Documents