Hi,
I try to do a report with a chart (X,Y one) in RCP Designer. I did this request :
When I clic on preview, the system ask me for parameters (date1, date2 and service (in a list box)). And the problem is..;my list box is always empty !
Code SQL : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17 select code_service, libelle_service, Lits_installes, cle_service, date_occ, Lits_occupes from occupation_bis inner join services on cle_service=code_service where code_service = ? order by date_occ Having date_occ >= ? And date_occ <= ?
I've tried this :
but is this case, when I clic on preview, the system tell me that there is an error...
Code SQL : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 select code_service, libelle_service, Lits_installes, cle_service, date_occ, Lits_occupes from occupation_bis inner join services on cle_service=code_service where date_occ >= ? AND date_occ <= ? AND code_service = ? order by date_occ...
Does someone could possibly help me ?
Great thanks
JP
Envoyé par Traduction par BiM
Partager