problem je u kodu dashboarda, buduci da broj radnika na odredjeno vuce na osnovu thr_prsn, a acemploymenttype se upisuje
u thr_prsnjob kada se izabere u parametrima.

Mozes to lako provjeriti sa:
Select p.acworker,et.acname,et.accode from tHR_Prsn P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType

accode bi trebao biti prazan.

Dok ne sredimo sistemski najbolje da kreiras novi dashboard a saljem ti kod za njega:

Select * from (Select
(Select count(*) from tHR_Prsn P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType where
(P.adDateExit > getdate() or P.adDateExit IS NULL) and P.adDateEnter < getdate()) as #$sqlEmp$#,

(Select count(*) from tHR_Prsnjob P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType join thr_prsn pr on pr.acworker=p.acworker where
ET.acCode = `2` and (Pr.adDateExit > getdate() or Pr.adDateExit IS NULL) and Pr.adDateEnter < getdate()) as #$sqlEmpTemp$#,

cast((Select count(*) from tHR_Prsnjob P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType join thr_prsn pr on pr.acworker=p.acworker where
ET.acCode = `2` and (Pr.adDateExit > getdate() or Pr.adDateExit IS NULL) and Pr.adDateEnter < getdate())*100.00/case when (Select count(*) from tHR_Prsn P inner join tHR_SetEmployType ET on IsNull(ET.acName, ``) = CASE WHEN IsNull(P.acEmploymentType, ``) = `` THEN `` ELSE P.acEmploymentType END where (P.adDateExit > getdate() or P.adDateExit IS NULL) and P.adDateEnter < getdate()) = 0 then 1 else (Select count(*) from tHR_Prsn P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType where
(P.adDateExit > getdate() or P.adDateExit IS NULL) and P.adDateEnter < getdate()) end as decimal(5,2)) as #$msPercentage$#) T

Javi jel ok.

LP

daj remote postavi pa cemo srediti, nazovi prije toga u DL, reci da imamo dogovoreno.

LP

sređeno