Sirs good afternoon!
I'm in a bush without a dog and I can not find more solutions to my problem, see:
In my Ireport form I use the Table component. I created a dataset that is responsible for fetching items from a contract in question. The query I put in this dataset is as follows:
SELECT ci.grupo||'.'||ci.subgrupo||'.'||ci.codigo AS material, ci.descricao AS descricao, ci.unidade AS unidade,
cri.quantidade AS requerido, cra.quantidade_atendida AS atendido
FROM compras.contrato_item ci
LEFT JOIN compras.contrato_requisicao_item cri ON (ci.ano = cri.ano AND ci.contrato = cri.contrato AND ci.item = cri.item)
LEFT JOIN compras.contrato_requisicao_item_atendido cra ON (cri.ano_requisicao = cra.ano_requisicao AND cri.requisicao = cra.requisicao AND cri.ano = cra.ano AND cri.contrato = cra.contrato AND cri.item = cra.item)
WHERE cri.ano_requisicao = $P!{PARAM_ANO_REQUISICAO} AND cri.requisicao = $P!{PARAM_REQUISICAO} AND cri.ano = $P!{PARAM_ANO_CONTRATO} AND cri.contrato = '$P!{PARAM_CONTRATO}'The detail is that these parameters are pointed to the main parameters configured in IReport.
Now comes the problem. When I roll in the IReport Preview the report is successfully mounted and this Table component lists all the Table Items, but when I send the .jasper to my java application to generate the report from the application the table does not list the items. I think it is a problem of these parameters, because when I set these parameters manually and I send the .jasper to the application the table shows the items.
Can anyone help me? Hugs!