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.
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
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.
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.