crystal reports training
TRANSCRIPT
-
8/16/2019 Crystal Reports Training
1/25
Copyright © 2012 NTT DATA, Inc.
1 Introduction
2 Accessing Data Sources
3 Creating Reports
4 Foratting !ptions
" Su#Report
$ Crossta#
% Charts
& '(acing Data on the Report
) *anipu(ating Data
Agenda
10 Distri#uting Reports
-
8/16/2019 Crystal Reports Training
2/25
Copyright © 2012 NTT DATA, Inc. 2
Introduction
+ In this training, you will be subjected through various features and functionalities ofCrystal Reports 2008 as a Standard reporting ool!
+ Crystal Reports is designed to wor" with your database to help you analy#e and inter pret i$portant infor$ation! Crystal Reports $a"es it easy to create si$ple reports, and, it also has the co$prehensive tools you need to produce co$ple% or speciali#ed r eports!
+ Crystal Reports is a Standard ransaction reporting tool first developed by Seagate,which later spun off to for$ a co$pany called Crystal &ecisions! hen it was ta"enover by SA' (usiness )bjects!
Welcome to the training on Crystal Reports 2008
-
8/16/2019 Crystal Reports Training
3/25
Copyright © 2012 NTT DATA, Inc.
Course )bjectives
+ he objective of Crystal Reports training is to provide the audience with co$plete in
for$ation * hands+on e%perience on Crystal Reports as an industry Standard ransa
ction reporting ool!
+ It is not li$iting but also to enable the participant to e%ecute the case studies which s
erves as a virtual live projects!
+ At the end of the training, each participant will be able to ta"e up develop$ent of re
ports using Crystal Reports!
-
8/16/2019 Crystal Reports Training
4/25
Copyright © 2012 NTT DATA, Inc. -
arget Audience
+ Anyone with good e%posure to R&(S and is aware of &-. and )/' concepts a
re ideally suited to undergo this training!
+ 'rior wor" e%perience in any of the other reporting tools will be an advantage but
) $andatory!
-
8/16/2019 Crystal Reports Training
5/25
Copyright © 2012 NTT DATA, Inc. &
Accessing &ata Sources
+ 'ri$ary goal of reporting is to access data and produce reports
+ a"es this process very easy, less ti$e+consu$ing and powerful
+ Can access data stored in any co$$on1unco$$on for$at
+ ypes of data
! &irect access &( files
2! )&(C data sources3! )/4&(
5! (usiness 6iews
7! /
9! SA' (-
:! SA' 4R'
8! )/A' Cubes
;! Spreadsheet
0! Applications
-
8/16/2019 Crystal Reports Training
6/25Copyright © 2012 NTT DATA, Inc. )
Accessing &ata Sources Contd <
+ (usiness 6iews
+ Created using (usiness 6iew anager
+ =le%ible and reliable $ulti+tier syste$, helps in integrating data fro$ disparate sources
+ Reduces differences in data resolution, coverage and structure
+ Consists of
+ &ata Connections+ &yna$ic &ata Connections
+ &ata =oundations
+ (usiness 4le$ents
+ Security could be applied to individual objects
-
8/16/2019 Crystal Reports Training
7/25Copyright © 2012 NTT DATA, Inc. "
Report &esign Concepts
+ &eciding the content of the report
+ &eveloping a prototype
-
8/16/2019 Crystal Reports Training
8/25
-
8/16/2019 Crystal Reports Training
9/25Copyright © 2012 NTT DATA, Inc. %
Creating Report Contd <
o create a new Report clic" on the green highlighted icon ! >ou will get the Standard Report
Creation -i#ard, >ou can use this if you want but usually we do not use this! So Clic" on
=inish!
-
8/16/2019 Crystal Reports Training
10/25Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
Yo will get the following win!ow. This is the Pre"iew win!ow where yo can "iew the !ata. Clic# on the $esign Tab as highlighte! below.
-
8/16/2019 Crystal Reports Training
11/25Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
%ow $elete the Print $ate an! Page %mber special Fiel!s which were atomatically a!!e! to the Report.
-
8/16/2019 Crystal Reports Training
12/25Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
&o to File 'ntic# the Sa"e $ata with Report becase this will increase the si(e of theReport.
-
8/16/2019 Crystal Reports Training
13/25Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
Sa"e the Report by gi"ing a %ame in the re)ire! path in yor local system.
-
8/16/2019 Crystal Reports Training
14/25Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
To a!! a $atabase Connection. &o to $atabase $atabase *+pert.
-
8/16/2019 Crystal Reports Training
15/25Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
The following win!ow appears. Clic# on the Create %ew Connection
-
8/16/2019 Crystal Reports Training
16/25
Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
The win!ow shows the !ifferent connections that are a"ailable. Choose the appropriate one. ,ere we will choose the -* $/$- for connecting to S3 ser"er.
i d
-
8/16/2019 Crystal Reports Training
17/25
Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
,ere select 4icrosoft -* $/ Pro"i!er for S3 Ser"er an! clic# Finish
C i R C d
-
8/16/2019 Crystal Reports Training
18/25
Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
%ow pro"i!e the login !etails of the $atabase that yo nee! to connect to. Clic# on Finish.
C i R C d
-
8/16/2019 Crystal Reports Training
19/25
Copyright © 2012 NTT DATA, Inc. 1
Creating Report Contd <
%ow yo can select the tables or "iews or Store! Proce!res from the $atabase. ,ere we select the Store! Proce!re so that it is faster.
C ti R t C td
-
8/16/2019 Crystal Reports Training
20/25
Copyright © 2012 NTT DATA, Inc. 2
Creating Report Contd <
Select the Store! Proce!re Sample5SP5Crystal5Report an! clic# on the arrowhighlighte! to select an! clic# on -6.
C ti R t C td
-
8/16/2019 Crystal Reports Training
21/25
Copyright © 2012 NTT DATA, Inc. 2
Creating Report Contd <
Yo can "iew the fiel!s in the Fiel! *+plorer
Creating Report Contd
-
8/16/2019 Crystal Reports Training
22/25
Copyright © 2012 NTT DATA, Inc. 2
Creating Report Contd <
%ow !rag an! !rop the fiel!s into the $etails Section.
Creating Report Contd
-
8/16/2019 Crystal Reports Training
23/25
Copyright © 2012 NTT DATA, Inc. 2
Creating Report Contd <
Yo can a!! remaining fiel!s similarly. To change the name of the hea!ers yocan !oble clic# on the hea!er an! change the names. The report will loo# li#ethis now
Creating Report Contd
-
8/16/2019 Crystal Reports Training
24/25
Copyright © 2012 NTT DATA, Inc. 2
Creating Report Contd <
Yo can a!! remaining fiel!s similarly. To change the name of the hea!ers yocan !oble clic# on the hea!er an! change the names. The report will loo# li#ethis now
Creating Report Contd
-
8/16/2019 Crystal Reports Training
25/25
Copyright © 2012 NTT DATA, Inc. 2
Creating Report Contd <
Yo can rn the report by clic#ing on the Pre"iew tab or by F7