Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2010
    Posts
    2
    Rep Power
    0

    Default iReport Parameters

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


    Java Code:
     
    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

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,792
    Rep Power
    19

    Default

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

  3. #3
    Sharad0101 is offline Member
    Join Date
    Jun 2011
    Posts
    1
    Rep Power
    0

    Default

    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 ?

  4. #4
    mine0926 is offline Senior Member
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    580
    Rep Power
    5

    Default

    Quote Originally Posted by Sharad0101 View Post
    but i m getting error so how to
    figure out this problem plz help me
    What error? Post the error message..

    Quote Originally Posted by Sharad0101 View Post
    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?

Similar Threads

  1. iReport
    By Freddie in forum Advanced Java
    Replies: 6
    Last Post: 04-20-2010, 06:25 PM
  2. About iReport
    By HotEvilGirl in forum New To Java
    Replies: 1
    Last Post: 05-06-2009, 01:07 PM
  3. Jsp + Ireport Question
    By str_ardi_per in forum JavaServer Pages (JSP) and JSTL
    Replies: 2
    Last Post: 12-10-2008, 05:43 PM
  4. jsp and ireport
    By sbuggle in forum JavaServer Pages (JSP) and JSTL
    Replies: 1
    Last Post: 07-25-2008, 09:25 AM
  5. Eclipse+ireport
    By Nick15 in forum Eclipse
    Replies: 2
    Last Post: 05-14-2007, 04:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •