Its urgent! Can I pass two queries at a time?

[2004 IR Help]

By: A$IT - asitp

Its urgent! Can I pass two queries at a time?

2005-04-05 02:12

Hi All,

 

I have a problem. I dont know how to deal with that?

I have to generate a report in which, I have to pass two queries at a time. And after that I have to render that report to pdf format. There are two group by queries.

 

What I did is that, I wrote a java code to get two ResultSet objects. I have stored these two objects to an ArrayList Object. Now can I pass this ArrayList Object to my RenderServlet?

 

How can I do this? I need it very urgently.

 

Thanx & Regards,

Asit Patadia.

 

 

 

 

By: Lukas - loester

RE: Its urgent! Can I pass two queries at a time?

2005-04-18 05:20

You cannot pass two ResultSet at the same time using the direct parameter as you do with just one.

I suggest you add your second ResultSet to a parameter in the parameter map. You could then pass this parameter to a sub report.