BBDD
9MitAs18kl1rE6Cd+Vxqj8TAQy/dBXoBQ3ihXHHsanL10GkC1nz6jM9+Ze16aSqTjciNzWsBojV8TIxcdIDzu+B4kaBYBaNx8mTITHE96BeC7sPCVnxL7HxgJYl5aetG5FT5DV1qws17bKDMS4DoCsLIu8lfa7pFywBtfPuErW6NFneDXnFCrE9+fe1LxPPn8e6zzeYJuqx5bHkE8QQsXscWtS9rcPI1wFvMcMMRbY+BGmFg1WyZCQ==
BBDD
Sexo_Periodo
LITERAL,System.String
SEXO,System.String
30
Sexo_Periodo
BBDD
SELECT b.literal, ETCSEX as Sexo
FROM SADMIN a
Inner Join
(
select
Min(Fecha) as lowerDay, Max(Fecha) as higherDay, Min(fecha)||' - ' || Max(Fecha) as literal
from DIM_TIEMPO
Where --Año = 2015 and
fecha <= SysDate
Group By Año
) b on (TO_CHAR(a.H1DDEB,'YYYY') = TO_CHAR(b.lowerDay,'YYYY'))
INNER JOIN ETACIV c on (a.etcmat = c.etcmat)
Where
{wherestr} AND
--Filtro para añadir todos los ETCMATS perteneciente a todos los NICS [NICS < ETCMATS]
a.ETCMAT in
(
Select
ETCMAT
From
ETACIV
Where
NIC in
(
Select
c.NIC
From
ETACIV c, SADMIN a
WHERE
c.ETCMAT = a.ETCMAT
AND {wherestr}
)
)
FuenteDeDatos1
LITERAL,System.String
MUJERES,System.Decimal
HOMBRES,System.Decimal
TOTAL,System.Decimal
30
Sexo_totales
BBDD
SELECT
b.literal,
Count(CASE WHEN ETCSEX = 'H' THEN 1 END) as Mujeres,
Count(CASE WHEN ETCSEX = 'V' THEN 1 END) as Hombres,
Count(1) as Total
FROM
SADMIN a
Inner Join
(
select
Min(Fecha) as lowerDay, Max(Fecha) as higherDay, Min(fecha)||' - ' || Max(Fecha) as literal
from DIM_TIEMPO
Where --Año = 2015 and
fecha <= SysDate
Group By Año
) b on (TO_CHAR(a.H1DDEB,'YYYY') = TO_CHAR(b.lowerDay,'YYYY'))
INNER JOIN ETACIV c on (a.etcmat = c.etcmat)
Where
{wherestr} AND
--Filtro para añadir todos los ETCMATS perteneciente a todos los NICS [NICS < ETCMATS]
a.ETCMAT in
(
Select
ETCMAT
From
ETACIV
Where
NIC in
(
Select
c.NIC
From
ETACIV c, SADMIN a
WHERE
c.ETCMAT = a.ETCMAT
AND {wherestr}
)
)
Group By Literal
Hombres_Mujeres
MUJERES,System.Decimal
HOMBRES,System.Decimal
30
Hombres_Mujeres
BBDD
SELECT
Count(CASE WHEN ETCSEX = 'H' THEN 1 END) as Mujeres,
Count(CASE WHEN ETCSEX = 'V' THEN 1 END) as Hombres
FROM
SADMIN a
Inner Join
(
select
Min(Fecha) as lowerDay, Max(Fecha) as higherDay, Min(fecha)||' - ' || Max(Fecha) as literal
from DIM_TIEMPO
Where --Año = 2015 and
fecha <= SysDate
Group By Año
) b on (TO_CHAR(a.H1DDEB,'YYYY') = TO_CHAR(b.lowerDay,'YYYY'))
INNER JOIN ETACIV c on (a.etcmat = c.etcmat)
Where
{wherestr} AND
--Filtro para añadir todos los ETCMATS perteneciente a todos los NICS [NICS < ETCMATS]
a.ETCMAT in
(
Select
ETCMAT
From
ETACIV
Where
NIC in
(
Select
c.NIC
From
ETACIV c, SADMIN a
WHERE
c.ETCMAT = a.ETCMAT
AND {wherestr}
)
)
,period_StartDate,period_StartDate,System.String,_x0030_1_x002F_01_x002F_2010,False,False
,period_EndDate,period_EndDate,System.String,_x0033_1_x002F_12_x002F_2015,False,False
,fecha_Situacion,fecha_Situacion,System.String,_x0030_1_x002F_08_x002F_2015,False,False
,filtro_activos,filtro_activos,System.String,_x0022__x0020_a.SADESO_x0020__x003C__x003D__x0020_TO_DATE_x0020__x0028__x0027__x0022__x002B_fecha_Situacion_x002B__x0022__x0027__x002C__x0020__x0020__x0027_DD_x002F_MM_x002F_YYYY_x0027__x0029__x0020_AND_x0020__x0028_a.SADSOR_x0020_IS_x0020_NULL_x0020_OR_x0020__x0028_a.SADSOR_x0020__x003E__x003D__x0020_TO_DATE_x0020__x0028__x0027__x0022__x002B_fecha_Situacion_x002B__x0022__x0027__x002C__x0020__x0027_DD_x002F_MM_x002F_YYYY_x0027__x0029__x0029__x0029__x0020_AND_x0020__x0028_a.NEXT_x0020_IS_x0020_NULL_x0020_OR_x0020_a.H1DFIN_x0020__x003D__x0020_a.SADSOR_x0029__x0009_AND_x0020__x0028_a.NEXT_x0020_IS_x0020_NULL_x0020_OR_x0020_a.H1DFIN_x0020__x003D__x0020_a.SADSOR_x0029__x0020_AND_x0020_a.H1DDEB_x0020__x003E__x003D__x0020_TO_DATE_x0028__x0027__x0022__x002B_period_StartDate_x002B__x0022__x0027__x0029__x0020_AND_x0020__x0028_a.H1DFIN_x0020__x003C__x003D__x0020_TO_DATE_x0028__x0027__x0022__x002B_period_EndDate_x002B__x0022__x0027__x0029__x0020_OR_x0020_a.H1DFIN_x0020_is_x0020_NULL_x0029__x0020__x0022__x000D__x000A_,True,True
,filtro_ausentes,filtro_ausentes,System.String,_x0022_a.SADESO_x0020__x003C__x003D__x0020_TO_DATE_x0020__x0028__x0027__x0022__x002B_fecha_Situacion_x002B__x0022__x0027__x002C__x0020__x0027_DD_x002F_MM_x002F_YYYY_x0027__x0029__x0020_AND_x0020__x0028_TO_CHAR_x0028_a.SADSOR_x002C__x0027_YYYY_x0027__x0029__x0020__x003D__x0020_TO_CHAR_x0028_TO_DATE_x0028__x0027__x0022__x002B_fecha_Situacion_x002B__x0022__x0027__x0029__x002C__x0027_YYYY_x0027__x0029__x0029__x0020_AND_x0020__x0028_TO_CHAR_x0028_a.SADSOR_x002C__x0027_MM_x0027__x0029__x0020__x003D__x0020_TO_CHAR_x0028_a.TO_DATE_x0028__x0027__x0022__x002B_fecha_Situacion_x002B__x0022__x0027__x0029__x002C__x0027_MM_x0027__x0029__x0029__x0020_AND_x0020__x0028_a.NEXT_x0020_IS_x0020_NOT_x0020_NULL_x0020_OR_x0020_a.H1DFIN_x0020__x003D__x0020_a.SADSOR_x0029__x0020_AND_x0020_a.H1DDEB_x0020__x003E__x003D__x0020_TO_DATE_x0028__x0027__x0022__x002B_period_StartDate_x002B__x0022__x0027__x0029__x0020_AND_x0020__x0028_a.H1DFIN_x0020__x003C__x003D__x0020_TO_DATE_x0028__x0027__x0022__x002B_period_EndDate_x002B__x0022__x0027__x0029__x0020_OR_x0020_a.H1DFIN_x0020_is_x0020_NULL_x0029__x0022_,True,True
,empleados_Situacion,empleados_Situacion,System.String,Actives,False,False
,wherestr,wherestr,System.String,IIF_x0028_empleados_Situacion_x0020__x003D__x0022_Actives_x0022__x002C_filtro_activos_x002C_filtro_ausentes_x0029_,True,True
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
171, 172, 173
[255:255:255]
100, 105, 105, 105
100, 105, 105, 105
Silver
Gainsboro
False
100, 105, 105, 105
100, 105, 105, 105
[10:155:155:155]
[10:155:155:155]
140, 140, 140
Tahoma,8
140, 140, 140
Bottom
<Color>140, 140, 140</Color>
<Font>Tahoma,12,Bold</Font>
140, 140, 140
Tahoma,8
140, 140, 140
<Color>140, 140, 140</Color>
<Font>Tahoma,12,Bold</Font>
140, 140, 140
Tahoma,8
140, 140, 140
<Color>140, 140, 140</Color>
<Direction>BottomToTop</Direction>
<Font>Tahoma,12,Bold</Font>
140, 140, 140
Tahoma,8
Left
140, 140, 140
<Color>140, 140, 140</Color>
<Direction>TopToBottom</Direction>
<Font>Tahoma,12,Bold</Font>
[255:255:255]
0.6,13.8,8.6,7
Sexo_totales
False
Chart1
{Sexo_totales.LITERAL}
255, 255, 255
[112:173:71]
Firebrick
{Sexo_totales.LITERAL}
140, 140, 140
[255:255:255]
Arial,7
90, 90, 90
8, 6
-
0
FromSeries
Mujeres
Black
True
Sexo_totales.MUJERES
{Sexo_totales.LITERAL}
255, 255, 255
[68:114:196]
Firebrick
140, 140, 140
[255:255:255]
Arial,7
90, 90, 90
8, 6
-
0
Hombres
Black
True
Sexo_totales.HOMBRES
Sexo_totales.LITERAL
255, 192, 0
Firebrick
105, 42, 0
[255:242:50]
155, 92, 0
[255:255:100]
140, 140, 140
[255:255:255]
Arial,7
90, 90, 90
8, 6
-
0
Total
Black
True
Sexo_totales.TOTAL
140, 140, 140
[255:255:255]
Arial,7
90, 90, 90
8, 6
-
0
ASC
LITERAL
Tahoma,8
105, 105, 105
140, 140, 140
<Brush>[140:140:140]</Brush>
<Font>Tahoma,12,Bold</Font>
171, 172, 173
[255:255:255]
[255:255:255]
9.8,13.8,8.6,7
Hombres_Mujeres
False
Chart2
Mujeres
255, 255, 255
[112:173:71]
140, 140, 140
[255:255:255]
Arial,7
90, 90, 90
8, 6
-
0
Mujeres
Hombres_Mujeres.MUJERES
Hombres
255, 255, 255
[68:114:196]
140, 140, 140
[255:255:255]
Arial,7
90, 90, 90
8, 6
-
0
FromSeries
Hombres
Hombres_Mujeres.HOMBRES
8, 6
-
0
Tahoma,8
105, 105, 105
140, 140, 140
<Brush>[140:140:140]</Brush>
<Font>Tahoma,12,Bold</Font>
Transparent
0,0.4,19,1.8
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
0,0,19,1.8
Arial,36,Bold
Center
0,0,0,0
Text10
Igualdad de genero
Black
Expression
Center
ReportTitleBand1
Transparent
0,3,19,2.6
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
0,1.4,4.8,1
Arial,12,Bold
0,0,0,0
Text5
{ToUpperCase(empleados_Situacion)}
Black
Expression
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
4.8,1.4,4.6,1
Arial,12,Bold
0,0,0,0
Text1
{period_StartDate}
Black
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
9.4,1.4,4.6,1
Arial,12,Bold
0,0,0,0
Text3
{period_EndDate}
Black
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
14,1.4,5,1
Arial,12,Bold
0,0,0,0
Text7
{fecha_Situacion}
Black
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
0,0.8,4.8,0.6
Arial,12,Bold
0,0,0,0
Text6
Situacion
Black
Expression
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
4.8,0.8,4.6,0.6
Arial,12,Bold
0,0,0,0
Text2
period_1
Black
Expression
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
9.4,0.8,4.6,0.6
Arial,12,Bold
0,0,0,0
Text4
period_2
Black
Expression
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
14,0.8,5,0.6
Arial,12,Bold
0,0,0,0
Text8
a fecha...
Black
Expression
None;[79:129:189];1;Solid;False;4;Black
[146:208:80]
0,0,19,0.8
Arial,12,Bold
0,0,0,0
Text9
Filtros
Black
Expression
DataBand1
Transparent
4.4,6,11,5.4
All;[39:0:0];1;Solid;False;4;Black
[189:50:50]
0,2.5,5.6,1.6
Rojo ADP
Arial,18,Regular,Point,False,0
89c4adc755604394abcdb685655e5329
0,0,0,0
CrossTab2_RowTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Silver
All;[39:0:0];1;Solid;False;4;Black
DarkRed
0,0.05,5.6,0.8
Rojo ADP
Arial,18,Regular,Point,False,0
ad8c3290c2064eaabcf3ed533e3f0314
0,0,0,0
CrossTab2_Row1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
Periodo
Silver
Row:CrossTab2_Row1
All;[39:0:0];1;Solid;False;4;Black
DarkRed
2.8,0.9,2.8,0.8
Rojo ADP
Arial,18,Regular,Point,False,0
e34bbd0174204efb93c6f9cf5433cc7e
0,0,0,0
CrossTab2_SumHeader1
AllowMove, AllowResize, AllowSelect, AllowChange
Mujeres
Silver
All;[39:0:0];1;Solid;False;4;Black
DarkRed
2.8,1.7,2.8,0.8
Rojo ADP
Arial,18,Regular,Point,False,0
ebe158c2001041fd9bf1fd457c2a57b0
0,0,0,0
CrossTab2_SumHeader2
AllowMove, AllowResize, AllowSelect, AllowChange
Hombres
Silver
All;[39:0:0];1;Solid;False;4;Black
DarkRed
5.65,0.05,3.4,0.8
Rojo ADP
Arial,18,Regular,Point,False,0
f78b2b1061bc48899d040ab7c9277419
0,0,0,0
CrossTab2_SummaryTitle
AllowMove, AllowResize, AllowSelect, AllowChange
Empleados
Silver
SummaryTitle
LITERAL
All;[39:0:0];1;Solid;False;4;Black
DarkRed
0,0.9,2.8,1.6
Rojo ADP
{Sexo_totales.LITERAL}
Arial,18,Regular,Point,False,0
b43bb1000f10464baa4c7252c3dbdcd1
0,0,0,0
CrossTab2_Row1
AllowMove, AllowResize, AllowSelect, AllowChange
LITERAL
Silver
89c4adc755604394abcdb685655e5329
{Sexo_totales.LITERAL}
MUJERES
All;[39:0:0];1;Solid;False;4;Black
[239:100:100]
5.65,0.9,3.4,0.8
Rojo ADP
Arial,18,Regular,Point,False,0
91cf06d051e34a95b17a8a8ddf398d89
False
0,0,0,0
CrossTab2_Sum1
AllowMove, AllowResize, AllowSelect, AllowChange
0
Silver
{Sexo_totales.MUJERES}
HOMBRES
All;[39:0:0];1;Solid;False;4;Black
[239:100:100]
5.65,1.7,3.4,0.8
Rojo ADP
Arial,18,Regular,Point,False,0
3f0f0877027e4b85a4ac3813293a2c59
False
0,0,0,0
CrossTab2_Sum2
AllowMove, AllowResize, AllowSelect, AllowChange
0
Silver
{Sexo_totales.HOMBRES}
-1
Sexo_totales
Center
CrossTab2
933c563b3c57493c9617b53904208166
1,1,1,1
Page1
29.7
21
Arial,100
[50:0:0:0]
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Nuevo_Test_Variable
8/19/2015 2:55:09 PM
8/13/2015 8:36:31 AM
C:\enrique\store_reporting\DEVELOP\reports\nuevoo\Sexo.mrt
6c36d5efae454d4d8754978cc60b36dd
Nuevo_Test_Variable
Centimeters
2015.1.16
VB
DarkRed
Rojo ADP
White
Estilo1