Connection
9DrRC8YLY8FHRVXwxIhpXtFwtcjGX8t1/BXoheoNdA/4ZssJYkuyeWBNTfRqdKsL+S71z05Kmg1i
R/mlYXHnboh41wzdXXvNQxHN8U0BJXvl8lPCxlnTqGBcuexodG173FbbwsUIAYHCHqxAclzpXo1w
dy3v
Connection
SourceDeDonnées1
ContactId,Identifiant_x0020_du_x0020_contact,System.Int32
ContactCode,System.String
ContactType,System.Int32
ContactLinkId,System.Int32
SearchName,System.String
Name,System.String
LastName,System.String
FirstName,System.String
BirthName,System.String
Initial,System.String
SexId,System.Int32
AddressContact1Id,System.Int32
AddressContact2Id,System.Int32
AddressContact3Id,System.Int32
ProfTel,System.String
ProfGsm,System.String
ProfFax,System.String
ProfMail,System.String
PrivTel,System.String
PrivGsm,System.String
PrivFax,System.String
PrivMail,System.String
LanguageId,System.Int32
Photo,System.String
CustomerId,System.Int32
SupplierId,System.Int32
Employee,System.Boolean
Candidate,System.Boolean
Family,System.Boolean
30
SourceDeDonnées1
Connection
select * from BsContact
PjEmpAffect
BeginAffect,System.Nullable`1[System.DateTime]
EndAffect,System.Nullable`1[System.DateTime]
Name,System.String
ContactCode,System.String
ProjetCode,System.String
Tr_x0020_Projet,System.String
BeginPrj,System.Nullable`1[System.DateTime]
EndPrj,System.Nullable`1[System.DateTime]
PjGroupCode,System.String
Tr_x0020_GroupProjet,System.String
DayTypeId_x0020_Tr,System.String
DayTypeId_x0020_Cd,System.String
TypeAffectId_x0020_Cd,System.String
TypeAffectId_x0020_Tr,System.String
30
PjEmpAffect
Connection
SELECT [t0].[BeginAffect] AS [BeginAffect], [t0].[EndAffect] AS [EndAffect], [t2].[Name] AS [Name], [t2].[ContactCode] AS [ContactCode], [t3].[ProjetCode] AS [ProjetCode], [t4].[translationnl] AS [Tr Projet], [t3].[BeginPrj] AS [BeginPrj], [t3].[EndPrj] AS [EndPrj], [t5].[PjGroupCode] AS [PjGroupCode], [t6].[translationnl] AS [Tr GroupProjet], [t7].[translationnl] AS [DayTypeId Tr], [t8].[TableCode] AS [DayTypeId Cd], [t9].[TableCode] AS [TypeAffectId Cd], [t10].[translationnl] AS [TypeAffectId Tr] FROM [PjEmpAffect] AS [t0] LEFT OUTER JOIN [HrEmployee] AS [t1] ON [t0].[ContactId] = [t1].[ContactId] LEFT OUTER JOIN [BsContact] AS [t2] ON [t1].[ContactId] = [t2].[ContactId] LEFT OUTER JOIN [PjProjet] AS [t3] ON [t0].[ProjetId] = [t3].[ProjetId] LEFT OUTER JOIN [SysTranslation] AS [t4] ON [t3].[TranslationId] = [t4].[TranslationId] LEFT OUTER JOIN [PjGroup] AS [t5] ON [t3].[PjGroupId] = [t5].[PjGroupId] LEFT OUTER JOIN [SysTranslation] AS [t6] ON [t5].[TranslationId] = [t6].[TranslationId] LEFT OUTER JOIN [SysTranslation] AS [t7] ON [t0].[DayTypeId] = [t7].[TranslationId] LEFT OUTER JOIN [SysTableValue] AS [t8] ON [t0].[DayTypeId] = [t8].[TableValueId] LEFT OUTER JOIN [SysTableValue] AS [t9] ON [t0].[TypeAffectId] = [t9].[TableValueId] LEFT OUTER JOIN [SysTranslation] AS [t10] ON [t0].[TypeAffectId] = [t10].[TranslationId]
HrEmpTmCalendar
EmployeeCode,System.String
Name,System.String
DateCal,System.String
HourTypeCode,System.String
Tr_x0020_HourType,System.String
ProjetCode,System.String
Tr_x0020_Projet,System.String
PjGroupCode,System.String
Tr_x0020_GroupProjet_x0020_2,System.String
BeginPrj,System.String
EndPrj,System.String
ProjetCode_x0020_2,System.String
Tr_x0020_Projet_x0020_2,System.String
PjGroupCode_x0020_2,System.String
Tr_x0020_GroupProjet,System.String
BeginPrj_x0020_2,System.String
EndPrj_x0020_2,System.String
DayOfWeek_x0020_Cd,System.String
30
HrEmpTmCalendar
Connection
SELECT [t1].[EmployeeCode] AS [EmployeeCode], [t2].[Name] AS [Name], CONVERT(char(10), [t0].[DateCal], 103) AS [DateCal], [t3].[HourTypeCode] AS [HourTypeCode], [t4].[translationnl] AS [Tr HourType], [t5].[ProjetCode] AS [ProjetCode], [t6].[translationnl] AS [Tr Projet], [t7].[PjGroupCode] AS [PjGroupCode], [t10].[translationnl] AS [Tr GroupProjet 2], CONVERT(char(10), [t5].[BeginPrj], 103) AS [BeginPrj], CONVERT(char(10), [t5].[EndPrj], 103) AS [EndPrj], [t8].[ProjetCode] AS [ProjetCode 2], [t11].[translationnl] AS [Tr Projet 2], [t9].[PjGroupCode] AS [PjGroupCode 2], [t12].[translationnl] AS [Tr GroupProjet], CONVERT(char(10), [t8].[BeginPrj], 103) AS [BeginPrj 2], CONVERT(char(10), [t8].[EndPrj], 103) AS [EndPrj 2], [t13].[TableCode] AS [DayOfWeek Cd] FROM [HrEmpTmCalendar] AS [t0] LEFT OUTER JOIN [HrEmployee] AS [t1] ON [t0].[ContactId] = [t1].[ContactId] LEFT OUTER JOIN [BsContact] AS [t2] ON [t1].[ContactId] = [t2].[ContactId] LEFT OUTER JOIN [TmHourType] AS [t3] ON [t0].[HourTypeId] = [t3].[HourTypeId] LEFT OUTER JOIN [SysTranslation] AS [t4] ON [t3].[TranslationId] = [t4].[TranslationId] LEFT OUTER JOIN [PjProjet] AS [t5] ON [t0].[AMProjetId] = [t5].[ProjetId] LEFT OUTER JOIN [SysTranslation] AS [t6] ON [t5].[TranslationId] = [t6].[TranslationId] LEFT OUTER JOIN [PjGroup] AS [t7] ON [t5].[PjGroupId] = [t7].[PjGroupId] LEFT OUTER JOIN [PjProjet] AS [t8] ON [t0].[PMProjetId] = [t8].[ProjetId] LEFT OUTER JOIN [PjGroup] AS [t9] ON [t8].[PjGroupId] = [t9].[PjGroupId] LEFT OUTER JOIN [SysTranslation] AS [t10] ON [t9].[TranslationId] = [t10].[TranslationId] LEFT OUTER JOIN [SysTranslation] AS [t11] ON [t8].[TranslationId] = [t11].[TranslationId] LEFT OUTER JOIN [SysTranslation] AS [t12] ON [t7].[TranslationId] = [t12].[TranslationId] LEFT OUTER JOIN [SysTableValue] AS [t13] ON [t0].[DayOfWeek] = [t13].[TableValueId] WHERE ((([t0].[DateCal] >= CONVERT(DATETIME, '12/08/2013', 103)) AND ([t0].[DateCal] <= CONVERT(DATETIME, '16/08/2013', 103))) AND (([t5].[ProjetCode] IS NOT NULL) OR ([t8].[ProjetCode] IS NOT NULL)))
HrEmpTmCalendar_2
EmployeeCode,System.String
ProjetCode,System.String
ProjetCode_x0020_2,System.String
DateCal,System.String
HourTypeCode,System.String
30
HrEmpTmCalendar_2
Connection
SELECT [t1].[EmployeeCode] AS [EmployeeCode], [t2].[ProjetCode] AS [ProjetCode], [t3].[ProjetCode] AS [ProjetCode 2], CONVERT(char(10), [t0].[DateCal], 103) AS [DateCal], [t4].[HourTypeCode] AS [HourTypeCode] FROM [HrEmpTmCalendar] AS [t0] LEFT OUTER JOIN [HrEmployee] AS [t1] ON [t0].[ContactId] = [t1].[ContactId] LEFT OUTER JOIN [PjProjet] AS [t2] ON [t0].[AMProjetId] = [t2].[ProjetId] LEFT OUTER JOIN [PjProjet] AS [t3] ON [t0].[PMProjetId] = [t3].[ProjetId] LEFT OUTER JOIN [TmHourType] AS [t4] ON [t0].[HourTypeId] = [t4].[HourTypeId] WHERE ((([t2].[ProjetCode] IS NOT NULL) OR ([t3].[ProjetCode] IS NOT NULL)) AND ([t4].[HourTypeCode] IS NOT NULL))
,VarRuler,VarRuler,VarRuler,System.Nullable`1[System.Decimal],,False,False,False
,prevEmployeeCode,prevEmployeeCode,System.String,,False,False
,prevHourTypeCode,prevHourTypeCode,System.String,,False,False
EngineV2
None;Black;2;Solid;False;4;Black
White
Transparent
0,0.4,25.9,1
SteelBlue
0,0,26,1
Transparent
0,0,25.8,0.8
Arial,14,Bold
Center
0,0,0,0
Text1
RITMO - PLANNING
[255:255:255]
Panel1
PageHeaderBand1
Transparent
0,2.2,25.9,4.2
{
prevEmployeeCode = HrEmpTmCalendar.EmployeeCode;
prevHourTypeCode = HrEmpTmCalendar.HourTypeCode;
}
{
prevEmployeeCode = HrEmpTmCalendar.EmployeeCode;
prevHourTypeCode = HrEmpTmCalendar.HourTypeCode;
}
Transparent
0,0.2,25.8,3.8
All;[35:106:135];1;Solid;False;4;Black
SkyBlue
0,0.65,2.4,1.2
Arial,10
f8c8561a53752157207ce1e711f6945a
0,0,0,0
CrossTab1_Row1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
Project
[0:56:85]
Row:CrossTab1_Row1
All;[35:106:135];1;Solid;False;4;Black
SkyBlue
0,0,3.8,0.6
Arial,10
82dec0265ea360b5e906e1e711f61d7e
0,0,0,0
CrossTab1_LeftTitle
AllowMove, AllowResize, AllowSelect, AllowChange
RITMO
[0:56:85]
LeftTitle
All;[35:106:135];1;Solid;False;4;Black
SkyBlue
2.4,0.65,1.4,1.2
Arial,10
ff4cae4dcf116197577ee1eaa6fb95d0
0,0,0,0
CrossTab1_Row2_Title
AllowMove, AllowResize, AllowSelect, AllowChange
Kantoor
[0:56:85]
Row:CrossTab1_Row2
All;[35:106:135];1;Solid;False;4;Black
[185:255:255]
0,3.1,3.8,0.6
False
Arial,10
137d2c91291fce5578aee1ea97fb58ba
0,0,0,0
CrossTab1_RowTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[35:106:135];1;Solid;False;4;Black
[185:255:255]
2.4,2.5,1.4,0.6
False
Arial,10
bea170a48c4578712431e1eab9f3969c
0,0,0,0
CrossTab1_RowTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[35:106:135];1;Solid;False;4;Black
[185:255:255]
7.25,0.65,1,1.2
False
Arial,10
66eb61968704827e76fbe1e6cbc6d72b
0,0,0,0
CrossTab1_ColTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
6.25,1.25,1,0.6
False
Arial,10
fcb0df2a88650b5e4868e237a8a1a1a4
0,0,0,0
CrossTab1_ColTotal2
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
Tr GroupProjet
All;[35:106:135];1;Solid;False;4;Black
SkyBlue
0,1.9,2.4,1.2
{HrEmpTmCalendar.Tr_GroupProjet}
Arial,10
335c7bf64b234012ce8fe1ea97f99845
0,0,0,0
CrossTab1_Row1
AllowMove, AllowResize, AllowSelect, AllowChange
Tr GroupProjet
[0:56:85]
137d2c91291fce5578aee1ea97fb58ba
{HrEmpTmCalendar.Tr_GroupProjet}
Tr Projet
All;[35:106:135];1;Solid;False;4;Black
SkyBlue
2.4,1.9,1.4,0.6
{HrEmpTmCalendar.Tr_Projet}
Arial,10
2048437468a6edcc6496e1eab9f14741
0,0,0,0
CrossTab1_Row2
AllowMove, AllowResize, AllowSelect, AllowChange
Tr Projet
[0:56:85]
bea170a48c4578712431e1eab9f3969c
{HrEmpTmCalendar.Tr_Projet}
DateCal
All;[35:106:135];1;Solid;False;4;Black
SkyBlue
3.85,0.65,3.4,0.6
{HrEmpTmCalendar.DateCal}
Arial,10
4ec88f768b468e140f54e1e6cbc41d7d
0,0,0,0
CrossTab1_Column1
AllowMove, AllowResize, AllowSelect, AllowChange
DateCal
[0:56:85]
66eb61968704827e76fbe1e6cbc6d72b
{HrEmpTmCalendar.DateCal}
HourTypeCode
All;[155:155:155];1;Solid;False;4;Black
White
3.85,1.25,2.4,0.6
{HrEmpTmCalendar.HourTypeCode}
Arial,10
5cc2b9e1ee618cb180d1e237a89fd52d
0,0,0,0
CrossTab1_Column2
AllowMove, AllowResize, AllowSelect, AllowChange
HourTypeCode
[105:105:105]
fcb0df2a88650b5e4868e237a8a1a1a4
{HrEmpTmCalendar.HourTypeCode}
Name
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
3.85,1.9,2.4,0.6
Arial,10
117584238687ffefa2e4e68f2c77a73e
0,0,0,0
CrossTab1_Sum1
AllowMove, AllowResize, AllowSelect, AllowChange
None
0
Black
{HrEmpTmCalendar.Name}
All;[155:155:155];1;Solid;False;4;Black
White
3.85,0,4.4,0.6
Arial,10
d2384b2fd6964f6573afe6dbced4b4da
0,0,0,0
CrossTab1_RightTitle
AllowMove, AllowResize, AllowSelect, AllowChange
DateCal, HourTypeCode
[105:105:105]
RightTitle
_x007B_prevEmployeeCode_x0020__x003D__x003D__x0020_HrEmpTmCalendar_x002E_EmployeeCode_x0020__x0026__x0026__x0020_prevHourTypeCode_x0020__x0021__x003D__x0020__x0022__x0022__x007D_,Red,Transparent,Arial_x002C_10,False,False,,,None
HrEmpTmCalendar
True
CrossTab1
ASC
DateCal
ASC
EmployeeCode
DESC
HourTypeCode
True
HrEmpTmCalendar
DataBand1
48208124916745d0922ef6859fd5f8c6
1,1,1,1
Page1
Landscape
21.6
27.9
Arial,10
Black
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Nouveau
12/12/2013 02:15:25 PM
03/29/2009 06:03:03 PM
b01edffbba726d90ccc0e6f28f9b52e9
Report
Centimeters
2012.2.1400
CSharp