Jump to content
Changes to the Jaspersoft community edition download ×

Problem with complex report query


stawen

Recommended Posts

Hello !

 

I've a big and strange problem where i try to export (pdf) my report. It always get empty with my dynamic query...

 

Here is my report query :

Code:

SELECT salon.nom_salon,
concat('C',UPPER(typesalon.label)) as type_salon,
pays.nom_pays,
pays.nom_complet as nom_complet_pays,
UPPER(pays.capitale) as capitale,
sousdir.abreviation as sousdirection,
presta.abreviation as prestation
FROM t_salon salon,
t_type_salon typesalon,
t_pays pays,
t_zone_geographique zones,
t_sousdirection sousdir,
t_prestation presta,
t_statut_pays statut
where typesalon.id = salon.type_salon_id
AND salon.id = $P{id_salon}
AND pays.id = $P{id_pays}
AND pays.t_zone_geographique_id = zones.id
AND zones.t_sousdirection_id = sousdir.id
AND statut.t_pays_id = salon.id
AND presta.id = statut.t_prestation_id;

 

- The report exports correctly when i replace my 2 parameters (id_salon, id_pays) by real numbers.

 

- If i don't set any query and i create a textField with my parameters, it works and parameters prints.

 

- I can do dynamic query like "SELECT * FROM t_pays WHERRE id=$P{id_pays}, and the report works fine.

 

Please help me, all things works separately but not together ...

 

Regards,

Stawen

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...