Win a copy of Securing DevOps this week in the Security forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
Ranch Hand
Posts: 290
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • 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
  • 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
  • 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) : "")
)
)
)
)
)
)
)
)
)
)
)
 
I can't take it! You are too smart for me! Here is the tiny ad:
Thread Boost - a very different sort of advertising
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!