CRUG

Crystal Reports User Group

Page Last Updated on 05/01/2012

Next Meeting: To Be Determined

Linda's & Mike's 11th Commandment

CRUG Mission Statement

CRUG Email Distribution List

Useful Links (feel free to suggest others)

• Ken Hamady
• Hammerman Associates
• Ablaze Group - George Peck
• Tek-Tips
• Experts Exchange
• CrystalKeen

Meeting Minutes & Demo Reports

• 02/24/2012
• Missing or Incorrect Dislocation Date (Les)

• 12/16/2011
• MOSES Reports Usage - Crystal Report (Les)
• Check for Certificate/Diploma - Crystal Report (Les)

• 09/16/2011
• WIA Youth - Not Low Income - Crystal Report (Les)
• MERLOT Recommendations to Revise MOSES Employer Services - Discussion Led by Linda
• Discussion Notes - Christina (PDF)
• MERLOT Recommendations (PDF)
• Employer Services Comparison (Excel Spreadsheet)
• Employer Services Usage Report (Crystal Report)

• 07/15/2011
• Handouts
• Removing ARRA References in MOSES
• Creating a New "Wired" Data Source
• Workshop Sign-Up Report and Full Workshops Report (Tom)
• PowerPoint Presentation of Demo
• Workshop Sign-Up Report (original version)
• Full Workshops Report
• Workshop Sign-Up Report (Linda's revision)

• 07/20/2007
  • Demos
    • Show as a percentage of
      • Demo 1
      • Demo 2
    • Finding Vet Reps for a Crystal Report
    • Using SQL Functions in Linking (Zip Code)
      • Notes on the Demos (PDF)
      • Service by Community
      • Generate Zip Code Query
      • Zip Codes (App Main) by Region
      • Regions by Zip Code
    • Featured Reports
      • Call List-No Svc in N Days
      • Mailing List-No Svc in N Days
      • Mailing Labels-No Svc in N Days
      • Call List-No Svc in N Days-with Admin Svcs (not yet available)

• 05/11/2007
  • Demos
    • Keep Details Together
    • LastFullWeek Date Range Function
    • Charts (uses Crystal Extreme database)
    • Deconstructing the OSCCAR
    • Featured Report - Program_Enr_and_Term 

• 03/09/2007
  • Demos
    • Notes on the demos (PDF)
    • Suppress if Duplicated vs. Suppress
    • Employment Retention Linking Template
    • Distinct Count using Null
    • Union Sample
    • Union SQL (MS Word doc)
    • Union of Job Services and Support Services
   
• 01/19/2007
  • Les Demos
    • Conditional Suppression of Fields
    • Use of Parentheses With 'Or Statement'
  • Linda Demos
    • Notes on Updating Pick Lists (PDF)

    • Dynamic Parameter Pick List

    • Static Parameter Pick List
    • Create a new pick list from an existing Crystal Report designed for this purpose
    • Create a new pick list from scratch
  • Crystal-Report-From Scratch
    • ETP - Co-enrolled or not?
     
• 10/20/2006 - Strategies to Improve Report Speed

• 08/08/2006
  • Linda Demos & Notes
    • Command Demo Notes
    • Maximum Date in Command
    • Using a Command as the Only Datasource
    • Local Office Static Parameter - Using a Field

    • Programs Static Parameter – Using a Command

    • Dynamic Cascading Parameter –Using Fields
    • Dynamic Cascading Parameter – Using a Command
  • Crystal-Report-From Scratch
    • OSCCAR New Employers - take 1 (Before and After Formulas in Group Select)
    • OSCCAR New Employers - take 2 (Incorrect Union of Employer Services and Job Orders tables)
    • OSCCAR New Employers - take 3 (Corrected Union of Employer Services and Job Orders tables)

• 05/09/2006
  • FY2006 Performance Measures Report Period Cohorts
  • CS_CMWIAQ_DATA Field Definitions (replaces Title I DMART Performance Tables)
  • FIPS Codes for WIBS
  • New Certificate Definition
  • MOSES 22.0 Changes (PowerPoint)
  • Linda Demos
    • Demo in Crystal version 11
    • Demo in Crystal version 8.5

• 03/21/2006
  • Performance Measures
  • Common Measures PowerPoint
  • Common Measures Chart
  • Supplemental Data Logic
  • Supplemental Data Chart
  • Les Demos
  • Eliminating Duplicates From Mailing Labels
  • Use of Functions: if/then, switch and select-case
  • Mike Demo
    • OSCCAR Entered Employment Verification


• 01/10/2006
• Linda Demo
  • Split and For Loop
• Mike Crystal-Report-From-Scratch
  • DTA Skills - using CS_ADHOC_PROGRAM_REPORT table
  • EAS - using CS_ADHOC_PROGRAM_REPORT table
• MOSES Database Training (01/11/2006)
• Limited English
• Enrolled in Trade, Not enrolled in Dislocated Worker
• Join PowerPoint

• 10/18/2005
• Linda Demos
  • Converting Memo fields to String/Text fields
  • Top N using a SQL expression
• Mike Crystal-Report-From-Scratch
  • WIA Youth Missing Eligibility Criteria Test Scores (Judy)
• MOSES Database Training (10/19/2005)
• New Employers by Account Rep


• 08/16/2005
• Linda Demos
  • MOSES Event Calendar Using Subreports (requires accompanying Access database for calendar framework)
  • Step-by-step instructions for creating the calendar (PDF))
• Mike Crystal-Report-From-Scratch
  • Trade Demo 
• Ken Merrill's Time Card Report (requires CR 9.0 and above)

• 06/14/2005
• Linda Demo
  • Display of Parameter Values in Report Heading Using Subreport
• Mike Crystal-Report-From-Scratch
  • Customer Residence and Town of Entered Employment (Ken)
  • Youth Offender/Substance Abuse Participants (John)

• 03/08/2005

• Les Demos

• Counting Job Seeker Services Like the OSCCAR (PDF)

• Title I Performance Review Report (Crystal Report)

• Linda Demos

• Notes on Unions to combine tables (PDF)
• Union of Regular and Archived tables (Crystal Report)
• Union of Support Services and Job Services tables (Crystal Report)
• Union of Employer Services and Job Orders tables (Crystal Report)

• 01/11/2005
  Demos

• Max Date - SQL
• Top N With Row Percents - SQL
• Crosstab Percents - SQL
• CCS Attendees With/Without Additional Service - Crystal-Report-From-Scratch (Warning! - see minutes for details!)



• 10/19/2004
  Subreport demos (Using subreports to eliminate dupes)

  • Demo 1

  • Demo 2

  • Demo 3

  
  

• 07/13/2004
  NAICS Cross-Tab demo (Credential reports are in Reports section below)

• Crystal Report Cross-Tab

• Cross-Tab Percentages - Excel




• 05/11/2004
  NAICS Sector Demos (Youth Diploma Rate report is in Reports section below)

• Select Case

• Linking

• Subreport 




• 03/09/2004 & Access Notes/Screen Shots (Mailing Labels)

• 01/13/2004 & Demo Report & Screen Shots (Mailing Labels)

• 11/18/2003 & Demo Report (Entered Employment - 3 Month Follow-Up Needed)

• 09/09/2003

• 07/15/2003

• 05/13/2003

• 02/11/2003

• 12/10/2002

• 10/08/2002

• 08/13/2002

• 06/04/2002

• 04/09/2002

• 12/11/2001

• 10/16/2001

• 08/14/2001

Reports

• Title I Performance Review Tool (revised 07/28/2008, LABRA)

• Adult Credential Rate (07/13/2004, LABRA)

• Older Youth Credential Rate (07/13/2004, LABRA)

• Older Youth Credential Rate With DMART Link (07/13/2004, LABRA)

• Younger Youth Diploma Rate Performance Measure (05/11/2004, LABRA)

• History of Reports in MOSES (PowerPoint, 01/08/2004)

• Old reports posted on CrystalClear.  For new reports, please refer to the other MOSES Workgroups web pages.

MOSES Tables, Columns, & Secret Codes

• Codes Not Found in Codes Tables (PDF, 05/23/2005)

• MOSES Tables & Columns (Refreshable Crystal Report, 05/23/2005)

• Data Dictionary (self-extracting zip file or Excel spreadsheet) (09/23/2002)

Crystal Reports Code Library (Les Abramowitz)

• Code Library, Formulas, etc.

AdHoc Reporting Tables Documentation (unfortunately not up-to-date)

• CS_ADHOC_TITLE1_REPORT

• CS_ADHOC_PROGRAM_REPORT

Crystal XI Driver

• http://ftp1.businessobjects.com/outgoing/products/downloadcenter/InstallODBCDriversDD42_v11.zip

Discount Software for Non-Profits

• TechSoup

Training and Employment Guidance Letters (TEGL)

• TEGL 17-05 (Common Measures Policy; Rescinds TEGL 7-99, TEGL 6-00, TEGL 6-00 change 1, TEGL 28-04)