how to maximize your use of the custom report builder
Download
Skip this Video
Download Presentation
How to Maximize Your Use of the Custom Report Builder

Loading in 2 Seconds...

play fullscreen
1 / 14

How to Maximize Your Use of the Custom Report Builder - PowerPoint PPT Presentation


  • 198 Views
  • Uploaded on

How to Maximize Your Use of the Custom Report Builder. 2013 User’s Conference Jason Baumgartner, IU Ned Hummel, IUPUI. Overview. How to G et to It Understanding Tables and Views Setting Your Criteria Managing Your Custom Reports Questions?/Suggestions?. Custom Report Builder.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'How to Maximize Your Use of the Custom Report Builder' - akira


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
how to maximize your use of the custom report builder

How to Maximize Your Use of the Custom Report Builder

2013 User’s Conference

Jason Baumgartner, IU

Ned Hummel, IUPUI

overview
Overview
  • How to Get to It
  • Understanding Tables and Views
  • Setting Your Criteria
  • Managing Your Custom Reports
  • Questions?/Suggestions?
slide4
Refresh, Open, Add, Delete, New Window

Standard “Tree” structure layout

Campus-> Report Group->Report Title

understanding tables and views1
Understanding Tables and Views
  • No longer shows everything & the kitchen sink
    • We’ve limited things down to tables and views in the system that make sense
      • Basically, any table or view that you normally see in the system or other reports the system uses (e.g., Open Doors)
      • In 3.0.2 – Help text about the table or view has been added – matches what you see when viewing that table on a person’s record
setting your criteria
Setting Your Criteria
  • Selectable fields to use in a report, and thus potentially removing duplicates
  • No longer requires all the fields in a selected table
  • Additional filter options, i.e., date ranges
  • No longer requires a person to be in every table selected (i.e., allows for left joins)
slide9
Use ‘%’ as a wildcard

Select fields to include

Specify parameters to filter on

slide10
Use < and > for dates

Specify date ranges

Multi-select

slide11
“Required” means that on this table/view

meeting all the parameters defined

“Not Required” means that if information exists then it includes those selected fields of data that meets the parameters as additional fields to the required population set

setting your criteria1
Setting Your Criteria
  • For each table or view marked as required, this will limit the resulting population to those who meet all the defined parameters on all those required tables/views.
managing your custom reports
Managing Your Custom Reports
  • Making sure you understand your data
  • Managing your custom reports so you don’t have to keep re-inventing the wheel
  • Dealing with “set” reports and changing parameters
ad