Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
muzzettemm
Posting Yak Master
212 Posts |
 Posted - 2010-10-21 : 23:59:59
|
| Hello I have an attenance calendar, they have the attendance for each day and each site one is Alpine the other San Diego. I need two calendar to show on one page, so if they calendar is for the Computer Certification Training (Alpine, San Diego) I need both to show on one page. How can I do that?? September 2010 Monthly Progress Report Computer Certificate Training CONTRACT PERIOD Start Date- 5/1/2010 End Date- 10/31/2010 Participants are currently working at the Beginner Level. Learning how to work with Home Row Keys, Typing and Microsoft Word 2007. The computer-training curriculum is based on three levels of completion 1) Entry Level 2) Intermediate Level 3) Advanced Level. At each level the TANF client will be provided with group and individual instructions and will advance upon satisfactory completion of each component of the level they are involved. Upon completion of the advance training level the TANF client will be tested and certified at the computer skill level for an entry position in the job market. Training Center: Alpine Total Clients Enrolled - 10 Monday Tuesday Wedneday Thursday Friday 9/1/2010 9/2/2010 9/3/2010 Clients Clients Clients Clients Clients 9/6/2010 9/7/2010 9/8/2010 9/9/2010 9/10/2010 Clients 0 Clients Clients Clients Clients 9/13/2010 9/14/2010 9/15/2010 9/16/2010 9/17/2010 Clients 1 Clients Clients Clients Clients 9/20/2010 9/21/2010 9/22/2010 9/23/2010 9/24/2010 Clients 1 Clients Clients Clients Clients 9/27/2010 9/28/2010 9/29/2010 9/30/2010 Clients 0 Clients Clients Clients Clients Total for the month 2 Computer Certificate Training CONTRACT PERIOD Start Date- 5/1/2010 End Date- 10/31/2010 Training Center: San Diego Total Clients Enrolled - 9 Monday Tuesday Wedneday Thursday Friday 9/1/2010 9/2/2010 9/3/2010 Clients Clients Clients Clients Clients 4 9/6/2010 9/7/2010 9/8/2010 9/9/2010 9/10/2010 Clients Clients Clients Clients Clients 5 9/13/2010 9/14/2010 9/15/2010 9/16/2010 9/17/2010 Clients Clients Clients Clients Clients 6 9/20/2010 9/21/2010 9/22/2010 9/23/2010 9/24/2010 Clients Clients Clients Clients Clients 0 9/27/2010 9/28/2010 9/29/2010 9/30/2010 Clients Clients Clients Clients Clients Total for the month 15 East County Tribal TANF Client Employement Training CONTRACT PERIOD Start Date- 8/1/2010 End Date- 10/31/2010 SCAIR is Providing the participating East County Tribal TANF clients with a comprehensive employment readiness training for their individual preparedness to meet the increased demand for employement as defined in our contractual obligation of our current contract with the SCTA RFP 0708 Welfare Reform Training of TANF reciepeints. Training Center: Alpine Total Clients Enrolled - 6 Monday Tuesday Wedneday Thursday Friday 9/1/2010 9/2/2010 9/3/2010 Clients Clients Clients 4 Clients 3 Clients 5 9/6/2010 9/7/2010 9/8/2010 9/9/2010 9/10/2010 Clients Clients 1 Clients 2 Clients 1 Clients 3 9/13/2010 9/14/2010 9/15/2010 9/16/2010 9/17/2010 Clients 2 Clients 2 Clients 2 Clients 1 Clients 3 9/20/2010 9/21/2010 9/22/2010 9/23/2010 9/24/2010 Clients 4 Clients 3 Clients 4 Clients 2 Clients 0 9/27/2010 9/28/2010 9/29/2010 9/30/2010 Clients 5 Clients 2 Clients 2 Clients 2 Clients Total for the month 53 Tribal TANF Client Job Readiness Part II CONTRACT PERIOD Start Date- 8/1/2010 End Date- 10/31/2010 Training Center: Alpine Total Clients Enrolled - 20 Monday Tuesday Wedneday Thursday Friday 9/1/2010 9/2/2010 9/3/2010 Clients Clients Clients 4 Clients 2 Clients 7 9/6/2010 9/7/2010 9/8/2010 9/9/2010 9/10/2010 Clients 0 Clients 5 Clients 5 Clients 6 Clients 7 9/13/2010 9/14/2010 9/15/2010 9/16/2010 9/17/2010 Clients 4 Clients 5 Clients 2 Clients 6 Clients 5 9/20/2010 9/21/2010 9/22/2010 9/23/2010 9/24/2010 Clients 3 Clients 4 Clients 2 Clients 6 Clients 0 9/27/2010 9/28/2010 9/29/2010 9/30/2010 Clients 2 Clients 5 Clients 1 Clients 1 Clients Total for the month 82 Tribal TANF Client Job Readiness Part II CONTRACT PERIOD Start Date- 8/1/2010 End Date- 10/31/2010 The SCAIR Career Advocate Case Workers are providing the participating East County Tribal TANF clients with comprehensive Employment Readiness core curriculum training that allow for their individual preparedness to meet the increased demand for employment as defined in the SCAIR contractual responsibility of the current contract with the SCTCA RFP 0708 Welfare Reform Training of TANF recipients for August 1, 2010 to October 31, 2010. Training Center: San Diego Total Clients Enrolled - 20 Monday Tuesday Wedneday Thursday Friday 9/1/2010 9/2/2010 9/3/2010 Clients Clients Clients 1 Clients 2 Clients 2 9/6/2010 9/7/2010 9/8/2010 9/9/2010 9/10/2010 Clients 0 Clients 3 Clients 2 Clients 2 Clients 2 9/13/2010 9/14/2010 9/15/2010 9/16/2010 9/17/2010 Clients 3 Clients 1 Clients 2 Clients 2 Clients 3 9/20/2010 9/21/2010 9/22/2010 9/23/2010 9/24/2010 Clients 8 Clients 2 Clients 3 Clients 4 Clients 0 9/27/2010 9/28/2010 9/29/2010 9/30/2010 Clients 1 Clients 1 Clients 1 Clients 1 Clients Total for the month 46 Tribal TANF Employement & Career Awareness Training Part II CONTRACT PERIOD Start Date- 9/1/2010 End Date- 10/31/2010 Training Center: Alpine Total Clients Enrolled - 20 Monday Tuesday Wedneday Thursday Friday 9/20/2010 9/21/2010 9/22/2010 9/23/2010 9/24/2010 Clients 8 Clients 6 Clients 6 Clients 6 Clients 0 9/27/2010 9/28/2010 9/29/2010 9/30/2010 Clients 5 Clients 4 Clients 4 Clients 3 Clients 9/1/2010 9/2/2010 9/3/2010 Clients Clients Clients 5 Clients 4 Clients 9/6/2010 9/7/2010 9/8/2010 9/9/2010 9/10/2010 Clients 9 Clients 5 Clients 3 Clients 7 Clients 4 9/13/2010 9/14/2010 9/15/2010 9/16/2010 9/17/2010 Clients 7 Clients 5 Clients 5 Clients 5 Clients 4 Total for the month 105 Tribal TANF Employement & Career Awareness Training Part II CONTRACT PERIOD Start Date- 9/1/2010 End Date- 10/31/2010 The Tribal TANF Employment and Career Awareness Training included input from the SCTCA San Diego Tribal TANF staff, the NU-FACES counselors and the SCAIR staff. The counseling services will be conducted on a regular daily schedule from 8:00am - 5:00pm Monday thru Friday. All aspects of employment preparedness will be addressed including parenting, specific job requirements, education requirements, self-esteem, and understanding of basic business concepts, personnel hygiene, dress, manners, speech, language, and interview skills. Methodology, using technology in job search and goal setting. Training Center: San Diego Total Clients Enrolled - 20 Monday Tuesday Wedneday Thursday Friday 9/1/2010 9/2/2010 9/3/2010 Clients Clients Clients 7 Clients 7 Clients 11 9/6/2010 9/7/2010 9/8/2010 9/9/2010 9/10/2010 Clients Clients 6 Clients 9 Clients 9 Clients 6 9/13/2010 9/14/2010 9/15/2010 9/16/2010 9/17/2010 Clients 11 Clients 7 Clients 10 Clients 9 Clients 8 9/20/2010 9/21/2010 9/22/2010 9/23/2010 9/24/2010 Clients 8 Clients 6 Clients 6 Clients 11 Clients 0 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-23 : 02:42:13
|
| you need to show it in same table? if not you can add separate datasets to return calendars and show them in same report?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
Two Calendars on One Page in Reporting Services