
Build master-detail and cross-tab Crystal Reports, drill down with sub-reports, and drive displays with formulas, groupings, and parameter-driven selections for regional, country, and product totals.
Link tables in Crystal Reports to build a master-detail report and display client, product, quantity, and price. Group data by country and include a chart in report header for preview.
Create a formula to compute total paid by multiplying quantity by price in a master-detail report, then summarize by region and country to support charts.
Explore totals, running totals, and group by criteria in Crystal Reports to summarize sales by region and country, with reset and on-change options.
Create totals and groups in crystal reports, define group by criteria with thresholds, and add user-controlled sorts and charts to tailor country and region views.
Learn to use the select expert to filter data with defined criteria, pass parameters for dynamic, country- and region-specific reports, and display drill-down data with an advanced chart.
Build cross-tab reports in Crystal Reports with charts, formulas, and a parameter to drill down by country, showing client name, product, quantity, price, and total paid.
Learn how to build subreports to create a master-detail drill-down in Crystal Reports, showing a client's sales by region with country, product, quantity, price, and totals.
Create and link a subreport within a master Crystal Reports layout to display quantities sold per product for each client. Build regional and country groupings and calculate totals paid.
Summary:
Crystal Reports is owned by SAP. But it can be used to generate reports
for any kind of database and Enterprise Resource Planning.
This course is intended for all of those developers, programmers and
system analysts that provides information and Business Intelligence for
the strategic Management.
Master Detail reports to represent the clients and products sold to
each one. Cross tab are for Business Intelligence. Drill down data
from general information to specific data can be done by Sub-Reports.
Index
Lesson One:
a) Link Tables of Database
b) Master Detail Report
c) Calculations Formula for Master Detail Report.
d) Group Fields to display data.
e) Charts of Group Fields.
Lesson Two:
a) Total in fields.
b) Group by criteria.
c) Sort Control for user.
Lesson Three:
a) Select Expert to display data with defined criteria.
b) Advance Chart to display drill-down data.
c) Pass user parameters to the Select Expert.
Lesson Four:
a) Cross tab reports.
b) Cross tab charts.
c) Include Formula Field in a cross tab report.
d) User defined parameter to drill down details on Cross Tab Reports.
Lesson Five:
a) Sub Reports
b) Linked Sub Reports to print drill down details in a
Master Detail relationship.