setting query for subreport at runtime

[gest]

 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

[JSquire]

try a CASE statement in the order by clause of your query - this is dependant on the database and version of SQL.

just google 'SQL CASE statement' for examples

 

[gest]

 Hello JSquire,

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

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

grtz

[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

[C-Box]

What about passing the whole orderby clause as parameter

 

and just use..

 

... ORDER BY $P!{SubReportOrderClause}

within the SubReport Query

 

hth

C-Box

[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