Dynamický dotaz - CRM - Report Průměrný obrat dle NACE (za firmu)

ID:

S2G12QSVRT2OL4XQWDJE53GYWW

Datasety

MAIN

Popis:

Obor činnosti NACE

SQL definice:

SELECT {FIELDS},
(COALESCE(A.Code,A.Code,'      ') ||
 COALESCE(B.Code,B.Code,'      ') ||
 COALESCE(C.Code,C.Code,'      ') ||
 COALESCE(D.Code,D.Code,'      ') ||
 COALESCE(E.Code,E.Code,'      ')) AS CodeKey
FROM NACE A
  {JOIN}
WHERE (A.Parent_ID = '0000000000') OR (A.Parent_ID IS NULL)
  and (E.Hidden = 'N' or E.Hidden is null)
  and (D.Hidden = 'N' or D.Hidden is null) and (C.Hidden = 'N' or C.Hidden is null)
  and (B.Hidden = 'N' or B.Hidden is null) and (A.Hidden = 'N' or A.Hidden is null)
AND
(
  (({$NACESelID}
  = ''
  )
  OR
  (A.ID in
  (SELECT Bx.ID FROM NACE Bx WHERE Bx.Hidden = 'N' AND
    ( (Bx.ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})) OR
    (({$NACEWithChilds} in ('1', 'A')) and
    (Bx.ID in (select ID from Sys$NACE2 where Superior_ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})))))
  )))
OR
  (({$NACESelID}
  = ''
  )
  OR
  (B.ID in
  (SELECT Bx.ID FROM NACE Bx WHERE Bx.Hidden = 'N' AND
    ( (Bx.ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})) OR
    (({$NACEWithChilds} in ('1', 'A')) and
    (Bx.ID in (select ID from Sys$NACE2 where Superior_ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})))))
  )))
OR
  (({$NACESelID}
  = ''
  )
  OR
  (C.ID in
  (SELECT Bx.ID FROM NACE Bx WHERE Bx.Hidden = 'N' AND
    ( (Bx.ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})) OR
    (({$NACEWithChilds} in ('1', 'A')) and
    (Bx.ID in (select ID from Sys$NACE2 where Superior_ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})))))
  )))
OR
  (({$NACESelID}
  = ''
  )
  OR
  (D.ID in
  (SELECT Bx.ID FROM NACE Bx WHERE Bx.Hidden = 'N' AND
    ( (Bx.ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})) OR
    (({$NACEWithChilds} in ('1', 'A')) and
    (Bx.ID in (select ID from Sys$NACE2 where Superior_ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})))))
  )))
OR
  (({$NACESelID}
  = ''
  )
  OR
  (E.ID in
  (SELECT Bx.ID FROM NACE Bx WHERE Bx.Hidden = 'N' AND
    ( (Bx.ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})) OR
    (({$NACEWithChilds} in ('1', 'A')) and
    (Bx.ID in (select ID from Sys$NACE2 where Superior_ID in (select OBJ_ID from SELDAT where SEL_ID = {$NACESelID})))))
  )))
)
{ANDWHERE}
ORDER BY CodeKey

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	GEPU3UY3U2POB4VWN4FIPOAQEG	Level_1
B	GEPU3UY3U2POB4VWN4FIPOAQEG	Level_2	NACE kód
C	GEPU3UY3U2POB4VWN4FIPOAQEG	Level_3	NACE kód
D	GEPU3UY3U2POB4VWN4FIPOAQEG	Level_4	NACE kód
E	GEPU3UY3U2POB4VWN4FIPOAQEG	Level_5	NACE kód

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
L1Amount	dtFloat	15	(select TotalAmount from FirmNACEOwnTurnoverFirmCount(A.ID, {$FirmSelID}, 'N') )		Obrat
L1FirmCount	dtFloat	15	(select FirmCount from FirmNACEOwnTurnoverFirmCount(A.ID, {$FirmSelID}, 'N') )		Počet firem
L2Amount	dtFloat	15	(select TotalAmount from FirmNACEOwnTurnoverFirmCount(B.ID, {$FirmSelID}, 'N') )		Obrat
L2FirmCount	dtFloat	15	(select FirmCount from FirmNACEOwnTurnoverFirmCount(B.ID, {$FirmSelID}, 'N') )		Počet firem
L3Amount	dtFloat	15	(select TotalAmount from FirmNACEOwnTurnoverFirmCount(C.ID, {$FirmSelID}, 'N') )		Obrat
L3FirmCount	dtFloat	15	(select FirmCount from FirmNACEOwnTurnoverFirmCount(C.ID, {$FirmSelID}, 'N') )		Počet firem
L4Amount	dtFloat	15	(select TotalAmount from FirmNACEOwnTurnoverFirmCount(D.ID, {$FirmSelID}, 'N') )		Obrat
L4FirmCount	dtFloat	15	(select FirmCount from FirmNACEOwnTurnoverFirmCount(D.ID, {$FirmSelID}, 'N') )		Počet firem
L5Amount	dtFloat	15	(select TotalAmount from FirmNACEOwnTurnoverFirmCount(E.ID, {$FirmSelID}, 'N') )		Obrat
L5FirmCount	dtFloat	15	(select FirmCount from FirmNACEOwnTurnoverFirmCount(E.ID, {$FirmSelID}, 'N') )		Počet firem

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=GEPU3UY3U2POB4VWN4FIPOAQEG

Code

Šablona:

Code

Dataset:

MAIN

Speciální parametry:

Hidden=True

Name

Šablona:

Name

Dataset:

MAIN

Speciální parametry:

Hidden=True

NotZero

Popiska:

Jen nenulové hodnoty

Typ/Subtyp:

ctBoolean/0

ckSingle:

(
({:Value} = 'A')
OR
({:Value} = 'N')
)

Dataset:

MAIN

NACE_ID

Šablona:

NACE_ID (Replacement link)

Dataset:

MAIN

Firm_ID

Šablona:

Firm_ID (Replacement Link)

Dataset:

MAIN

Generated by ABRA Software a.s. 27.10.2021 16:36