ha pte r 1 9..,.,, (legacy)., ERP(Enterprise Resource Planning, ), CRM(Customer Relationship Management, ), IT (Information Technology system, ). 700. (Microsoft.NET, SAP, PeopleSoft )... [ 1.1].
Part I 9 [ 1.1],.., ( 9.0).. (key benefits) (content creation) 42
Chapter 1 9,.,,.,.,!,.,,, ( )..,,., 1992. Oracle, IBM DB2.,,,.,,,,.. (invoice),,, ([ 1.1] ),,.,,.,., 43
Part I 9,.,,, (data warehouse).,., (, )...,,.,., (, ). ( )..,.,,. ( ),,.?, 44
Chapter 1 9.,, (, XML, COM, Java ).,., Microsoft Office,..,.. Microsoft Office, Lotus Notes.., Windows SDK(Sof tware Development Kit, ) XML,,.,. ([ 1.2] ).. DOC - Microsoft Word XLS - Microsoft Excel 45
Part I 9 PDF - Adobe Acrobat Portable Document Format XML - Extensible Markup Language( ) HTML - Hypertext Markup Language( ) RTF - Rick Text Format CSV - Comma Seperated Values ( ) Text - ODBC - Microsoft Access, Microsoft SQL Server 2000 ODBC [ 1.2] Export( ) Microsoft Word Excel. 46
hapter 1 9 PDF. Exce l PDF,., (Microsoft Word, Excel, Acrobat Reader),.,., (.RPT). (navigation) (view),.,,,., (bar chart),.,.,., 6, 11,.., (,, ), (23, ).,.,.,. 47
Part I 9, Microsoft Exchange, Lotus Domino,., Windows ( / ). 23.,.,.,. [ 1.3]. 5,. [ 1.3].. 48
Chapter 1 9 9, (objectoriented),. XML(eXtensible Markup Language), ODBC(Open Database Connectivity), OLEDB(Obj ect Linking and Embedding f or Databases)., ( Windows) (PDA ).., (digital dashboard),,.,,,. 24, -.. RDBMS(relational database management systems, ),,, (Enterprise JavaBeans(EJB), COM ), OLAP(Online Analytical Processing). RDBMS,,, (synonyms),,.,. ( ),. 3,. 49
Part I 9...,,,,.,,... (Crystal Dictionary).,. ( ). (.DC5).,.,. ( ). Crystal Dictionary.,.,,, 50
Chapter 1 9., (content)., (content).? (content creation).,,,, ( ),.,,. 1. -. 2. ( ) -. 3. ( ) - Oracle, Microsoft Access. 4. ( ) -,,,, 5. - (stacked bar chart)..,.,., 5 1
Part I 9.., (, ).,.... 1,,..,, (margin),. (alert)...,, 5. 9 9 8.5.. [ 1.1],. 52
hapter 1 9. [ 1.1] 9.,,, SQL. 9. ( ),,, Office XP..,. (link, ). ( )..... 16, 254. 9. - WML, simple HTML 3.0, Pocket PC. HTML, chtml(compact HTML), IPAQ, Windows CE, WML, Palm OS., SQL,,,, 53
Part I 9,,,,, Microsoft Excel,,, (Gantt Gauge ), /, x., /,, Top N,, OLAP OLAP, OLAP,,.,. (boolean),,, Microsoft Word Excel. Excel, HTML, RTF PDF,., x/ y,,, (consolidation reporting) Java, COM,.NET Java, COM,.NET. Java, COM,.NET. 54
hapter 1 9,.,., (, ), IT.,..,,,,.,,. 9.. 1.? 2.? 3.? 55
Part I 9 1.,.,,..,, (, XML, COM, Java ).,. 2..,,, ( ),. 3., ( ).,,, SQL., 9. 56
Cha pte r 2 9.,.,.., 9.,,.,..,,
Part I 9,.,.,.,..,.,.,.,,.,., IT(Information Technology)., PC, PC., PC (Microsoft Word Excel,, Adobe Acrobat Reader ). ( ).,,,,., IT,.,. 58
hapter 2 9,.,.,. PC, PC. 64MB. RAM [ ] ( ). 300MB. Windows (, C:), [ ]. Windows RAM 11MB., (, ),,.. KB..,. Temp Windows. Temp. Temp ( ) [ ] [ ] ([ 2.1] ). 59
Part I 9,., (database connectivity). 3,. [ 2.1] Windows 2000 9, Crystal Decisions 9. 9. Standard Professional Developer Advanced 60
hapter 2 9 Advanced 9.. Advanced Deve lope r COM (data connectivity drive r). Advanced, (legacy),, (e nd use r) (inte ractive ly) ( HTML, DHTML, ).,. Developer Advanced -, Developer Advanced..,. Standard Professional. (Visual Basic.NET ) Developer Advanced. Deve lope r Advanced., Software Deve lope r Kit (SDK), SDK.,.NET COM SDK,.,. 9,. 6 1
Part I 9 Microsoft Windows 98(SE), ME, NT 4.0, 2000, XP( : 9 Windows 95 ) 32MB RAM(Windows NT 64MB). 64MB 60MB. 200MB, 400MB Windows C: 100MB CD-ROM 9,. - 217MB - 105MB 9. (Windows,, ). 9 CD Re lease Note.doc. 9. 62
Chapter 2 9 CD-ROM 9 CD, [ 2.2]. Install Crystal Reports 9. [ 2.3] (Crystal Report Setup Wizard). [ 2.2] CD-ROM 9 [ 2.3] 63
Part I 9 CD- ROM, CD- ROM setup.exe.,. Re lease Note, Technical Resources, Se rvices, Web Reporting, Crystal Decis ions Products, 9.. 9 (install-on-demanding)...,.,. (, ), [ 2.4] Select Installation Type( ).. 1. [Next]. 2. (Licence agreement), [Next]. 3. CD, [Next]., Select Installation Type. [Typical( )].,. 64
Chapter 2 9 (export) Microsoft Access SQL Server,.,. C:\Program Files\Crystal Decisions\Crystal Reports 9\. [ 2.4] (, )., 70MB. DLL( )., Start Installation( ), [Next].,.,. 9. 65
Part I 9 Reg istration Wizard( ).,.,, Crystal Decis ion,,,,., (custom installation type).,.,..., 9 Geographic Mapping( ) Custom Charting( )..,. 1. [Next]. 2. (Licence agreement), [Next]. 3. CD [Next]. Select Installation Type ([ 2.4] ), [Custom]. Custom( ),. [ 2.5], Select Features( ). 66
Chapter 2 9 [ 2.5] Select Features.,,.. Will be insta lled on loca l hard drive :. Entire feature will be installed on local hard drive :. Will be insta lled to run from CD :, CD. Entire feature will be installed to run from CD :, CD. Feature will be insta lled when required :. Entire feature will be unavailable :. [ 2.5], Sample Reports., PC, Sample Reports 67
Part I 9, Entire feature will be installed to run from CD., CD-ROM.. Features will be installed when required.,. CD-ROM. 1. Se lect Features,., 70MB (.DLL ). Se lect Features [Disk Cost],. [ 2.6] Disk Cost.. [ 2.6] Disk Cost. 68
Chapter 2 9 Se lect Features [Reset],.,., [Next] Start Installation( ). Start Installation [Next],.,.,.,....,, (OLAP, Online Analytical Processing)., Oracle SQL -. 3.,.,, (syste m Data Source Name syste m DSN). 69
Part I 9,.,., Crystal Reports 9 Tools.,.. Crystal Reports 9 Tools. Crystal Registration Wizard, Crystal Reports Licence, Crystal Dictionary, Crsytal SQL Designer. Crystal Reports Licence. Crystal Dictionary Crystal SQL Designer 9., 9 CD. Crystal Dictionary Crystal SQL Des ig ne r. ( Crystal Dictionary ), SQL. Crystal Dictionary SQL Des ig ne r.,... (report sections) (application toolbars) (application menus) 70
Chapter 2 9, 4,.,..., (Welcome to Crystal Reports) ([ 2.7] )., (Report Expert Wizard)., [As a Blank Report]. [ 2.7],., [Using the Reports Wizard], [OK]. Crystal Report Gallery. [As a Blank Report] [OK]., (Data Explorer) [Cancel]., (Field Explorer), [Close]. 71
Part I 9 (empty report template). [ 2.8],. ( ),. Report Header, Page Header, Details, Report Footer, Page Footer.,.. Report Header,,. Page Header,,. Group Header Group Footer (custom section). Details,. [ 2.8],. 72
Chapter 2 9,. (prese ntation),.., (database field), (text), (picture), (chart), (map). (formula), (sub-report) (additional object),. (Section Expert).,. (, ), [Section Expert]. [Section Expert]. Format Section Expert.,...,.., ( ) (underlay), (suppressing) (formatting),. Section Export. 73
Part I 9,... View ToolBars,. [ 2.9],. Standard - New, Open, Save, Print, Preview, Export, Copy, Cut, Past, Help. Formatting - Font, Font Size, Bold, Italics, Underline, Alignment, Currency, Percentage. Insert Tools -. Insert. Expert Tools - Database, Group, Select, Section, Formula Workshop, Highlighting Experts. [ 2.9] (Toolbars dialog). (ToolTips). (Toolbars dialog) [Show ToolTips].. 74
Chapter 2 9,.,. File( ) - File,,,,,,,.,,,,,. Edit( ) - Edit (undo), (redo), (cut), (copy), OLE (paste).,,,,. (OLE, Object Linking and Embedding) (OLE ),. OLE,,,. View( ) - View. Veiw (Design View) (Preview View), (,, (repository) ),,,, (ruler),, (grid),. Insert( ) - Insert (,, ),,,,, (picture),, 75
Part I 9.. Format( ) - Format.. (,,,, (drop shadow)),,., (,, ) (Highlighting Expert). Database( ) - Database (Database Expert).,, (alias)., SQL ODBC /, (browse), SQL.. Report( ) - Report ( ). (Select Expert), (Selection Formula)., (alert),,,,. Chart( ) - Chart..,,,,,, (numeric axis grid),, 76
Chapter 2 9.,, (report element),, (Map Navigator). Window( ) - Window,,. Help( ) - Help.,.,..,..,..,,,,.,.,. 77
Part I 9,. 1.? 2.? 3. Temp? 1. KB..,. 2. RAM 11MB. 3. Windows Temp, Temp., [ ] [ ]. File Open. (open dialog),, Inventory. C :\ Prog ra m File s\ Cryst a l Dec is io ns\ Crysta l Re po rts 9\ S a m ples\ En\ Re po rts\ Ge ne ra l Bus ines s 78
Chapter 2 9 Inventory, [ (Design)]..,,.,.. (Select Expert).,.,. 79