5 L~p trlnh Web sir d\lng ASP.NET va Visual C# DU'O'ngQuang Thif!

Tip6:Liptrlnhb6oc6os~d,ng
Crystal Reports .NET
. Luc
Muc .
MIJCIlJc , 5

ChU'O1lg 1 Tang quan vJ Crystal Reports .NET

I

11.1 Crystal Reports la gl? 29

~ 1.2 B~n co the lam du'gc gl voi Crystal Reports? 30
! 1.3 Crystal Reports .NET khck bi~t so voi cac phien bitn Crystal
Reports tru'oc the nao? .35
1. 3.1 Integrated Design Environment (IDE) 35
1.3.2 Bat cu ngon ngG' niw, bat cu luc naG 35
1.3.3 Cae phLfdng phap h9i nh~p 36
1.3.4 D~ su dl,lng 36
1.3.5 Xay dl/ng cae ling dl,lng cong ty XInghi~p 36
1.3.6 Kien true baa cao 38
1.3.6.1 Kien true kieu c1dn tang (single-tier) 39
1.3.6.2 Kien true kieu luting tang (two-tier) 39
1.3.6.3 Kien true kieu tam tang (three-tier) 40
1.3.6.4 Cae LIng dyng c1atang (multi-tier application) , 40
1.3.7 Report Designer 41
1.3.8 NhG'ng diem khong tLfdng thlch 42

1.4 Cac Igi diem cua Crystal Reports.NET 43

1.5 HQc tu cac ((ng dlJng m§u ' 44

1.5.1 Cai d~t cae ling dl,lng m§u 44
1.5.2 Cae baa CaDm§u 46
1.5.3 DG'Ii~u m§u 47

ChU'O1lg2 Hiiy thiT bdt ilau vOi Crystal Reports .NET

2.1 ThISt~o bao cao dau tien rat ddn gian 48
M\lcl\lC 6

2.2 Bao cao thIS hai tinh vi hdn mQt chut 56

2.3 Thi dl:l thIS 3 phuc t~p hdn: Bao cao International Sales.rpt 65

2.4 Lam vi(!c voi Report Design Environment 85

2.4.1 Tr1nhddn va Thanh cong cl,l 85
2.4.2 Cho d~t de cac thuQc tfnh m~c nhien 86

2..5 Cae dfeu cd bermve thie't ke bao cao 87

2.5.1 Cac phan do(;!n cua baa CaD(report section) 87
2.5.2 £)jnh d(;!ng baa cao ,...,; 89
2.5.3 Cac dai tu'qng vung ml,lc tin (field object) 90
2.5.3.1 Database Fields 90
2.5.3.2 Text Objects 91
2.5.3.3 Special Fields 91
2.5.3.4 Summary Fields 92
2.5.3.5 Formula Fields 93
2.5.3.6 Parameter Fields 94
2.5.3.7 SQL Expression Fields 96
2.5.3.8 Unbound Fields 97

ChU'O'hg 3 Tim hiJu Crystal Reports Object Model

3.1 Cd ban ve uon nan cae bao cao 99
3.1.1 ASP.NET Template 102

3.2 Tim hieu ve doi tu'gng ReportDocument 103

3.2.1 Tim dQccac thong tin tom Iu'qc- Lop Summary Information 106
3.2.2 Cho d~t de cac thuQc tfnh baa CaD- LopReportOptions 107
3.2.3 Ketnai ve dCfli~unguon - Lop Database " 107
3.2.4 Th,ay doi cac ml,lc chQn may in - Lop PrintOptions 108
3.2.5 Xuat khau cac baa CaD- Lop ExportOptions 110
3.2..6 Qui chieu va d!nh d(;!ngcac d6i tu'qng baa CaD-
Lop ReportDefinition 111
3.2.7 Thay doi cac dai tu'qng baa CaD- Lop DataDefinition 111

3;3 Tim hieu doi tu'gng CrystaIReportViewer 111

3.3.1 Phim ung tru'oc cac tlnh huang 113
3.3.2 Thl,lly cac bi~t I~ 117
7 L~p trinh Web sir d\mg ASP.NET va Visual C# DU'ong Quang Thirn

ChU'ong 4 slip xip & G{Jpnh6m

v N , ~ . 120
4. 1 S ap xep cac mau tin .................................................................
4.2 G{)ptheo nham cac m~u tin 122
4.2.1 Them cck nhom va u6n nan nhom 123
4.2.2 Sap xep dG'Ii~u nhom 127

4.3 Thay doi vung ml}c tin dung g{)p nham 127

4.4 Cho hii~n thi cac bim baa cao Top N 128

4.5 Cho hien thi baa cao d~ng cap 129

4.6 Xoay sau vao chi tiel dU' Ii~u 130

4.7 Tong ket dU' Ii~u 132

4.8 L~p trinh mo hinh doi tu'qng lien quan den sap xep va
g{)p nham 135
4.8.1 Tim hieu cae lop Sorting va Grouping 135
4.8.2 Anh Xi;!cae d6i tu'<;1ng
sap xep va gQPnhom 138
4.8.3 L~ptrlnh cae d6i tu'<;1ngsap xep va gQPnhom 142
4.8.4 Tim hieu cae lop Summary Field 146

ChU'ong5 Sir d{lng cae thong sa

5.1 Nh~p thong 50 149
5.1.1 Them cae thong 56 149
5.1.2 Cho d~t de cae trj m~c nhien 152
5.1.3 Nh~p vao thong 56 khi chi;!Ybaa cao 154

5.2 L~p trinh mo hinh doi tu'qng lien quan den cac thong so 155
5.2.1 Thay the cae thong 56 boi nhG'ng cong thU'c 156
5.2.2 Tim hieu cae lop Parameter 157
5.2.2.1 Anh x<;1GiG lap Parameter 161
5.2.2.2 L?p trinh cck lap Parameter 163
5.2.2.3 L?p trinh vai lap ReportDocument 164
5.2.2.4 L?p trinh vai lap CrystaIReportViewer 167
5.2.3 Thay doi cae thong 56 cua Subreport 169
5.2.4 Ddn giim hoa vi~c I~p trinh cae thong 56 169
MI}C ll}c 8

ChU'ong6 Uan niin cac bao cao

6.1 ChQn ra cac mau tin 174
6.1.1 sa dung Select Expert 174
6.1.2 ChQn'cae m~u tin de gQPnhom 178

6.2 Cac phan do~n (section) 178

6.2.1 £)jnh di;!ngcae ph~1ndoc;m 179
6.2.1.1 Che dfiu va ga b6 phfln daijln 181
6.2.1.2 In ra cck phan daijlnvaa CUD!trang 181
6.2.1.3 Ep sang trang 182
6.2.1.4 Cho s6trang tra ve 1 182
6.2.1.5 GiiJ'cac phan da?n nam vai nhau 182
6.2.1.6 Ga b6 nhiJ'ngphan da?n trang 183
6.2.1.7 Cho nam du'ai cac phan da?n sau day , 183
6.2.1.8 Djnh d?ng vai nhieu cQt 185
6.2.2 Them VaG nhieu phan doi;!n 187

6.3 Running Totals ..192

6.4 L~p trinh mo hinh doi tuQng Crystal Reports Engine 195
6.4.1 Thay doi Record Selection , 196
6.4.2 Anh xi;!cae lop ReportDefinition 197
6.4.3 L~p trlnh lop ReportDefinition the naG? 202
6.4.3.1 Qui chie'u cac d6i tu'r;fngbaa caa the naa? 204
6.4.3.2 Thay doi cac thuQc tfnh cua Report Object 205

ChU'ong 7 Tim hiiu vi Cong thirc va LOgic chU'O7lgtrinh

7.1 Cho hQi nh~p Cong thLtc va Logic vao cac ban bao cao 207
7.1.1 Cau true can ell'dO'li~u 208
7.1.2 DO'li~u ung dl:mg : 209
7.1.3 Cae I~nh Crystal SQL 210
7.1.4 Cae bieu thuc Crystal SQL 211
7.1.5 Cae cong thuc 212
7.2 Lam viec vai Formula Editor 213
7.2.1 Dieu khien dang dap cua Formula Editor 213
""\ 1.1.. ~~~ ~'\\\~\\\~~\~~\\~~\\ 217
7.2.3 Kiem tra 16icu phap , 218
7.2.4 Sadl,lng cae cong thuc detfnh toan 219
7.2.5 D!nh dc;mgoQng sa dl,lng cong thuc 220
- - --
M1.IcI1.IC 8

ChtfO11g 6 u an ntin cae baD CaD

6.1 ChQnra cae mau tin 174

6.1.1 Su dung Select Expert 174
6.1.2 ChQn'cac m~u tin de 99P nhom 178
6.2 Cae phan do'i:'n (section) 178
6.2.1 D!nh dc;mgcac phfm doc;m 179
6.2.1.1 Che dfiu va go b6 phan ooi;m 181
6.2.1.2 In ra CC3cphan oot;1nVaGcu07trang 181
6.2.1.3 Ep sang trang 182
6.2.1.4 Cho so trang tra ve 1 182
6.2.1.5 GiiJcac phan oot;1nnam vai nhau 182
6.2.1.6 Go b6 nhiJng phan oot;1ntrang 183
6.2.1.7 Cho nam dLfClicac phan oot;1nsau Clay 183
6.2.1.8 fJjnh dt;1ngvClinhi'eu cQt 185
6.2.2 Them VaGnhieu phan do~rl """"""""""""""""""'" 187

6.3 Run ning Totals ~ .19 2

6.4 L~p trinh mo hinh doi tuQng Crystal Reports Engine 195
6.4.1 Thay doi Record Selection 196
6.4.2 Anh xc;!cac lop ReportDefinition 197
6.4.3 L~ptrlnh lop ReportDefinition the naG? ..." 202
6.4.3.1 Qui chieu cac 007 tLfqng baa CaDthe naG? 204
6.4.3.2 Thay ooi cac thuQc tfnh cua Report Object 205

ChtfO11g7 Tim hiiu vi C{jng thue va L{jgie ehlfO'llg trinh

7.1 Cho hQi nh~p Cong thuc va Logic vao cae bim bao cao 207
7.1.1 Cau truc can cu dO'li~u..; 208
7.1.2 DO'li~u lIng dl,lng 209
7.1.3 Cac I~nh Crystal SQL 210
7.1.4 Cac bieu thuc Crystal SQL 211
7.1.5 Cac cong thuc 212

7.2 Lam viE~cvai Formula Editor 213

7.2.1 Di"eukhien dang dap cua FormulaEditor 213
7.2.2 Dieu khien loai cu phap 217
7.2.3 Kiem tra 16ic~ phap 218
7.2.4 Su dl,lng cac cong thuc de tfnh toan 219
7.2.5 D!nh dc;!ngd9ng SUdl,lng cong thuc 220
9 L~p trinh Web su d\lng ASP.NETva Visual C# DU'O'flgQuang Thi?n

7.2.5.1 Them cae e6~g thtJe 220

7.2.5.2 StJdl,mg Default Attribute va Current Field Value 223

7.3 T~o cae cong thuc viti Basic Syntax 224

7.3.1 Basic Syntax la gI7 224
7.3.2 Qui u'oc I~p trlnh Basic Syntax ,' 225
7.3.3 Cac kieu dCi'lieu 229
7.3.3.1 Cae kieu' dif li~u c1dn gian """"""""""""""""""""""" 229
7.3.3.2 Kieu dif li~u ban day 230
7.3.3.3 Kieu dif li~u Range 232
7.3.4 Cac tac tlr'ddn giim & Ham 235
7.3.4.1 Tae ttJ toan so hQe 236
7.3.4.2 Tae ttJ Boolean 237
7.3.4.3 Tae ttJ so sanh 238
7.3.4.4 Tae ttJ ehuy€n c1&kieu dif li~u 238
7.3.4.5 Cae ham tong ket (summary functions) 241
7.3.4.6 Cae ham thao tae ehu6i """""""""""""""""""""""" 241
7.3.4.7 Cae ham Date & Time 246
7.3.4.8 Cae thuQe tfnh Print State va Document 252
7.3.4.9 Djnh dc;Jngcae trj ke't xufit 253
7.3.4.10 Cae ham toan hQe""""""""""""""""""""""""""" 255
7.3.4.11 Ket sinh soJJa't ky (random number) : 256
7.3.4.12 Djnh trj Time Default 256
7.3.5 Cac cau truc dieu khien 260
7.3.5.1 Cae ea'u true c1ieuki~n 261
7.3.5.2 Cae ham c1ieuki~n 263
7.3.5.3 Cae ea'u true vong I?p 266
7.3.5.4 Cae bieu thtJe c1ieuki~n 267

7.4 T~o cae cong thuc sit dl,lng Crystal Syntax 267
7.4.1 Khac bi~t so voi Basic Syntax """""""""""""""""""""""" 268

7.5 T~o cae cong thuc chQn m~u tin 270

7.6 L~m vi~c viti dinh d~ng thee dfeu ki~n 271
7.6.1 Tim hieu dinh d<;lngtheo dieu ki~n 272
7.6.2 £)!nhd<;lngtheo dieu ki~n d6i voi thuQc tfnh boolean 273
7.6.3 £)!nhd<;lngtheo dieu ki~n d6i voi cac thuQc tfnh co nhieu tr! 273

Chuong 8 Ve biiu dB thi nilO?

8.1 Them mot bieu do vilo bim baa cao , 279
8.1.1 Ch9~ ra mQt lo<;libieu do su dl,mg Tab Type 280
M\lcl\lC 10

8.1.1.1 Side-by-side bar chart 282

8.1.1.2 Stacked bar chart , 282
8.1.1.3 Line chart 283
8.1.1.4 Area chart , 283
8.1.1.5 Pie chart 284
8.1.1.6 Doughnut chart 285
8.1.1.73-0 Riser chart 285
8.1.1.83-0 Surface chart 286
8.1.1.9 XY Scatter chart 287
8.1.1.10 Radar chart , 287
8.1.1.11 Bubble .chart 288
8.1.1.12 Stock chart 289
8.1.2 Cach b5 tri bieu do khac nhau d5i vai nhG'ngkieu
dG'lieu khac nhau 290
8.1.3 Ch6 'd~t bieu do anh hu'ang len dG'Ii~u no tu'qng tru'ng 291
8.1.4 Cho d~t de cac data points su dvng Tab Data 291
8.1.4.1 D~t ae ml,lc chQn Evaluate 293
8.1.4.2 D~t ae cck vimg ml,lc tin tren Show Value(s) 295
8.1. 4.3 Thoa man aai hoi vimg ml,lc tin to, thieu 295
8.1.5 Them vao cae group chart 296
8.1.6 Them cac bieu do Cross-Tab 298
8.1. 7 Cho d~t de cac tieu de thong qua tab Text 299

8.2 SLtdl,lng Tab Options cua Chart Expert 300

8.3 SLtdl,lng trinh ddn Format Chart 302

8.4 Tit mQt bieu do bc;mcho xoay sau vilO chi tiet 304

8.5 Thay doi mQt bieu do 304

8.6 MQtthi dl,l de ket thuc 305

Ch U'O1lg9 T{lo bao cao Cross-Tab

9.1 ThLttiilomQt thi dl,lcross-tab tong ket tat ca dCi'Ii~u
ban bao cao 308

9.2 Thi dl,l mQt 'cross-ta~ tong keJ;nQi dung mQt group 314
9.3 Ti~' b~~U\~e'~~~i~~.J cao cross-tab 316
. 1.." >,'~A . ~~ ""';:(J~
9.3.~..T.(;U:uJ)QJ:.doJtU'ql~ cross-tab 319
9.3.2 Qat VaQphi'>d5i ~u'dng cross-tab 321
~ :~'\.~'>:.I(>'. .'
._.
I
II' 11 Ui p trinh Web sir dun ASP.NET va Visual C#
. g DU'O'1lgQuang Thi{in

9.3.3 Djnh di;lng khung Iu'oi cross-tab 323

9.3.4 Djnh di;lng cac thuQc tfnh Style 324
9.3.5 Quan Iy cac cQt " 326

ChU'O1lg10 Them Subreport VilObao clio chinh

10.1 Cac mlJc chQn cho phep ket noi subreport
voi bao cao chinh 330
10.1.1 Ket noi voi vung ml,lctin din cu dCi'li~u 331
10.1.2 Ket noi voi mQt vung ml,lctin cong thuc 332
10.1.3 Su dl,lngcac subreport ba't ket noi 334
10.1.4 Dung cac vung ml,lctin cong thuc khong ket noi 334
10.1.5 Trao qua dCi'li~u thong qua cac bien shared 335

10.2 Them mQt subreport vao bao cao chinh 336

10.2.1 Ket noi voi mQt vung ml,lctin can cu dCi'li~u 337
10.2.2 Ket noi voi mQt formula field 338
10.2.3 Cac Subreport bat ket noi 339
10.2.4 Bat ket noi voi mQt cong thuc 339
10.2.5 Bat ket noi voi bien shared 340

10.3 Hi~u dinh Subreport 342

10.4 Su' dlJng On-Demand Subreports 347

10.5 L~p trinh mo hinh doi tu'gng Crystal Reports Engine

doi voi Subreport 350
10.5.1 Thay doi cac Subreport 350

ChU'O1lg11 Bpi nh{ip bao clio VilOmzg d{lng Windows

11.1 £)~t ke hoC1lChcho ung dlJng cua be;m 354
11.1.1 Khao sat moi tru'ang trien khai 356
11.1.2 Bat dau mQt lIng dl,lng Windows moi su dl,lng Visual C# 356

11.2 Xac dinh dung mo hinh doi tu'gng 357

11.3 Tim hh~u namespace CrystaIDecisions.Windows.Forms 359

. ~._'--.~-"""""'
11.4 Su' dlJng Crystal Report Viewer cho Win, ,?Ws{lFPftltf~:!Hii«t 360
11.4.1 Them mQt baa cao vao lIng dl,lng ..i-.~1tr-\"i!;:-.j,~...t 362
11.4.2 Them mQt Report Viewer vao Windows .'. 1M
~ '

~.~!;.t:~... 362

::IT3i;i;
11.4.3 Go n ket mQt baa CaDVaGRepart Viewe. .. ..
-_J:i~I 363
M\lC l\lc 12

11.4.3.1 G!m ket theo ten btJOcao 363

11.4.3.2 Gan ket theo da7 tLic;fngbaa cao 363
11.4.3.3 Gan ke't vai m{)t Untyped Report 365
11.4.3.4 Gan ke't vai m{)t strongly-typed Report 366
11.4.4 Chuyen giao thong tin dang nh~p can ClI dCfli~u 367
11.4.5 Cho d~t de Report Record Selection 369

11.5 Cho uO'nnan dang dap va cach bO'tri cua Report Viewer 371
11.5.1 Cac ham hanh sl/ cua 0 control CrystalReportViewer 374
11.5.1.1 In ra m{)t ban baa cao 375
11.5.1.2 Refresh dfl li~u tren m{)t ban baa cao 378
11.5.1.3 Exporting m{)t ban baa cao , 378
11.5.1.4 Page Navigation va Zoom 381
11. 5.1. 5 Truy tlm trong long m{)t ban baa cao 384
11.5.2 SU'dl,mg cac tlnh huang viewer 385
11.5.2.1 Cae tlnh hu6ng Page Navigation 386
11.5.2.2 Cae tlnh huang Refresh 386
11.5.2.3 Cae tlnh huang SeCJrch 387
11.5.2.4 Cae tlnh hu6ng Viewer 387
11.5.2.5 Cae tlnh huang Zoom 388
11.5.3 Xoay sau VaGchi tiet ban baa cao 388
11.5.4 Xoay sau IEmcac subreport 391
11.5.5 Lam voi nhCfngbi~t I~ tren cac bc:mbaa cao 391

ChU'O11g12 Hf)i nh{ip baD CaD VilOring d{lng Web

12.1 £)~t ke ho(;1ch cho ((ng dl,lng cua b(;1n 393

12.2 ThU'khao sat moi tru'ong trien khai 395

12.2.1 Truoc khi ta b~hdau VaGcu<;>c 396
12.2.2 B~hdau mQt ling dl,mg web moi voi Visual C# 396

12.3 Xac dinh dung mo hinh dO'itu'gng 397

12.4 Tim hieu namespace CrystaIDecisions.Web.Forms 398

12.5 SU'dl,lng 0 control Crystal Report Viewer dO'iviti Web Forms ..400
12.5.1 Them mQt baa cao VaG ling dl,lng """""""""""""""""""'" 402
12.5.2 Them Report Viewer VaGmQt Web Form 405
12.5:'.3Gan ket ni§(bao cao VaGReport Viewer 405
12.5:3:1
, ..
Gan ke't theo ten baa cao
.' ,,"
405
12.'5:J,.2,GaQ. ~ettheo Report Object """""""""""""""""""'" 406
12.5.3.3 Gan ket vaj m{)t baa cao untyped 407
12.5.3.4 Gan ket vCfIm{)t Strongly-Typed Report 409
13 L~p trinh Web sir d1}ngASP.NET va Visual C# DU'O'1lg Quang Thi?n

12.5.3.5 GEmket vai m9t Strongly-Typed Cached Report 410

12.6 Uon nin dang dap vii cach bo tri cua Report Viewer 411
12.6.1 Cac ham hanh sl/ cua 0 control CrystalReportViewer 415
12.6.1.1 ChoaijItae vi~c to ve browser 417
12.6.1.2 Lam tu'di dfJ li~u tren m9t bao cao 417
12.6.1.3 Page Navigation va Zoom 418
12.6.1.4 Truy tim ben trong m9t ban bao cao 420
12.6.2 In raban baa cao 421
12.6.2.1 In tit Browser 423
12.6.2.2 In tit Adobe Acrobat Plug-In 424
12.6.2.3 In ra tit cac Export Formats khac 426
12.6.3 Su dl,mgcac t]nh huong cua Viewer ! 428
12.6.3.1 Page Navigation Events 428
12.6.3.2 Refresh Events 429
12.6.3.3 Search Events 429
12.6.3.4 Zoom Events ."',"""""""""""""""""""""""""""'" 430

Chmmg 13 T(lOXML Report Web Services

13.1 Tong quan ve XMLReport Web Services 431
13.1.1 XMLReport Web Service la g]? 433
13.1.2 Lam the nao su dl,mgmQt XMLReport Web Service? 434
13.2 T~o XML Report Web Services 435
13.2.1 T90 mQt Report Web Services cd ban 435
13.2.2 T90 Report Web Services voi nhieu ban bao cao 438
13.2.3 Su dl,mg Report Web Service chung chung (generic) 438

13.3 Tieu thl:l XML Report Web Services 440

13.4 External Report Web Service 441

13.5 Internal Report Web Service 443
13.5.1 Generic Report Web Service 444

13.6 Viii suy nghi ve vi~c trien khai Report Web Services 445

13.7 L~p trinh mo hinh doi tu'Qng Crystal Reports Engine 448
13.7.1 Thay doi baa cao vao luc Ch9Yphfa Client 448
13.7.2 Thay doi baa cao vao luc ch9y tU phfa Server 449

ChU'O11g14 Lam viic vOi cac di¥ liiu ngu8n

Ml}cll}C 14

14.1 Truy c~p dLi'Ii~u voi Crystal Reports.NET 452

14.1.1 Cac t~p tin can cu dCi'li~u 453
14.1.2 Cac can cu dCi'li~u quan h~ 454
14.1.3 OLAPData 455
14.1.4 Crystal Dictionaries, Queries va Info Views 455
14.1.5 Cac dCi'Ii~u nguon khac , 455

14.2 Uim vi~c voi cae dLi'Ii~u nguon 456

14.2.1 Cho d~t de cac ml:JcchQn can cu dCi'li~u 456
14.2.2' Them mQt can cu dCi'li~u ho~c mQt bang dCi'li~u
VaG mQt baa CaD 459
14.2.3 Su dl:Jng khung d6i tho<;liDatabase Expert I Tab Links 462
14.2.4 Kiem tra cau truc can cu dCi'Ii~u dung trong ban baa CaD 466
14.2.5 Thay doi ndi dinh cu' cua mQt can cu dCi'Ii~u 467
14.2.6 " Cho dat. de mot
. Database Alias 470

14.3 Lam vi~c voi SQL Commands 472

14.3.1 Djnh nghTa cac bang dCi'li~u 130 473
13.3.2 ChQn ra cac bang dCi'li~u va vung ml:Jctin " 477
14.3.3 Cho sang IQccac m~u tin 478
14.3.4 Sap xep va gQP nhom cac m~u tin 481
14.3.4.1 Nh{Jng h?n che 06i vai Sorting va Grouping 481

14.4 Lam vi~c voi SQL Expression 482

14.4.1 T<;Iobieu thuG SQL 483

14.5 Lam vi~c voi ADO.NET 486

14.5.1 MQtADO.NET Dataset 486
14.5.2 Nhln xem nQi dung cua mQt Dataset 490
14.5.3 T<;IomQt baa CaDtU' mQt ADO.NET Dataset 494
14.5.4 Nhln xem cac baa CaDco chua mQt ADO.NET Dataset 496

14.6 L~p trinh mo hinh doi tu'QngCrystal Reports Engine 499

14.6.1 Thi Gong Push Model 500
14.6.1.1 Djnh nghTatfjJptin It./<;fc
00 Dataset 501
14.5.1.2 Xay dt/ng baa CaDdung den tfjJptin DataSet 506
14.5.1.3 Cho oFen oEWd{J li~u fen 067 tt./<;fngDataSet 508
14.6.1.4 Cho gan ke't DataSet vai bim baa cao 513
14.6.2 Lop Database ' 514
14.6.3 Dang nh~p VaGdCi'Ii~u nguon an toan 516
14.6.3.1 Dang nhfjJpsudl,lng ReportDocument 517
14.5.3.2 Dang nhfjJpsu dl,lng Viewer Control 518
14.6.4 Cac thong s6 va stored procedure 519
15 L~p trinh Web sir d\lng ASP.NET va Visual C# DU'O'1lgQuang Thifn

14.6.4.1 SET NOCOUNTON 521

14.6.4.2 Thay aoi d{j' Ii~u nguon bang I?p trinh 522
14.6.5 Lam vi~c voi cac Subreport " 527
14.6.6 In ra cac hinh anh d9ng 528

Chmmg 15 Xuat khan va triJn khai hOflt tl{Jngcac baD CaD

15.1 Xuat khan cae baa cao 532
15.1.1 Xuat khau thong qua Viewer 533
15.1.2 Xuat khau thong qua I~p trinh 534
15.1.3 Xuat khau d~ dang h~n t~p tin ilia 535
15.1.4 Xuat khau cap cao hdn 537
15.1.5 Xuat khau ve ghi len m9t ilia tU' : 539
15.1.6 Xuat khau ve Email 540
15.1.7 Xuat khau ve Exchange Folder 541
15.1.8 D!nh di;Jng doi voi cac tai li~u PDF, RTF va Word 542
15.1. 9 D!nh di;Jng xuat khau doi voi Excel 543
15.1.10 Djnh di;Jng xuat khau doi voi HTML 544

15.2 Trh~n khai va phan phoi ((ng dlJng baa cao 546
15.2.1 Tong quan ve phan phoi ling dl,mg 547
15.2.2 Bat dau thu nghi~m 548
15.2.2.1 TemplateSetup Projects 548
15.2.2.2 TemplateWebSetup Projects " 549
15.2.2.j Template Merge Module Project 549
15.2.2.4 Template Setup Wizard 551
15.2.3 Cac doi h6i trien khai cd ban 551
15.2.3.1 H~ afeu himh 552
15.2.3.2 Phan cLIng 553
15.2.4 Trien khai cck ling dl,mg Windows 553
15.2.4.1 Ti;wmQt Setup project mai ." 553
15.2.4.2 Them Merge Modules 555
15.2.4.3 Them mlJCkhoa ban quyen 556
15.2.5 Trien khai cac ling dl,mg Web 559
15.2.5.1 Chuan bj Web Server 559
15.2.5.2 T?o Setup Project 559
15.2.5.3 ChQncac ket xufit dt/ an 560
15.2.5.4 Them cac Merge Module 560
15.2.5.5 Giai quyet LicenseKey 561
15.2.6 Trac nghi~mva trien khai setup cua bi;Jn 561