second sql query

[babarincairo]

Hi,

 

I made a report containing an input parameter (named numeroId).

 

I made my main query without problem to display data in the detail band. Example : SELECT C1,C2 FROM T1 WHERE C3 = $P{numeroId}

 

After that, in the title band , I want display an item

corresponding to a field of the line identified by numeroId. It means, do a query like this :

SELECT C4 FROM T2 WHERE numeroId = $P{numeroId}

 

But, I don't know where to put this query. I tried to use a subdataset but I don't know how to use the result field.

 

Can you help me ?

 

thanks

[babarincairo]

up!

[dpinfo]

You could solve the problem with 2 solutions:

1) you could make a query in which you put all the information you need:

 

select c1,c2,c4 from t1,t2

where

.......

 

Then you have the field C4 at your disposal and you could put the field in the title.

 

2) make a subreport.

 

Let us know if this help.

 

Bye

Dpinfo

[babarincairo]

dpinfo wrote:

1) you could make a query in which you put all the information you need: select c1,c2,c4 from t1,t2 where ....... Then you have the field C4 at your disposal and you could put the field in the title.

 

 

Ok, but it must be the main data source ?? Because I can't create a field or a variable with the SQL query as expression. It does'nt compile

[dpinfo]

From my point of view, in the main query you need to make a merge of the queries. From my point of view it seems possible.

If you don't like this solution you could create a subreport. With this solution you put the second query in the data/query of the second report, with a parameter . In the subreport properties in the master report in subreport(others) you need to define to which field of the master report the parameter is linked.

Bye

dpinfo