Problem three subreports!!!!!

[2006 IR Open Dicussion]

By: Salomon - otaka

Problem three subreports!!!!!

2006-03-16 00:09

I have problem it is then main report consisting with three subreport stayed it examines

the parameter of date the type of data String the (conversion in query) and it passes on remaining

subreports this parameter. After they inscriptions date they display me reports always with the same date.

Does parameter pass on irregularly ? I in report main added parameter I qualified him

type on String I as well as in query SQL placed this parameter SP { param date } and on tuck

I passed the remaining subreports the name of file the jaspera. It works on version IReports 0.51 and

JasperReports 1.0.1. thanks

 

select fields...,....,...

from "ARCHIWUM_AWIZ" "ARCHIWUM_AWIZ", "AWIZO_LINIE" "AWIZO_LINIE" where "ARCHIWUM_AWIZ"."DATA_PLIK"

 

="AWIZO_LINIE"."DATA_PLIK"(+)

and "ARCHIWUM_AWIZ"."NAZWA_PLIK" ="AWIZO_LINIE"."NAZWA_PLIK"(+)

and TO_CHAR(DATA_ZAPIS ,'DD-MM-YYYY')='$P!{test}'

 

DATA_ZAPIS field