Crystal ReportCrystal report - IntroductionBenefitsTypes of reports and data-sourcesScreenshot for creating reportScreenshot of data sourcesFeatures of reportsScreenshot for groupingFeatures of reports – Contd.Screenshot for conditional reportingSlide 11Screenshot of formula editorSlide 13Sample report screenshotReferencesCrystal ReportCrystal ReportCIS 764 – Presentation- Srunokshi Kaniyur Prema NeelakantanCIS 764 - Presentation on Crystal reportsCrystal report - IntroductionCrystal report - IntroductionCrystal report is a reporting tool which is used for generating reports from various datasourcesCrystal services - (1.0 – 3.0) Seagate (4.0 – 9.0)Business objects ( 10 – XI)CIS 764 - Presentation on Crystal reportsBenefitsBenefitsWide range of data sourcesMore flexible formattingEasy maintenance of reportsGood interactivity with usersInterface with .NET and J2EE applicationsCIS 764 - Presentation on Crystal reportsTypes of reports and data-Types of reports and data-sourcessources3 types of reports ◦Standard ◦Cross-Tab (like grid)◦Mail LabelTypes of Datasources◦Oracle, SQL Server, MySQL, Sybase, DB2, MS Access, MS Excel, Text files, XML files etc.CIS 764 - Presentation on Crystal reportsScreenshot for creating Screenshot for creating reportreportCIS 764 - Presentation on Crystal reportsScreenshot of data Screenshot of data sourcessourcesCIS 764 - Presentation on Crystal reportsFeatures of reportsFeatures of reportsRecord selection option◦To customize the displaying data (i.e by using either greater than, lesser than, starts with, like etc options)Sort, group and summarize data◦Sorting is used to arrange data in ascending or descending order◦To break data into meaningful groups (also perform sorting operations in group)◦To perform calculation at the end of the groupCIS 764 - Presentation on Crystal reportsScreenshot for groupingScreenshot for groupingCIS 764 - Presentation on Crystal reportsFeatures of reports – Features of reports – Contd.Contd.Conditional reporting◦Highlight important data based on the conditionCharting◦Enabling graphical representation of data (i.e. bar charts, pie charts, 3D charts etc)Exporting reports◦Export to MS Word, Excel, PDF, XML CIS 764 - Presentation on Crystal reportsScreenshot for conditional Screenshot for conditional reportingreportingCIS 764 - Presentation on Crystal reportsFeatures of reports – Features of reports – Contd.Contd.Parameter and formula editor◦Parameters adds power and flexibility to report◦Formulae are used for performing calculation and also for displaying custom fields◦Formulae makes use of built–in function (i.e. numeric functions, string functions, date functions etc.)CIS 764 - Presentation on Crystal reportsScreenshot of formula Screenshot of formula editoreditorCIS 764 - Presentation on Crystal reportsFeatures of reports – Features of reports – Contd.Contd.Subreport◦Sub reports are report within main report◦Two types of sub reports linked and unlinked subreport◦Linked subreport takes parameters from main report to display data◦On-demand subreport are displayed only when requestedCIS 764 - Presentation on Crystal reportsSample report screenshotSample report screenshotCIS 764 - Presentation on Crystal reportsReferencesReferencesAdvantage - http://www.scsi-usa.com/literature/crystalreports10.pdfOrigin - http://en.wikipedia.org/wiki/Crystal_reportsFormulae -http://www.kenhamady.com/formula.htmlQuestions????CIS 764 - Presentation on Crystal
View Full Document