1 / 6

iStrategy: Building Custom Reports – Brick by Brick

iStrategy: Building Custom Reports – Brick by Brick. Wednesday September 22 nd 11:00 to 11:50 Room Oglethorpe D. Agenda. Report Building Methodology Request for “Burn Rate Report by Grant” Request for “YTD Expenditures by Fund, with PYTD Comparison” Question and Answer.

Download Presentation

iStrategy: Building Custom Reports – Brick by Brick

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. iStrategy: Building Custom Reports – Brick by Brick Wednesday September 22nd 11:00 to 11:50 Room Oglethorpe D

  2. Agenda • Report Building Methodology • Request for “Burn Rate Report by Grant” • Request for “YTD Expenditures by Fund, with PYTD Comparison” • Question and Answer

  3. Report Building Methodology • What is the primary data type (i.e. journals, vouchers, payroll detail etc.)? • Identify the existing report that most closely matches the desired report (organized by account, by fund etc.) • Approach Report by Rows, Columns, and Background Information • Define data elements in Rows and Columns • Define additional criteria in Background • Add detail to each item – i.e. which accounts, which budget periods?

  4. Modifying an Existing Report Step 1 – Choose report to use as template. Step 2 – Define Rows – Account, Step 2b -- Values for Account Step 3 – Define Columns – Change measures to Budget Period Step 3b – include all Budget Periods Step 4 – Set Background Criteria. Step 5 – Refine Report – hide columns, filter zero rows

  5. Report Building Methodology - cont • Refine report with Filters, Sorting etc. • Consider “Nesting” of Dimensions to improve presentation of data • Tips and Techniques • Click “Apply” after each change – build incrementally • Use Leaf Descendents when a report includes all detail values – reduces keying • Save final report as “My View” • Email “My View” reports to others with appropriate security

  6. Questions? Please send comments or questions to: Kurt.Collins@usg.edu Jason.Beitzel@usg.edu

More Related