Bonjour, je ne suis pas expert; qq'un pourrait-il m'aider à comprendre..... J'essaie de contourner le fait que Ireport ne gère pas de multiples requêtes dans un rapport. J'ai tenté les sous-rapports mais je n'y arrive pas.
Voici 2 requêtes qui fonctionnent.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 SELECT tbl_workorder.`CODE_WORKORDER` AS tbl_workorder_CODE_WORKORDER, tbl_workorder.`WOT11` AS tbl_workorder_WOT11, tbl_workorder.`FK_CODE_LABOR_INCHARGE` AS tbl_workorder_FK_CODE_LABOR_INCHARGE, COUNT(CODE_WORKORDER) As Nbbt FROM `tbl_workorder` tbl_workorder WHERE tbl_workorder.creationdate between $P{DATEDEBUT} and $P{DATEFIN} AND tbl_workorder.fk_code_site = $P{SITE} AND tbl_workorder.fk_code_organisation = $P{ORG} AND tbl_workorder.`WOT11`='VLS' GROUP BY tbl_workorder_FK_CODE_LABOR_INCHARGE
La seconde
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 SELECT tbl_workorder.`CODE_WORKORDER` AS tbl_workorder_CODE_WORKORDER, tbl_workorder.`WOT11` AS tbl_workorder_WOT11, tbl_workorder.`FK_CODE_LABOR_INCHARGE` AS tbl_workorder_FK_CODE_LABOR_INCHARGE, COUNT(CODE_WORKORDER) As Nbbt FROM `tbl_workorder` tbl_workorder WHERE tbl_workorder.creationdate between $P{DATEDEBUT} and $P{DATEFIN} AND tbl_workorder.fk_code_site = $P{SITE} AND tbl_workorder.fk_code_organisation = $P{ORG} AND (tbl_workorder.`WOT11`='BORNE' OR tbl_workorder.`WOT11`='BORNETTE') GROUP BY tbl_workorder_FK_CODE_LABOR_INCHARGE
Quand je tente de le faire en une seule requête, le résultat est faux?
QUI PEUT M'AIDER ???
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 SELECT tbl_workorder.`CODE_WORKORDER` AS tbl_workorder_CODE_WORKORDER, tbl_workorder.`WOT11` AS tbl_workorder_WOT11, tbl_workorder.`FK_CODE_LABOR_INCHARGE` AS tbl_workorder_FK_CODE_LABOR_INCHARGE, (SELECT COUNT(CODE_WORKORDER) FROM `tbl_workorder` tbl_workorder WHERE(tbl_workorder.`WOT11`='BORNE' OR tbl_workorder.`WOT11`='BORNETTE')) As Nbbtmob, (SELECT COUNT(CODE_WORKORDER) FROM `tbl_workorder` tbl_workorder WHERE(tbl_workorder.`WOT11`='VLS')) As Nbbtvls FROM `tbl_workorder` tbl_workorder WHERE tbl_workorder.creationdate between $P{DATEDEBUT} and $P{DATEFIN} AND tbl_workorder.fk_code_site = $P{SITE} AND tbl_workorder.fk_code_organisation = $P{ORG} GROUP BY tbl_workorder_FK_CODE_LABOR_INCHARGE
Merci
Partager