gest

btw I use iReports 3.6.2

Hello, I would like to do the following: in masterreport I have a parameter $P{MY_VECTOR} of class java.util.Vector I pass this parameter to my subreport. In the subreport I like to 'add' a value to the vector in my masterreport I want to print the values of my vector. Does anyone have an idea on how to do this? gr gest

Hey, solved my problem by using a case-structure in the order-by of my query order by case when par=? then ... end desc, when par=? then ... end asc, col3, col2 ... gr gest

After doing some test on Oracle with a sql-statement that has a CASE-statement in the Order-By-clause, I haven't yet found a solution. My problem is that I have to be able to set the order-by as for example column1 asc or column2 desc, ... gr geert

Hello JSquire, thanks for your reply, haven't thought about doing that... I'll try it the first thing monday morning at work. grtz

Hello, I am facing a problem with setting the query for my subreport at runtime. I have to be able to change the 'order by'-clause for the subreport-query at runtime (in java application). Doing this for my master-report goes very well. Does anyone have an idea how to do this? I know it can be done with parameters, but I have to be able to set the order by clause of the subreport's query like order by col1 desc, col 2 col3 asc or order by col2 asc, col1 desc, col2 asc the table will always be the same and the returned colums from the query too... gr Geert Post Edited by gest at 08/28/2009 12:48 Post Edited by gest at 08/28/2009 12:49