Sub-Queries in Report studio

[sdee_sekaran]

Hi,
Can anyone suggest me how to get subqueries in Report studio.

I have the following query
select name, age, (select address from tb_address) address from userinfo
I like to develop a report based on this query and not i dont want to place this query in cognos sql.

Thanks in Advance, Dhana.

[imts]

If u have your query ready then dont go for Cognos SQL.
U can point your own written SQL to the Query and define the query items manually.

Regards,
Tarun

[sdee_sekaran]

hi, Thanks for ur reply.
as i specified earlier. i want to develop a report based on that query without using cognossql or writing own query.

[bdybldr]

I'm not sure why u need a sub-query since your only pulling one field from a single table.  You should just be able to add the address data item to the main tabular model if the joins are defined in Framework Manager.

A sub-query can be accomplished by adding another tabular model (see insertable objects in toolbox) to the main tabular model.