Oracle
9MitAs18kl1rE6Cd+Vxqj8TAQy/dBXoBQ3ihXHHsanL10GkC1nz6jM9+Ze16aSqTjciNzWsBojV8TIxcdIDzu+B4kaBYBaNx8mTITHE96BeC7sPCVnxL7HxgJYl5aetG5FT5DV1qws17bKDMS4DoCsLIu8lfa7pFywBtfPuErW6NFneDXnFCrE9+fe1LxPPn8e6zzeYJuqx5bHkE8QQsXscWtS9rcPI1wFvMcMMRbY+BGmFg1WyZCQ==
Oracle
Datos Personales
ETCNOM,System.String
ETCSFA,System.String
ETCGNA,System.String
USERSSO,System.String
ETCNAT,System.String
SPECC101,System.String
ETCPNA,System.String
ETCPSN,System.String
SPECC100,System.String
ETLSFA,System.String
ETLGNA,System.String
ETLNAT,System.String
SPECL101,System.String
ETLPNA,System.String
DMENU,System.String
DPROC,System.String
E2LIB00,System.String
SPECL100,System.String
ETDSFA,System.DateTime
ETCDDE,System.DateTime
FFNEX,System.DateTime
FINEX,System.DateTime
ETCDNA,System.DateTime
ETLNAI,System.String
SPECL104,System.String
SPECL103,System.String
ETCMAT,System.String
NEX,System.String
NIC,System.String
ETCPRE,System.String
CMENU,System.String
CPROC,System.String
ETCSEX,System.String
USERADPNET,System.String
30
Datos Personales
Oracle
SELECT x.ETCNOM,x.ETCSFA,x.ETCGNA,x.USERSSO,x.ETCNAT,x.SPECC101,x.ETCPNA,x.ETCPSN,x.SPECC100,x.ETLSFA,x.ETLGNA,x.ETLNAT,x.SPECL101,x.ETLPNA,x.DMENU,x.DPROC,x.E2LIB00,x.SPECL100,x.ETDSFA,x.ETCDDE,x.FFNEX,x.FINEX,x.ETCDNA,x.ETLNAI,x.SPECL104,x.SPECL103,x.ETCMAT,x.NEX,x.NIC,x.ETCPRE,x.CMENU,x.CPROC,x.ETCSEX,x.USERADPNET FROM ETACIV x, SADMIN s WHERE x.ETCMAT = s.ETCMAT AND SADESO <= TO_DATE (TO_CHAR (SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND (s.SADSOR IS NULL OR (s.SADSOR >= TO_DATE (TO_CHAR (SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY'))) AND (s.NEXT IS NULL OR s.H1DFIN = s.SADSOR) AND s.H1DDEB >= TO_DATE('01/01/2015') AND (s.H1DFIN <= TO_DATE('01/12/2015') OR s.H1DFIN is NULL) AND s.ETCMAT in (Select ETCMAT From ETACIV Where NIC in( Select x.NIC From ETACIV x, SADMIN s WHERE x.ETCMAT = s.ETCMAT AND SADESO <= TO_DATE (TO_CHAR (SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND (s.SADSOR IS NULL OR (s.SADSOR >= TO_DATE (TO_CHAR (SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY'))) AND (s.NEXT IS NULL OR s.H1DFIN = s.SADSOR))) ORDER BY x.ETCMAT ASC
Estructura administrativa
SACAFF,System.String
SACAFFEC00,System.String
SACAFFEC01,System.String
SACAFFEC02,System.String
SACAFFEC03,System.String
SACAFFEC04,System.String
SACAFFEC05,System.String
SACAFFEC06,System.String
SACAFFEC07,System.String
SACAFFEC08,System.String
SACH2,System.String
SPSAC100,System.String
SACH1,System.String
SACMEN,System.String
SACMSO,System.String
SPSAC101,System.String
DOLIB02,System.String
SALAFF,System.String
SALAFFEC00,System.String
SALAFFEC01,System.String
SALAFFEC02,System.String
SALAFFEC03,System.String
SALAFFEC04,System.String
SALAFFEC05,System.String
SALAFFEC06,System.String
SALAFFEC07,System.String
SALAFFEC08,System.String
SALH2,System.String
SPSAL100,System.String
SALH1,System.String
DIASTP00,System.Decimal
DIASTP01,System.Decimal
DIASTP02,System.Decimal
DIASTP03,System.Decimal
DOLIB00,System.String
SALMEN,System.String
SALMSO,System.String
SPSAL101,System.String
DOLIB09,System.String
MODDAT01,System.DateTime
SADESO,System.DateTime
SADEGR,System.DateTime
FTPAL00,System.DateTime
FTPAL01,System.DateTime
FTPAL02,System.DateTime
FTPAL03,System.DateTime
SADSOR,System.DateTime
FTPDE00,System.DateTime
FTPDE01,System.DateTime
FTPDE02,System.DateTime
FTPDE03,System.DateTime
H1DFIN,System.Nullable`1[System.DateTime]
DODATE00,System.DateTime
SADANC,System.DateTime
H1DDEB,System.DateTime
ETCMAT,System.String
DOLIB05,System.String
DOLIB04,System.String
DOLIB03,System.String
DOLIB01,System.String
DOLIB08,System.String
TIPJOR00,System.String
TIPJOR01,System.String
TIPJOR02,System.String
TIPJOR03,System.String
30
Estructura administrativa
Oracle
SELECT SACAFF,SACAFFEC00,SACAFFEC01,SACAFFEC02,SACAFFEC03,SACAFFEC04,SACAFFEC05,SACAFFEC06,SACAFFEC07,SACAFFEC08,SACH2,SPSAC100,SACH1,SACMEN,SACMSO,SPSAC101,DOLIB02,SALAFF,SALAFFEC00,SALAFFEC01,SALAFFEC02,SALAFFEC03,SALAFFEC04,SALAFFEC05,SALAFFEC06,SALAFFEC07,SALAFFEC08,SALH2,SPSAL100,SALH1,DIASTP00,DIASTP01,DIASTP02,DIASTP03,DOLIB00,SALMEN,SALMSO,SPSAL101,DOLIB09,MODDAT01,SADESO,SADEGR,FTPAL00,FTPAL01,FTPAL02,FTPAL03,SADSOR,FTPDE00,FTPDE01,FTPDE02,FTPDE03,H1DFIN,DODATE00,SADANC,H1DDEB,ETCMAT,DOLIB05,DOLIB04,DOLIB03,DOLIB01,DOLIB08,TIPJOR00,TIPJOR01,TIPJOR02,TIPJOR03 FROM SADMIN WHERE SADESO <= TO_DATE (TO_CHAR (SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND (SADSOR IS NULL OR (SADSOR >= TO_DATE (TO_CHAR (SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY'))) AND (NEXT IS NULL OR H1DFIN = SADSOR) AND H1DDEB >= TO_DATE('01/01/2015') AND (H1DFIN <= TO_DATE('01/12/2015') OR H1DFIN is NULL) AND ETCMAT in (Select ETCMAT From ETACIV Where NIC in( Select x.NIC From ETACIV x, SADMIN s WHERE x.ETCMAT = s.ETCMAT AND SADESO <= TO_DATE (TO_CHAR (SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY') AND (s.SADSOR IS NULL OR (s.SADSOR >= TO_DATE (TO_CHAR (SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY'))) AND (s.NEXT IS NULL OR s.H1DFIN = s.SADSOR))) ORDER BY ETCMAT ASC
FuenteDeDatos1
LOWERDAY,System.DateTime
HIGHERDAY,System.DateTime
LITERAL,System.String
30
FuenteDeDatos1
Oracle
select Min(Fecha) as lowerDay, Max(Fecha) as higherDay, Min(fecha)||' - ' || Max(Fecha) as literal from H991162.DIM_TIEMPO Group By Año, Mes
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,19,2
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
0,0,4,0.8
Arial,12,Bold
0,0,0,0
Text2
LITERAL
Black
HeaderBand1
StiDataHelper.SetData(DataBand2, true);
Transparent
0,3.2,19,0.8
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
0,0,4,0.8
Arial,12,Bold
0,0,0,0
Text1
{FuenteDeDatos1.LITERAL}
Black
None;[79:129:189];1;Solid;False;4;Black
[250:192:143]
4.4,0,4,0.8
Arial,12,Bold
0,0,0,0
Text3
{Count(DataBand2)}
Black
Totals
FuenteDeDatos1
_x007B_Year_x0028_FuenteDeDatos1.LOWERDAY_x0029__x0020__x003D__x003D__x0020_2015_x0020__x0026__x0026__x0020_FuenteDeDatos1.LOWERDAY_x0020__x003C__x003D__x0020_Today_x007D_
DataBand1
True
ASC
LOWERDAY
Transparent
0,4.8,19,1.2
Transparent
0,0,12.8,1.2
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
2.65,0.05,0.8,0.4
Arial,8
7462756d25fb4204af9f149c9e781d98
0,0,0,0
CrossTab1_ColTotal1
AllowMove, AllowResize, AllowSelect, AllowChange
Total
Black
All;[155:155:155];1;Solid;False;4;Black
White
0,0.05,2.6,0.4
Arial,8
265368ac08b34857b2cc465b3f7d3f7f
0,0,0,0
CrossTab1_Column1_Title
AllowMove, AllowResize, AllowSelect, AllowChange
Building
[105:105:105]
Col:CrossTab1_Column1
All;[155:155:155];1;Solid;False;4;Black
White
0,0.5,1.4,0.4
Arial,8
72b4cca3dab844c8a88fd56772da7979
0,0,0,0
CrossTab1_SummaryTitle
AllowMove, AllowResize, AllowSelect, AllowChange
HeadCount
[105:105:105]
Expression
SummaryTitle
SACH2
All;[155:155:155];1;Solid;False;4;Black
White
1.45,0.05,1.2,0.4
{Estructura_administrativa.SACH2}
Arial,8
3bbf41127fcf4cacb14e82e2a2dada83
0,0,0,0
CrossTab1_Column1
AllowMove, AllowResize, AllowSelect, AllowChange
SACH2
[105:105:105]
7462756d25fb4204af9f149c9e781d98
Expression
{Estructura_administrativa.SACH2}
ETCMAT
All;[155:155:155];1;Solid;False;4;Black
[255:255:255]
1.45,0.5,1.2,0.4
Arial,8
841b3a0eeb794e17ac4f93268600eb60
0,0,0,0
CrossTab1_Sum1
AllowMove, AllowResize, AllowSelect, AllowChange
Count
0
Black
{Estructura_administrativa.ETCMAT}
Estructura administrativa
_x007B__x0028_Estructura_administrativa.H1DDEB_x0020__x003C__x003D__x0020_FuenteDeDatos1.LOWERDAY_x0020__x0026__x0026__x0028__x0028_Estructura_administrativa.H1DFIN_x0020__x003E_FuenteDeDatos1.LOWERDAY_x0029__x007C__x007C__x0028_Estructura_administrativa.H1DFIN_x0020__x003D__x003D__x0020_null_x0029__x0029__x0029__x007D_
Left
CrossTab1
Estructura administrativa
_x007B__x0028_Estructura_administrativa.H1DDEB_x0020__x003C__x003D__x0020_FuenteDeDatos1.LOWERDAY_x0020__x0026__x0026__x0028__x0028_Estructura_administrativa.H1DFIN_x0020__x003E_FuenteDeDatos1.LOWERDAY_x0029__x007C__x007C__x0028_Estructura_administrativa.H1DFIN_x0020__x003D__x003D__x0020_null_x0029__x0029__x0029__x007D_
DataBand2
dee153a741ba49ba8245cc88e2802f7b
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
Report
8/12/2015 10:40:04 AM
8/12/2015 9:56:57 AM
76af6c994aaa4025bc33609f2d775cac
Report
Centimeters
2015.1.15
CSharp