Mod 8_report_enhancement_part_2[1]

40 %
60 %
Information about Mod 8_report_enhancement_part_2[1]
Technology

Published on March 10, 2014

Author: wsmiller

Source: slideshare.net

Description

Report Enhancement 2

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

Alerters • Use alerters to draw attention to items of data in a block. Alerters can highlight data in two ways: • By changing the format of values • By displaying a comment next to or in place of certain results Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 2

Creating Alerters Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 3

Creating Alerters (cont) High Grades Type the name of your alerter: High Grades Type the Grade: 13 Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 4

Creating Alerters (cont) Be sure to select the Font tab. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 5

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

Text Alerters Similar to changing the font, you can change the text when certain conditions are met. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 7

Using Text Alerters Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 8

Using Text Alerters (cont) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 9

Grouping Data • You can create new variables by grouping the values of existing variables or objects. • Grouping Aggregates quantities Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 10

Creating a Data Grouping Annuitant Indicator returns four values: Re-employed Re-employed Annuitant-CS + Annuitant-FE Re-employed Retired Retired Enlisted + Officer Retired By grouping Re-employed annuitants into one group (Re-employed), and Retired Annuitants into another value (Retired), you can create a new variable. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 11

Creating a Data Grouping (cont) Hold down the CTL key while selecting Reempl Ann-FE. Re-employed Annuitant Type the name of your group: Re-employed Annuitant Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 12

Creating a Data Grouping (cont) Repeat the same process to combine Ret Enlisted and Ret Officer into ‘Retired’. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 13

Creating a Data Grouping (cont) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 14

Advanced Filters • Value not seen when filter icon is clicked. • Based on a formula rather than a LOV. • Required when LOV changes. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 15

Advanced Filters • Filters not seen when filter icon is clicked. • These filters are based on a formula rather than a LOV. • This helps if LOV changes. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 16

Advanced Filters (cont.) Example • QA check on anyone in LWOP as of current date. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 17

Add Advanced Filters Filters (cont.) Go to Format and select Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 18

Advanced Filters (cont.) • Select which object you want to filter. I.e. <Dt LWOP Expir> Select Hit OK OK Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 19

Advanced Filters (cont.) • Now Define the Filter =<Dt LWOP Expir> >= CurrentDate() Hit OK Define OK Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 20

Add a comment

Related presentations