iReport Parameters

[samanta.santos]

parameter
good morning.Someone can help me?
I waant to know about parameters from ireport.
I hava this query

 
select
      --tmon.id_turma_monitoria,
      --cal.id_calendario,
      tur.codigo,
      dis.nome as Nome_Disciplina,
      al.matricula,
      al.nome as Nome_Aluno,
      to_char(tmon.data_inicio, 'DD/MM/YYYY') as Data_Inicio,
      to_char(tmon.data_termino, 'DD/MM/YYYY') as Data_Termino,
      --ac.id_aluno_curso,
     -- mon.id_monitoria,
     -- prof.id_professor,
      cont.numero_contrato,
      prof.nome as Nome_Professor

      
from t_turma_monitoria tmon

inner join t_turma tur on tur.id_turma = tmon.id_turma
inner join t_contrato cont on cont.id_contrato = tmon.id_contrato
inner join t_monitoria mon on mon.id_monitoria = cont.id_monitoria
inner join t_professor prof on prof.id_professor = tur.id_professor
inner join t_aluno_curso ac on ac.id_aluno_curso = mon.id_aluno_curso
inner join t_aluno al on al.id_aluno = ac.id_aluno
inner join t_calendario cal on cal.id_calendario = tur.id_calendario
inner join t_disciplina dis on dis.id_disciplina = tur.id_disciplina

where id_calenadario = $P{idCalendario} ) as calendario

what is the correct parameters i have to insert to take the calendario of turmas entered

thanks

[Tolls]

$P{idCalendario} - this is the only parameter I can see in there.

[Sharad0101]

Hi,

Today I was trying to use parameter in where clause
such as--

select emp_salary,last_name
from employees
where emp_id in ($p{id1},$p{id2})

but i m getting error so how to
figure out this problem plz help me

Is it possible to do such a thing with iReport and JasperReport ?

[mine0926]

but i m getting error so how to
figure out this problem plz help me

What error? Post the error message..

Is it possible to do such a thing with iReport and JasperReport ?

Yes, but are you trying to do this in iReport alone? Or are you trying to pass parameter's value from java to iReport?