Mod 7_report_enhancement_part_1[1]

100 %
0 %
Information about Mod 7_report_enhancement_part_1[1]
Technology

Published on March 10, 2014

Author: wsmiller

Source: slideshare.net

Description

report enhancement 1

Report Enhancement Part 1 Module 7 Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 1

Variables • Are user defined. • Formula or calculation that has a name. • Are usually displayed in columns alongside corresponding data. • May contain functions. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 2

Variables help when: • A formula is used repeatedly in different blocks and on different report tabs within a document. • Creating an Object not found in the universe when its parts are. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 3

Functions • Functions help you define formulas. • Functions are tools used when defining formulas or variables. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 4

Functions (cont.) • Function examples: – – – – – SubStr(...) ToNumber(...) CurrentDate(...) IsNull(...) ToDate(...) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 5

Creating Variables Right click the new column to display the speedmenu. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 6

Creating Variables (cont) PP-SRS-GRD Type the name of your variable: PP-SRS-GRD Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 7

Creating Variables (cont) =<Pay Plan Perm>&“-”& <Ocuptnl Srs>& “-” & <Gr Civ Perm> Your new variable shows up like an object. Type the formula Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 8

Creating Variables (cont) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 9

Variable Examples = If IsNull(<Name Pers>) Then " <Name Pers> (VACANT)" Else Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 10

Variable Examples Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 11

Variable Examples Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 12

Variable Examples •Masking Data To Mask certain portions of data create a Variable and use a Sub-string Function For example: Mask all but the last 4 digits of SSNs Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 13

To Mask Data Need to create a Variable Then a Column SelectInsert a Column Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 14

To Mask Data (cont.) Right Click over new column to bring up speed menu. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 15

To Mask Data (cont.) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 16

To Mask Data (cont.) Insert =SubStr(<SSN> ,6,4) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 17

Add a comment

Related presentations