• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

IReport:How can i use multi-select statement in jasper

 
Ranch Hand
Posts: 290
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all....

Iam working in Ireport for JasperReport, and i have a case in which i have multi-select statement to get the fields...usually, i have single select statment in jasper report..
But How Can I Do That???


Regards
[ February 21, 2007: Message edited by: Ala'a Hendi ]
 
Ranch Hand
Posts: 265
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dear Hendi,
Have you tried to connect it with any Java Application. I tried to connect it and got error messages. Can you please send me the code for connecting it, so that i can also work with that.

Regards

Aravind Prasad
 
Alan Hermin
Ranch Hand
Posts: 290
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi..

See This Code part from .jrxml file, which contains the Query:



But you Can NOT say, for example:





I Think it is OK to understand me?
 
Ranch Hand
Posts: 1855
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Ala'a Hendi:
Hi all....

Iam working in Ireport for JasperReport, and i have a case in which i have multi-select statement to get the fields...usually, i have single select statment in jasper report..
But How Can I Do That???



Hi Ala'a

I don't think that you can do that in a single report. Each report is based on one collection of value objects. However you can use subreports in your report which gives you the ability to use more than one collection. One collection for each subreport.

A good book (the only one ) is:



Regards,
Darya
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
TRY SOMETHING THIS LIKE THIS
($F{dt_inicio_vig}.substring(3,5).equals("01") ? "Janeiro/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("02") ? "Fevereiro/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("03") ? "Mar�o/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("04") ? "Abril/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("05") ? "Maio/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("06") ? "Junho/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("07") ? "Julho/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("08") ? "Agosto/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("09") ? "Setembro/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("10") ? "Outubro/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("11") ? "Novembro/"+ $F{dt_inicio_vig}.substring(6,10) :
($F{dt_inicio_vig}.substring(3,5).equals("12") ? "Dezembro/"+ $F{dt_inicio_vig}.substring(6,10) : "")
)
)
)
)
)
)
)
)
)
)
)
 
reply
    Bookmark Topic Watch Topic
  • New Topic