1 / 10

INTRO

INTRO. /. Education Solutions Development, Inc. UDR - User Directed Reporting. ANUA 2012 – New Orleans. SLIDES. UDR. Key things to remember. Grab data from most significant to least significant Watch your grouping Concatenate fields to save space Order of filters does make a difference

tasya
Download Presentation

INTRO

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. INTRO / Education Solutions Development, Inc. UDR - User Directed Reporting ANUA 2012 – New Orleans

  2. SLIDES UDR Key things to remember • Grab data from most significant to least significant • Watch your grouping • Concatenate fields to save space • Order of filters does make a difference • Filters can be made optional • Sometimes CSV files work better than straight export to Excel

  3. SLIDES UDR What maters most? • Determine what is driving the report and pick that data model first • Add other relevant information next

  4. SLIDES UDR Watch your grouping • Double click on data model name to create a model level group • Trick: to have multiple groupings, you must first create a divide: • dragging one field to the far left (which will put that field in it’s own group) • grab the main group header and drag to left of new field • double click on next model name • Groupings can be used to create secondary sorts with in the report

  5. SLIDES UDR Concatenate fields to save space • On reports where both code and description are wanted, concatenation will save report space and reduce report columns. • Example:

  6. SLIDES UDR Order of filters does make a difference • Drag and order filters to match the significance of the data in the report • Use the Define formula option to share parameters between data models

  7. SLIDES UDR Filters can be made optional • Select field to be filtered • Make it a prompted field (must be done first) • Choose the from – to filter option • Choose edit as formula • Change And to Or • Remove > sign on first half of formula • Remove field and <= from second half, leaving Parameter half • Add = EMPTY after Parameter on second half

  8. SLIDES UDR Sometimes CSV files work better • When report grouping is used – blank values on grouped lines • Data with numbers (ie. Student IDs, Cost Centers) have leading zeros • Formatting creates to many additional columns • Remember: • Open Excel first • Use open file option within Excel • Set delimiter to comma • Set data field type to text for non-numerical data fields

  9. SLIDES UDR Key things to remember • Grab data from most significant to least significant • Watch your grouping • Concatenate fields to save space • Order of filters does make a difference • Filters can be made optional • Sometimes CSV files work better than straight export to Excel

  10. SLIDES UDR Questions? Report Builder & Report Models in Microsoft SQL Server 2005 by Gerald Schinagl Steve Hanner shanner@esd-sys.com

More Related