1 / 16

Crystal Reports & StarBuilder (Advanced) Session - 204

Crystal Reports & StarBuilder (Advanced) Session - 204. Richard Yost AMSI Professional Services. Items to Cover. Versions Linking Formulas Subtotaling/Running Totals Subreports Selection Parameters. Versions.

salim
Download Presentation

Crystal Reports & StarBuilder (Advanced) Session - 204

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Crystal Reports & StarBuilder (Advanced)Session - 204 Richard Yost AMSI Professional Services

  2. Items to Cover • Versions • Linking • Formulas • Subtotaling/Running Totals • Subreports • Selection Parameters

  3. 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

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

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

  6. Linking Inner Join

  7. Linking

  8. Linking Left Outer Join

  9. 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.

  10. 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.

  11. 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.

  12. 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.

  13. 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).

  14. 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.

  15. “Crystal” Clear? Questions & Answers

  16. Crystal Reports & StarBuilder (Advanced) Richard Yost AMSI Professional Services Thank You!

More Related