Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Dynamic Columns Post Reply Post New Topic
Author Message
nevullag
Newbie
Newbie
Avatar

Joined: 13 Mar 2008
Location: Philippines
Online Status: Offline
Posts: 5
Quote nevullag Replybullet Topic: Dynamic Columns
    Posted: 13 Mar 2008 at 8:32pm
Can I have this kind of report?
The dates is from 2 parameters: Date From and Date to 
Rundate: 16/01/2008 09:01
Department 841 WFFC  
Section 110 LOG-WH  
Staff Group W3 PRODUCE PICK A
Staff ID Full Name Position Employment Type   01/01 02/01 03/01 04/01 05/01 06/01 07/01 Total Work Hrs Variance
1003 ### SD P Planned SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] OFF 43.75  
Actual SH0101 0500-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] OFF    
Confirmed SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] OFF 43.75 0.00
1004 ### SD P Planned OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 43.75  
Actual OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0]    
Confirmed OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 43.75 0.00
1005 ### SD P Planned 0600-1445[0] OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 43.75  
Actual 0500-1445[0] OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0]    
Confirmed 0600-1445[0] OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 0600-1445[0] 43.75 0.00
1006 ### SD P Planned 0600-1445[0] 0600-1445[0] OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 43.75  
Actual 0500-1445[0] 0500-1445[0] OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0]    
Confirmed 0600-1445[0] 0600-1445[0] OFF SH0101 0600-1445[0] 0600-1445[0] 0600-1445[0] 43.75 0.00
        Total Planned 17.50 17.50 17.50 17.50 17.50 17.50 17.50
Confirmed 17.50 17.50 17.50 17.50 17.50 17.50 17.50
Variance 0.00 0.00 0.00 0.00 0.00 0.00 0.00
bring back the bacon...
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 13 Mar 2008 at 9:31pm
this is a cross-tab report
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
nevullag
Newbie
Newbie
Avatar

Joined: 13 Mar 2008
Location: Philippines
Online Status: Offline
Posts: 5
Quote nevullag Replybullet Posted: 13 Mar 2008 at 10:03pm
Hello Sir,
 
Im a fan. Just wanted to know how to do this.
 
I have a table
 
EmpSked(staffID, Planned, Actual, Confirmed, WorkHours_Planned, WorkHours_Actual, WorkHours_confirmed)
 
I wanted to have a report that combines the schedules... just like on the one posted earlier.
 
Thanks and regards.


Edited by nevullag - 14 Mar 2008 at 12:50am
bring back the bacon...
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.