- •Welcome to Seagate Crystal Reports
- •Welcome
- •Two kinds of Hands-On tutorials
- •Command, button, key, and control conventions
- •Using Seagate Crystal Reports documentation
- •Seagate Crystal Reports online Help features
- •If you need more help...
- •Installation Requirements
- •Installing Seagate Crystal Reports
- •Installing on a network workstation
- •Upgrading from a previous version
- •Quick Start
- •Subreports expand report usefulness
- •Query Designer adds ad-hoc querying capabilities
- •Parameter fields mean multi-purpose reports
- •Text objects give you text with intelligence
- •Preprinted-form reports easier than ever
- •More powerful formulas extend your capabilities
- •Web solution serves up variety of online reports
- •HTML exporting simplifies Web activities
- •New database support improves data access
- •Running totals made easy
- •Smart Navigation
- •Learning Seagate Crystal Reports
- •User’s Guide
- •Online Help
- •Books Online
- •Sample Reports
- •Glossary
- •Sample Data - CRAZE.MDB
- •Suggested learning paths
- •The application window
- •Menu bar
- •Standard toolbar
- •Supplementary toolbar
- •Format bar
- •Status bar
- •Shortcut menus
- •Cursors
- •Design Tab
- •Preview Tab
- •Other fundamentals
- •HANDS-ON (Report Design Environment)
- •How to add, delete, and move guidelines
- •How to move and position objects using guidelines
- •How to turn the grid on/off
- •How to zoom your report in and out
- •How to undo/redo activities
- •How to drill down on summarized data
- •HANDS-ON (Sections and Areas)
- •How to add, delete, move, and merge sections
- •How to split and resize sections
- •Basic report design
- •How to design a prototype
- •Concepts in reporting
- •Beyond basic reports
- •HANDS-ON (Report Creation and Design)
- •How to select data and begin creating a report
- •How to add and link multiple tables
- •How to insert database fields
- •How to insert special fields
- •How to insert a page n of N field
- •How to insert text objects
- •How to use a database field in a text object
- •How to insert a picture
- •How to select, move, and resize objects
- •How to hide parts of the report
- •HANDS-ON (Finishing Your Report)
- •How to insert page headers and footers
- •How to add a title page to your report
- •How to add summary information to your report
- •Printing considerations
- •Design solutions for printing/distributing
- •Report creation checklist for distributed reports
- •Updating printer drivers
- •Report distribution
- •HANDS-ON (Distributing Your Report)
- •How to export reports
- •How to fax a report
- •How to request reports from a web browser
- •How to specify parameter field values
- •How to log on to a database
- •How to view plain HTML reports
- •Overview
- •Getting started
- •Record Selection
- •Grouping and sorting
- •Completing the report
- •Introduction
- •Working with Arbor Essbase data
- •HANDS-ON (Reporting on OLAP data)
- •How to create a cross-tab with Essbase data
- •Using multiple sections in reports
- •HANDS-ON (Multiple Section Reports)
- •How to work with text objects
- •How to create a form letter using a text object
- •How to format objects conditionally
- •How to print conditional messages in form letters
- •How to alternate background colors for rows
- •How to eliminate blank lines
- •How to add blank lines conditionally
- •Formatting concepts
- •Absolute formatting
- •Types of formatting properties
- •Conditional formatting
- •HANDS-ON (Absolute Formatting)
- •How to add color, shading, and borders
- •How to add/edit lines and boxes
- •How to change margins
- •How to add/delete white space between rows
- •How to set page orientation and paper size
- •HANDS-ON (Conditional Formatting)
- •How to flag values that meet certain conditions
- •Record selection
- •Group selection
- •Record selection formula templates
- •HANDS-ON (Record and Group Selection)
- •How to create a record or group selection formula
- •How to use record/group selection templates
- •How to select the top or bottom N groups
- •Sorting, Grouping, and Totalling Overview
- •Creating custom groups
- •HANDS-ON (Sorting, Grouping, and Totalling)
- •How to do a single field sort
- •How to do a multiple field sort
- •How to group data
- •How to sort records within groups
- •How to summarize grouped data
- •How to subtotal grouped data
- •How to sort based on summarized group values
- •How to create multiple levels of subtotals
- •How to group data in intervals
- •How to calculate a percentage of the grand total
- •How to create group headers
- •What are formulas?
- •Other formula conventions
- •Formula syntax
- •How formulas are evaluated - Order of precedence
- •HANDS-ON (Formulas 101)
- •How to insert a formula in your report
- •How to delete formulas from your report
- •How to copy formulas from online Help
- •How to copy formulas from one report to another
- •How to create if-then-else formulas
- •How to format text with formulas
- •How to use variables in formulas
- •How to declare a variable
- •How to assign a value to a variable
- •How to conditionally assign values to variables
- •How to use an array in a formula
- •How to use a range in a formula
- •How to use semicolons in formulas
- •How to fine tune group selection formulas
- •How to fine tune record selection formulas
- •How to debug a formula
- •Introduction
- •HANDS-ON (Advanced Totalling)
- •How to maintain running totals in a list
- •How to subtotal running totals within groups
- •How to subtotal without grouping
- •How to subtotal true A to B, A to C reports
- •Parameter field objects overview
- •Multiple parameter fields
- •Parameter field considerations
- •HANDS-ON (Parameter Field Objects)
- •How to create a parameter field
- •How to use a parameter field in a formula
- •How to respond to parameter field prompts
- •How to use wildcards with parameter fields
- •How to set a report title using parameter fields
- •How to set sort order using parameter fields
- •Graphing Overview
- •Choosing a graph or chart type
- •Where to place your graph
- •Data you can graph on
- •Before you create your graph
- •HANDS-ON (Graphing)
- •How to graph on a summary or subtotal field
- •How to graph on a details field
- •How to graph on a formula field
- •How to graph on cross-tab summaries
- •How to edit graphs using PGEditor
- •How to use the underlay feature with graphs
- •OLE Objects Overview
- •Inserting OLE objects in your reports
- •Linked vs. Embedded Objects
- •The dynamic OLE menu commands
- •OLE and the Picture command
- •General OLE considerations
- •HANDS-ON (OLE Objects)
- •How OLE objects are represented in your report
- •How to use OLE - General Overview Tutorial
- •How to insert a graphic/picture as an OLE object
- •What are subreports?
- •Unlinked vs. linked subreports
- •How subreport linking works
- •HANDS-ON (Subreports)
- •How to insert a subreport
- •How to preview your subreport
- •How to combine unrelated reports using subreports
- •How to use subreports with unlinkable data
- •Cross-tab overview
- •Cross-tab components
- •HANDS-ON (Cross-Tab Objects)
- •How to create a cross-tab object
- •How to format a cross-tab
- •How to print cross-tabs that span multiple pages
- •The Crystal Query Designer
- •HANDS-ON (Queries)
- •How to create a new query
- •How to add tables to a query
- •How to link tables and specify a join type
- •How to add fields to a query
- •How to identify unique values in a query
- •How to summarize data with aggregate functions
- •How to sort records according to field values
- •How to specify records to be included in a query
- •How to select groups to be included in a query
- •How to create an SQL expression
- •How to create a query from another Crystal Query
- •How to select a query for a report
- •How to use a parameter field in a query
- •Dictionaries Overview
- •HANDS-ON (Dictionaries)
- •How to create a new dictionary
- •How to add a data file
- •How to open an SQL or ODBC data source
- •How to link multiple tables
- •How to select tables and fields for users
- •How to add/create formulas
- •How to move fields/field headings within the list
- •How to update the location of a database table
- •How to add a new field heading
- •How to add Help text
- •How to add a graphic
- •How to create sample data for users to browse
- •How to edit an existing dictionary
- •How to convert a 3.x or 4.x dictionary file
- •How to select a dictionary for a report
- •Databases Overview
- •For additional information
- •HANDS-ON (Working With Databases)
- •How to open Access queries through DAO
- •How to open Access queries through ODBC
- •How to open Access parameter queries
- •How to set up an ODBC data source
- •How to check settings for an ODBC data source
- •How to log on to an ODBC data source
- •How to add an ODBC database table to a report
- •How to log on to MS SQL Server via ODBC
- •How to log off an ODBC data source
- •How to set up an A to B, A to C link
- •How to edit an SQL query
- •How to use an ACT! database
- •How to open the NT Event Log
- •Introduction
- •Four types of data
- •Direct access database files
- •ODBC data sources
- •Crystal Query Designer files
- •Crystal Dictionary files
- •Multi-pass reporting
- •Product support
- •Web support
- •E-mail support
- •Fax support
- •Telephone support
- •Extended technical support policy
- •Product registration
- •Product return policy
- •Product replacement policy
- •Glossary
Quick Start
If you are an experienced Windows user who wants to get right into the program, follow these steps to set up a report for the first time.
NOTE: If you are not an experienced user, please refer to Learning
Seagate Crystal Reports, Page 35.
In Windows 3.1 and NT 3.51, start the program by doubleclicking the Seagate Crystal Reports icon in the Program Manager. In Windows 95 and NT 4.x, click Start and then select the program from the Seagate Crystal Reports program folder.
Click the NEW button on the standard toolbar. The Report Gallery appears.
!Select one of the eight Experts to build a report with the help of an Expert, click the Another Report button to use a template for building your report, or click the Custom button to build a custom report. If you click Custom, the Report Gallery expands, and you can then select a Report Type and Data Type for your custom report.
"If you choose Custom and select:
●Data File, the Choose Database File dialog box appears. Select the first database you want to activate for your report.
●SQL/ODBC, the Log On Server dialog box appears. Highlight the data source you want and then highlight the first table you want to use from the Choose SQL Table dialog box when it appears.
●Dictionary, the File Open dialog box appears. Highlight the dictionary you want to use for your report.
The Design Tab appears with Report Header, Page Header, Details, Page Footer, and Report Footer areas. You create your report by inserting and formatting items in each of these areas.
18 |
Seagate Crystal Reports User’s Guide |
NOTE: If you want to use additional database tables for your report and match them up on a record-by-record basis, click the LINK EXPERT button on the supplementary toolbar and then select
the table(s) and set up the links in the Visual Linking Expert when it appears. Search for Visual Linking Expert in Seagate Crystal
Reports online Help.
#Each of the default report areas contains a single section. If you want to add additional sections, click the SECTION EXPERT button on the standard toolbar and add the sections you want using the Section Expert.
Once you have added sections to an area, you can move, merge, and delete them in the Section Expert. See How to add, delete, move, and merge sections, Page 89.
$If you want to toggle the grid on and off, choose the OPTIONS command on the File menu and make your changes in the File Options dialog box when it appears. See How to turn the grid on/off, Page 86.
%If you are working with the grid off and you want to use snap-to guidelines for positioning objects, click the top or left ruler wherever you want guidelines to appear.
●Move a field to a guideline until it snaps to the guideline.
●Move the guideline arrow to move the guideline (and any objects that are snapped to it).
●Drag the guideline arrow away from the ruler to remove the guideline. See How to add, delete, and move guidelines, Page 82, and How to move and position objects using guidelines, Page 83.
&If the Insert Fields dialog box is not visible, click the INSERT FIELDS button on the standard toolbar. The Insert Fields dialog box appears with the Database Tab active. This dialog box displays a list of all of the fields in the active database table(s). To speed the entry of multiple fields, the box remains on screen until you click the Close button. You can move the dialog box to a new location or resize it if you wish. See How to insert database fields, Page 118.
'Select the field(s) you want to appear on the report. You can select and place them one at a time, or you can use the Shiftclick combination to select a number of contiguous fields or
Installation and Quick Start |
19 |
the Ctrl-click combination to select fields from the list at random. Drag and drop is also active. Place the fields in the Details section where you want them to appear.
If you place multiple fields, they will appear next to each other in the order they appear in the Insert Fields dialog box. The program marks the position of each field with a rectangular frame. The characters in the frame indicate whether the field is text (xxx...), number (555...), currency ($555...), date (12/31/99), time (00:00:00), dateTime (12/31/99 00:00:00), or Boolean (T/F).
NOTE: You can see the actual field names and field types by toggling the Show Field Names check box on in the File Options
dialog box (Layout Tab). Search for Configuring Seagate Crystal Reports in Seagate Crystal Reports online Help.
NOTE: The program automatically places field titles in the Page Header section unless you have toggled the Insert Detail Field
Titles check box off in the File Options dialog box (Layout Tab). Search for Configuring Seagate Crystal Reports in Seagate Crystal Reports online Help.
NOTE: If you add additional Details sections to your report, please note that field titles will only be placed in the Page Header section for fields in the Details A (the original) section of your report.
Once you have objects in place, you may want to adjust the report sections somewhat. You do this using the shortcut menu that appears when you right-click the shaded area to the left of the section ruler.
●If you want to expand the section to accommodate an additional line, choose the INSERT LINE command.
●If you want the program to automatically align the objects in the section horizontally, choose the ARRANGE LINES command.
●If you want to reduce the size of the section to eliminate unnecessary white space above and below objects, choose the FIT SECTION command. See How to add/delete white space between rows, Page 241.
20 |
Seagate Crystal Reports User’s Guide |
To create a report title, you must first enter the title in the Document Properties dialog box. Choose the SUMMARY INFO command from the File menu. Enter a title in the Title text box of the Document Properties dialog box. Click OK. Choose the REPORT TITLE command from the Insert|Special Fields menu. A rectangular placement frame appears when you move the cursor over your report. Click once in the Report Header (RH) section to place the report title. The report title field will contain the text that you typed in the Title text box of the Document Properties dialog box. See How to add a title page to your report, Page 131.
! To see how your results will print, click the PRINT PREVIEW button on the standard toolbar.
If you want to speed processing time while building your report, you can preview your report using only a small subset of the available data. To do this, choose the PREVIEW SAMPLE command from the File|Print menu. See Preview Tab, Page 72.
In either case, the program takes you to the Preview Tab. You can fine tune your report in the Preview Tab if you wish while seeing the results as actual report data. You can also close the Preview Tab and continue working on your report in the Design Tab.
" If you want to:
●change the placement or width of a field,
●format a field, or
●insert a subtotal or grand total,
click the field to select it. Handles appear on the top, bottom, and both sides of each selected field.
●To change the placement of the field(s), drag the field placement frame to its new position using the mouse.
●To change the width of the field, drag the right or left handle using your mouse.
●To format font, alignment within field, number, currency, date display, border, color, indentation, or to summarize the field, right-click the field. A shortcut menu appears listing various commands for formatting and summarizing the field.
Installation and Quick Start |
21 |
NOTE: If you want the formatting to apply only under certain conditions, click the Conditional Formula button next to the
formatting property in the Format Editor, and create a formula that defines those conditions. See Conditional formatting, Page 235.
NOTE: Many of the font and formatting options are available on the format bar. See Format bar, Page 59, for more information on
the options available.
# If you want to create a formula to make data calculations or comparisons, click the INSERT FIELDS button on the standard toolbar. When the Insert Fields dialog box appears, click the Formula Tab to activate it.
●Click the New button. The Formula Name dialog box appears. Enter a name for your formula and click OK. The Formula Editor appears.
●Enter the formula in the Formula Editor. Enter fields, operators, and functions by selecting them from their respective scroll lists or type them in. You can check your formula syntax via the Check button. When finished editing, click the Accept button to return to the Insert Fields dialog box. Click the Insert button to place the formula just like you would a database field. See Formulas 101, Page 321, and
Advanced Formulas, Page 345, or search for Functions and
Operators and Variables in Seagate Crystal Reports online Help.
$ To insert a subreport (a report within a report), click the INSERT SUBREPORT button on the supplementary toolbar and choose an existing report to import as a subreport or use the Create Report Expert to create a new subreport. See How to insert a subreport, Page 434.
●If you want the records in your subreport to match up with the records in your primary report, click the Link Tab of the Insert Subreport dialog box and specify the link in the Subreport Links dialog box when it appears. See How to link a subreport to the data in the primary report, Page 436.
% To insert a cross-tab object in your report, click the INSERT CROSS-TAB button on the supplementary toolbar and set up the cross-tab in the Cross-Tab dialog box when it appears. See
Cross-Tab Objects, Page 445.
22 |
Seagate Crystal Reports User’s Guide |
& To create a parameter field (a field that prompts you for a value whenever you retrieve data for your report), click the INSERT FIELDS button on the standard toolbar, then click the Parameter Tab in the Insert Fields dialog box when it appears. Click the New button to set up a parameter field. Once created, you can insert the parameter field in your report like a database field or select it from the Fields list in the Formula Editor.
●You can use parameter fields in your report (as title or label prompts), in selection formulas (as selection criteria prompts), and in formulas (for a variety of purposes including specifying sort fields). See Parameter Fields, Page 391.
' To add a graph or chart, click the INSERT CHART button on the standard toolbar. See Graphing, Page 405.
To insert a spreadsheet, picture, or other OLE object that you can edit from within Seagate Crystal Reports using the tools from the object’s native application, choose the OBJECT command from the Insert menu. See OLE, Page 415, and How to insert a graphic/picture as an OLE object, Page 426.
To change the record sort order, click the SORT ORDER button on the standard toolbar. The Record Sort Order dialog box appears. Select the field(s) you want to use for sorting the report data and the sort direction. See How to do a single field sort, Page 281.
If you want to limit your report to specific records (for example, the records of California customers that have year- to-date sales greater than $10,000), click the first field on which you want your selection to be based and click the SELECT RECORDS button on the standard toolbar. When the Select Expert appears, set up your record selection criteria. See
Record and Group Selection, Page 249.
!To print your report, click the PRINT button on the standard toolbar.
That’s it! It is that easy to build a report. To practice concepts introduced in this Quick Start, proceed to Tutorial - Customer List, Page 165.
Installation and Quick Start |
23 |
24 |
Seagate Crystal Reports User’s Guide |
2What’s New
What you will find in this chapter...
Sensational new interface gives you power and control, Page 26
Multiple section reports offer new reporting alternatives, Page 27
Subreports expand report usefulness, Page 27
Query Designer adds ad-hoc querying capabilities, Page 28
Conditional formatting adds new intelligence to reporting, Page 28
Parameter fields mean multi-purpose reports, Page 29
Text objects give you text with intelligence, Page 29
Preprinted-form reports easier than ever, Page 30
Enhanced cross-tab capabilities help identify trends, Page 30
More powerful formulas extend your capabilities, Page 31
In-place editing makes it easy to edit OLE objects, Page 31
Dragging objects between reports cuts creation time, Page 32
Web solution serves up variety of online reports, Page 32
HTML exporting simplifies Web activities, Page 33
New database support improves data access, Page 33
Running totals made easy, Page 34
Arbor Essbase support extends reporting capabilities to OLAP data sources, Page 34
Smart Navigation, Page 34
What’s New |
25 |
Sensational new interface gives you power and control
The report design environment offers greater flexibility than ever before.
●The Design and Preview Tabs are broken into areas and each area can contain multiple sections, each with different data and/or properties. See Identifying and working with areas and sections, Page 71.
●The Preview Tab now provides Smart Navigation technology in the new Group Tree view. Using the Group Tree, you can quickly drill down on group data to review the details of each group. See Preview Tab, Page 72.
●The Preview Tab now lets you expand and collapse report sections so you can review data with different levels of detail. See How to drill down on summarized data, Page 88.
●The new Section Expert enables you to insert, delete, move, merge, and format sections from one place. See Getting to Know Seagate Crystal Reports, Page 51.
●Vertical and horizontal guidelines make it easy to place and align objects with precision. See How to add, delete, and move guidelines, Page 82, and How to move and position objects using guidelines, Page 83.
●Multiple levels of undo and redo make it easy and safe to experiment, and they provide a fail-safe mechanism against inadvertent errors. See How to undo/redo activities, Page 87.
●The standard and supplementary toolbars and format bar can be moved, resized, and enlarged, enabling you to customize your environment for maximum efficiency. See
How to move and resize toolbars and the format bar, Page 80.
These are just a few of the new features in the design environment.
26 |
Seagate Crystal Reports User’s Guide |