[Vector usage in iReports]

btw I use iReports 3.6.2

[Vector usage in iReports]

 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

[setting query for subreport at runtime]

 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

[setting query for subreport at runtime]

 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

[setting query for subreport at runtime]

 Hello JSquire,

thanks for your reply, haven't thought about doing that...

I'll try it the first thing monday morning at work.

grtz

[setting query for subreport at runtime]

 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