BBDD
9MitAs18kl1rE6Cd+Vxqj8TAQy/dBXoBQ3ihXHHsanL10GkC1nz6jM9+Ze16aSqTjciNzWsBojV8TIxcdIDzu+B4kaBYBaNx8mTITHE96BeC7sPCVnxL7HxgJYl5aetG5FT5DV1qws17bKDMS4DoCsLIu8lfa7pFywBtfPuErW6NFneDXnFCrE9+fe1LxPPn8e6zzeYJuqx5bHkE8QQsXscWtS9rcPI1wFvMcMMRbY+BGmFg1WyZCQ==
BBDD
Datos Personales
Apellidos,System.String
C_Estado_civil,System.String
C_Gr_Nacionalidad,System.String
Clave_USERSSO,System.String
C_Nacionalidad,System.String
C_País_emisor_docum,System.String
C_País_nacim,System.String
C_Prov_nacimiento,System.String
C_Tipo_docum_identif,System.String
D_Estado_civil,System.String
D_Gr_Nacionalidad,System.String
D_Nacionalidad,System.String
D_País_emisor_docum,System.String
D_País_nacim,System.String
D_Perfil_menús,System.String
D_Perfil_procesos,System.String
D_Prov_nacimiento,System.String
D_Tipo_doc_identif,System.String
F_Estado_civil,System.DateTime
F_Fallecimiento,System.DateTime
F_F_Expediente,System.DateTime
F_I_Expediente,System.DateTime
F_Nacimiento,System.DateTime
Lugar_nacim,System.String
N_Afil_Seguridad_social,System.String
N_Documento_identif,System.String
N_Empleado,System.String
NEX,System.String
NIC,System.String
Nombre,System.String
Perfil_menús,System.String
Perfil_procesos,System.String
Sexo,System.String
Usuario_ADPnet,System.String
Datos Personales
DEMO.Datos Personales
FuenteDeDatos1
LITERAL,System.String
SACH2,System.String
COUNT_x0028__x002A__x0029_,System.Decimal
30
FuenteDeDatos1
BBDD
SELECT b.literal,a.SACH2, Count(*)
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, Mes
) b on (trunc(a.H1DDEB,'MONTH') <= b.lowerDay and (a.H1DFIN >= b.higherDay or a.H1DFIN is Null))
Where
{wherestr}
--Filtro para añadir todos los ETCMATS perteneciente a todos los NICS [NICS < ETCMATS]
AND
ETCMAT in
(
Select
ETCMAT
From
ETACIV
Where
NIC in
(
Select
x.NIC
From
ETACIV x, SADMIN s
WHERE
x.ETCMAT = s.ETCMAT
AND {wherestr}
)
)
Group By b.literal,a.SACH2
order by b.literal
,period_StartDate,period_StartDate,System.String,,False,False
,period_EndDate,period_EndDate,System.String,,False,False
,fecha_Situacion,fecha_Situacion,System.String,,False,False
,filtro_activos,filtro_activos,System.String,_x0022__x0020_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_SADSOR_x0020_IS_x0020_NULL_x0020_OR_x0020__x0028_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_NEXT_x0020_IS_x0020_NULL_x0020_OR_x0020_H1DFIN_x0020__x003D__x0020_SADSOR_x0029__x0009_AND_x0020__x0028_NEXT_x0020_IS_x0020_NULL_x0020_OR_x0020_H1DFIN_x0020__x003D__x0020_SADSOR_x0029__x0020_AND_x0020_H1DDEB_x0020__x003E__x003D__x0020_TO_DATE_x0028__x0027__x0022__x002B_period_StartDate_x002B__x0022__x0027__x0029__x0020_AND_x0020__x0028_H1DFIN_x0020__x003C__x003D__x0020_TO_DATE_x0028__x0027__x0022__x002B_period_EndDate_x002B__x0022__x0027__x0029__x0020_OR_x0020_H1DFIN_x0020_is_x0020_NULL_x0029__x0020__x0022__x000D__x000A_,False,True
,filtro_ausentes,filtro_ausentes,System.String,_x0022_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_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_SADSOR_x002C__x0027_MM_x0027__x0029__x0020__x003D__x0020_TO_CHAR_x0028_TO_DATE_x0028__x0027__x0022__x002B_fecha_Situacion_x002B__x0022__x0027__x0029__x002C__x0027_MM_x0027__x0029__x0029__x0020_AND_x0020__x0028_NEXT_x0020_IS_x0020_NOT_x0020_NULL_x0020_OR_x0020_H1DFIN_x0020__x003D__x0020_SADSOR_x0029__x0020_AND_x0020_H1DDEB_x0020__x003E__x003D__x0020_TO_DATE_x0028__x0027__x0022__x002B_period_StartDate_x002B__x0022__x0027__x0029__x0020_AND_x0020__x0028_H1DFIN_x0020__x003C__x003D__x0020_TO_DATE_x0028__x0027__x0022__x002B_period_EndDate_x002B__x0022__x0027__x0029__x0020_OR_x0020_H1DFIN_x0020_is_x0020_NULL_x0029__x0022_,False,True
,empleados_Situacion,empleados_Situacion,System.String,,False,False
,wherestr,wherestr,System.String,IIF_x0028_empleados_Situacion_x0020__x003D__x0020__x0022_Actives_x0022__x002C_filtro_activos_x002C_filtro_ausentes_x0029_,False,True
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
0.2,13.6,5.2,0.6
Arial,12,Bold
0,0,0,0
Text11
filtro
Black
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
0.2,14.4,18.6,12.4
True
Arial,12,Bold
0,0,0,0
Text10
{wherestr}
Black
,,,,WordWrap=True,A=0
Expression
Transparent
0,0.4,19,2.6
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
0.2,1.8,4.6,0.6
Arial,12,Bold
0,0,0,0
Text5
{ToUpperCase(empleados_Situacion)}
Black
Expression
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
4.8,1.8,4.6,0.6
Arial,12,Bold
0,0,0,0
Text1
{period_StartDate}
Black
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
9.4,1.8,4.6,0.6
Arial,12,Bold
0,0,0,0
Text3
{period_EndDate}
Black
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
14,1.8,4.6,0.6
Arial,12,Bold
0,0,0,0
Text7
{fecha_Situacion}
Black
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
0.2,0.8,4.6,0.6
Arial,12,Bold
0,0,0,0
Text6
Situacion
Black
Expression
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
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
[250:192:143]
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
[250:192:143]
14,0.8,4.6,0.6
Arial,12,Bold
0,0,0,0
Text8
a fecha...
Black
Expression
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
0.2,0,5.4,0.6
Arial,12,Bold
0,0,0,0
Text9
Filtros
Black
Expression
DataBand1
Transparent
3.4,3.8,12.2,9.2
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
0,1.3,2.2,0.4
Arial,8
951360b6716349d9baa54aa839dbc191
0,0,0,0
CrossTab1_RowTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0.45,2.2,0.4
Arial,8
7fcc9a80b56744dfb796ca1e403c517e
0,0,0,0
CrossTab1_Row1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
LITERAL
[105:105:105]
Row:CrossTab1_Row1
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
3.45,0.45,0.8,0.4
Arial,8
db24b6cc6e9b4f5692969596918c3c24
0,0,0,0
CrossTab1_ColTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0,2.2,0.4
Arial,8
8337d2ce93d144d59cb2c514cce255dc
0,0,0,0
CrossTab1_LeftTitle
AllowMove, AllowResize, AllowSelect, AllowChange
FuenteDeDatos1
[105:105:105]
LeftTitle
All;[155:155:155];1;Solid;False;4;Black
White
2.25,0,2,0.4
Arial,8
88073b1b3bb8437cb6f85440ad03eb2c
0,0,0,0
CrossTab1_RightTitle
AllowMove, AllowResize, AllowSelect, AllowChange
SACH2
[105:105:105]
RightTitle
LITERAL
All;[155:155:155];1;Solid;False;4;Black
White
0,0.9,2.2,0.4
{FuenteDeDatos1.LITERAL}
Arial,8
3c36d56801a04014b894dae252fff7b9
0,0,0,0
CrossTab1_Row1
AllowMove, AllowResize, AllowSelect, AllowChange
LITERAL
[105:105:105]
951360b6716349d9baa54aa839dbc191
{FuenteDeDatos1.LITERAL}
SACH2
All;[155:155:155];1;Solid;False;4;Black
White
2.25,0.45,1.2,0.4
{FuenteDeDatos1.SACH2}
Arial,8
e4113fc9224e49dab56f72aa792095d0
0,0,0,0
CrossTab1_Column1
AllowMove, AllowResize, AllowSelect, AllowChange
SACH2
[105:105:105]
db24b6cc6e9b4f5692969596918c3c24
{FuenteDeDatos1.SACH2}
COUNT(*)
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
2.25,0.9,1.2,0.4
Arial,8
104d56e51bff4f218587319d4000f6e3
0,0,0,0
CrossTab1_Sum1
AllowMove, AllowResize, AllowSelect, AllowChange
Average
0
Black
{FuenteDeDatos1.COUNT___}
FuenteDeDatos1
Center
CrossTab1
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/17/2015 1:15:50 PM
8/13/2015 8:36:31 AM
c:\enrique\store_reporting\DEVELOP\reports\Nuevo_Test_Variable.mrt
6e013e9c0bb64ecb9137deb7dbd80f6c
Nuevo_Test_Variable
Centimeters
2015.1.16
VB