SSIS with Crystal Reports by oyr19245

VIEWS: 20 PAGES: 18

									SSIS with Crystal Reports
Crystal Reports Software

 Is a report writing tool for database tables.
 Connects to SSIS tables through an ODBC driver.
 Can link SSIS tables to create just about any report
 you can imagine.
 Because each county has the same SSIS table
 structure, Crystal Reports SSIS templates can easily
 be shared between counties.
Use it to quickly see what is happening

                                          Child Protection Assessments
                                                                           238
                             240                            227
                                                 197                                         198
                             200   185
     Number of Assessments




                                                            117            127
                             160
                                                 101                                         108
                             120
                                                            10              6
                                   173             7
                              80                                                              5

                                                  89        100            105
                              40                                                              85
                                    3
                                    9
                              0
                                   2000                     2002                             2004
                                                 2001                      2003



                                            Traditional   Facility   Alternativ e response
Track Trends Through the System
by analyzing up to the minute data

                                                         Child Protection Assessments
                         28                                                                 26
                                       25       25
                                                                                      24
                         24                  23 1                          23
                                                                         20 2 21
 Number of Assessments




                         20             19 18             18                                                                         18         19 18
                                     12                      13 18                                                                    1            1
                         16 15 16          2
                                              14
                                                     8             15 15    15       14                                                    15           15
                                  17     9       13    15 9           1 12     13                                                               11 8
                         12 7              9 6 1                   7         6    10                                                 10 6
                                                                      8              7                                                                     9
                                                  6                               2
                          8                                                    11
                                     12 10          13                            4
                                                             11
                          4 8 9            7  8 6         9      8 8 6 8 9           7                                               7
                                                                                                                                           9 8 9
                                   6                   6                                                                                                   6
                                                                                2 4
                          0
                              1/2003        3/2003   5/2003   7/2003   9/2003   11/2003    1/2004    3/2004    5/2004   7/2004   9/2004      11/2004   1/2005
                                  2/2003        4/2003   6/2003   8/2003    10/2003 12/2003      2/2004   4/2004   6/2004   8/2004       10/2004 12/2004



                                                               Facility               Traditional             Alternativ e response
Observe how one thing impacts another

                                                             Open Child Protection Assessments
                                           60
      Average Number of Open Assessments




                                           50


                                           40


                                           30
                                                                                                                  54 53
                                                                   51                                                             48 50
                                                             46 48    45
                                                                                                             49
                                                                                                                          45 44
                                           20                                                         41                                                    41
                                                  37 37
                                                                               30               31                                        30 28       32
                                                                                    25 27 27                                                    28
                                           10


                                            0
                                                                                                  3




                                                                                                                                                        4
                                                  3


                                                            3


                                                                    3


                                                                             3


                                                                                        3




                                                                                                             4


                                                                                                                      4


                                                                                                                              4


                                                                                                                                      4


                                                                                                                                              4
                                                                                                00




                                                                                                                                                      00
                                                00


                                                          00


                                                                  00


                                                                           00


                                                                                      00




                                                                                                           00


                                                                                                                    00


                                                                                                                            00


                                                                                                                                    00


                                                                                                                                            00
                                                                                              /2




                                                                                                                                                    /2
                                              2


                                                         2


                                                                   2


                                                                           2


                                                                                       2




                                                                                                         2


                                                                                                                     2


                                                                                                                             2


                                                                                                                                     2


                                                                                                                                             2
                                           1/


                                                      3/


                                                                5/


                                                                        7/


                                                                                    9/




                                                                                                      1/


                                                                                                                  3/


                                                                                                                          5/


                                                                                                                                  7/


                                                                                                                                          9/
                                                                                            11




                                                                                                                                                  11
                                                                                                Month/Year
And another

                                                           Open Child Protection Cases
                                   60
    Average Number of Open Cases




                                   50


                                   40


                                   30                60                                               57 59 58                                        58
                                          56 57           56
                                                                                      53                         53                       54
                                                                 51 49             50                                   51 51 53 51 51 52
                                                                       47 47 48 49
                                   20


                                   10


                                    0
                                                                                           3




                                                                                                                                                  4
                                          3


                                                    3


                                                                 3


                                                                         3


                                                                                 3




                                                                                                   4


                                                                                                             4


                                                                                                                        4


                                                                                                                                4


                                                                                                                                        4
                                                                                         00




                                                                                                                                                00
                                        00


                                                  00


                                                               00


                                                                       00


                                                                               00




                                                                                                 00


                                                                                                           00


                                                                                                                      00


                                                                                                                              00


                                                                                                                                      00
                                                                                       /2




                                                                                                                                              /2
                                      2


                                                 2


                                                             2


                                                                        2


                                                                                2




                                                                                                  2


                                                                                                            2


                                                                                                                    2


                                                                                                                               2


                                                                                                                                       2
                                   1/


                                              3/


                                                          5/


                                                                     7/


                                                                             9/




                                                                                               1/


                                                                                                         3/


                                                                                                                 5/


                                                                                                                            7/


                                                                                                                                    9/
                                                                                     11




                                                                                                                                            11
                                                                                         Month/Year
                             Average Number of Children




                         0
                              20
                                                                                     60
                                                                                          80
                                                                                               100
              1/
                 20




                                         40 83
              2/ 03
                 20
              3/ 03
                 20
              4/ 03
                 20




                                               85 84 85
              5/ 03
                 20
              6/ 03
                 20
                   0
              7/ 3
                 20
                                                                                                                                         And another



              8/ 03
                 20




                                                        78 76 78 76
              9/ 03
                 20


                                                                    72
             10 03
               /2
             11 003
               /2
             12 003
               /2
                  00
                                                                       79 76 83


              1/ 3
                 20
                                                                                87




              2/ 04
                 20




Month/Year
              3/ 04
                 20
              4/ 04
                 20
                                                                          92 95 91




              5/ 04
                 20
              6/ 04
                 20
                   0
                                                                87 87




              7/ 4
                 20
                                                  78




              8/ 04
                 20
                                                                                                     Children in Out-of-Home Placement




              9/ 04
                 20
             10 04
               /2
                                   71 70 68




             11 004
               /2
             12 004
               /2
                  00
                                            67 68




                     4
Count things
Study Things
Or Verify
Things
TCM Contacts
Use it for your Program Improvement
Plan for your Family Service Review

 Monthly Graphs: (Dan)
 Timeliness data from SSIS
 Repeat Maltreatment data
 Number of Children in Placement
 Reunification Outcomes from Charting and Analysis
 Foster Care Stability from SSIS
 Permanency Goals in SSIS from Crystal Reports
 Reunification Data
 Timely Adoptive Placements
 Backup Permanency Goals in SSIS from Crystal Reports
 Graph of children placed out-of-county from Crystal Reports
 Siblings placed apart from Crystal Reports
 Visitation with Parents and Siblings (need to figure out how to graph)
 Graph of Children placed with Relatives
 Graphs of Child Wellbeing Tools and Strengths and Needs Assessments ( need to develop graph)
 Open Cases with current plans.
 Contact Requirements for children (need to develop graph)
 Contact Requirements for parents ( need to develop graph)
 Placement cases with completed educational information (need to develop graph)
 Placement cases with completed physical health information (need to develop graph)
SSIS Crystal Reports Web Site

 Instructions
 How to get software and viewers
 Templates to download
 Crystal Reports version 10
 SSIS version 3.8
 http://webpages.charter.net/dkoziolek/web%
 20site/
My goal is to find some counties
willing to work together to develop a
Comprehensive Reporting System
  Share templates.
  Learn reporting tips and techniques from
  each other.
  Identify the information we would like to get.
  Divide responsibility for new templates.
  Create a complete and organized list of
  templates and make them all available on the
  web.
County Data Sharing Group

 Dakota and Olmsted Counties have
 templates they are willing to share as well.
 Metro counties plus Olmsted and St. Louis
 have been meeting regularly.
 The next meeting is February 3rd at 1:30 in
 room 330 of Dakota County’s Northern
 Service Center in West St. Paul.
Dan Koziolek

 Child and Family Manager
 Carver County Community Social Services
 dkoziolek@co.carver.mn.us
 (952)361-1640
 http://webpages.charter.net/dkoziolek/web%
 20site/

								
To top