CRUG

Crystal Reports User Group

Page Last Updated on 09/18/2008

CRUG Mission Statement

Meeting Minutes & Demo Reports

• Next Meeting: Friday, November 21, 2008 @ ETR Marlborough

• 09/05/2008
  • Demos (Linda)
    • Linda's demo notes
    • New Monthly Calendar Report
    • Using the cs_adhoc_applicant_cycles table
      • Adhoc Applicant Cycles Table
      • Adhoc Applicant Cycles Table with an Event
      • Return After Event Report
      • Return After CCS Report
  • Crystal-Report-From-Scratch (BYORFS)
    • Youth Literacy/Numeracy Pre and Post Testing
    • Report to create Educational Functioning Levels (EFLs)

• 06/13/2008
  • Notes on Linda's Group Select demo (Word)
    • Group Select Demo Report
  • Enrollment Checker Report (customers in Applicant Programs table but not in Adhoc Title 1 table)
  • Report Critique
    • Purpose of Tom's report (Powerpoint)
    • Description of Tom's report (Word)
    • Tom's original report
    • Linda's version

• 04/04/2008 (Career Source, Cambridge - no minutes)
  • AM - A Look Inside the New Crystal Reports
  • PM - Crystal-Report-From-Scratch (BYORFS)
    • Staff Support Services

• 01/11/2008
  • Notes on Linda's demos
  • Syntax for SQL Expressions in CR 9+
  • Using a Count for Grouping
  • Left joins with Selection Criteria in the From Clause
    • Usual Method - Support Services
    • Using a Command - Support Services
    • Usual Method - Combining Support & Job Services
    • Using a Command - Combining Support & Job Services
  • Fiscal Year Formula (Mike)
  • Crystal-Report-From-Scratch (BYORFS)

    • Recently Separated Veterans Report for Bristol and New Bedford

• 11/16/2007
  • Demos
  • Exporting to Excel from Crystal
  • Notes on the Demo (MS Word)
  • "Before" report with export problems
  • "After" report exporting correctly
  • Career Center Specific Report for Export
  • Using Plan Numbers in a report
  • Notes on the Demo (MS Word)
  • One Program
  • Multiple Programs
  • Using Access as a data source for a Crystal Report
  • Demo Notes and Screenshots (MS Word)
  • Using a Crystal SQL Query as a data source
  • Crystal SQL Designer Download Link
  • Crystal-Report-From-Scratch
  (BYORFS)
  • Enrolled in WIA Title I - No Case Manager (Jeff Aho)
  
  
• 09/21/2007
  • FY2008 Performance Cohort Chart
  • Demos
    • When July 10^th and July 11^th are the same date…or at least they act like it (Mike)
      • Demo 1 - original problem
      • Demo 2 - use of TRUNC function in SQL Expression
      • Demo 3 - use of Command
      • Demo 4 - using a CR 8.5 report saved as CR XI
    • An alternate look at the "Null Problem" (Mike)
  • Featured Reports
  • Crystal Report variations on the OSCCAR
    • OSCCAR - Crystal Reports View (Mike)
    • OSCCAR Reports - by Fiscal Year (Linda)
    • OSCCAR Reports - Comparison of Fiscal Years by Month (Linda)
    • OSCCAR Reports - Multiple Locations (Linda)
  • Job History Reports
    • Industry and Occupation of Previous Job (Linda)
    • Job History Occupations (Linda)
    • Job History Occupations - Mailing Labels (Linda)
    • Job History Occupations - Mailing List (Linda)
  • Job Openings Reports
  • Job Openings by Industry by Occupation-C (Linda)

• 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 (MS Word)
      • 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 (MS Word doc)
    • 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 (MS Word doc)

    • 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 (Word doc))
• 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 (Word Document)

• Title I Performance Review Report (Crystal Report)

• Linda Demos

• Notes on Unions to combine tables (Word Document)
• 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 (Word Document, 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)