Crystal Reports & StarBuilder (Advanced) Session - 204

Richard Yost AMSI Professional Services

Items to Cover

• Versions • Linking • Formulas • Subtotaling/Running Totals • Subreports • Selection Parameters 2

Versions

• You MUST be on Crystal Reports Professional Version 10 to modify reports run through StarBuilder • You may be on any version of Crystal Reports Professional to run reports outside of StarBuilder 3

Linking

• Allows for the inclusion of multiple tables for a report • Tables linked by common key fields • Relationship established by the type of link 4

Linking

JOIN TYPES • Inner Join • Left Outer Join • Right Outer Join • Full Outer Join 5

Inner Join

Linking

6

Linking

7

Left Outer Join

Linking

8

Linking

LINK TYPES

Equal [=] link

– The result set from an Equal link includes all the records where the linked field value in both tables is an exact match.

Greater Than [>] link

– The result set from a Greater Than link includes all records in which the linked field value from the primary table is greater than the linked field value in the lookup table. 9

Linking

Greater Than Or Equal [>=] link

–The result set from a Greater Than Or Equal link includes all records in which the linked field value in the primary table is greater than or equal to the linked field value in the lookup table.

10

Linking

Less Than [<] link

–The result set from a Less Than link includes all records in which the linked field value in the primary table is less than the linked field value in the lookup table.

11

Linking

Less Than Or Equal [<=] link

–The result set from a Less Than Or Equal link includes all records in which the linked field value in the primary table is less than or equal to the linked field value in the lookup table. 12

Linking

•

Not Equal [!=] link

– The result set from a Not Equal link includes all records in which the linked field value in the primary table is not equal to the linked field value in the lookup table. This type of link can be used to find possible combinations of items when a table is joined to itself (a self-join).

13

Formulas

• Report Fields Report fields contain all database fields accessible for your report. They also contain any formulas or groups already created for the report.

• Functions prebuilt procedures that return values. They perform calculations such as average, sum, count, sin, trim, and uppercase.

• Operators Operators are the "action verbs" you use in formulas. They describe an operation or an action to take place between two or more values. – Examples of operators: add, subtract, less than, and greater than.

14

“Crystal” Clear?

Questions & Answers

15

Crystal Reports & StarBuilder (Advanced)

Richard Yost AMSI Professional Services

Thank You!