Can this be done by subdatasets?

[J_N]

I have rather complex SQL query. I need for fetch another field (which isn't in the main query). Can I make a subdataset with a query like this

 

select something from another_table where key = $F{field_in_main_query}

 

and fetch the 'something' value for every row and put it on report ? Is it possible or must I construct some workaround? Thanks.

[lucianc]

You can't use subdatasets for this. You can post a feature request for this, but for now you'll need to find another way to do it.

 

Regards,

Lucian