using union operator in the querry pannel window

If the question is how to link from one report to another...then OpenDocument function can be used.

You can do this in different methods:

In ASP environment..

Universe level: create an object with Object format: HTML option enabled

SELECT:<A href Server:PortNo/wiasp/scripts/opendocument.asp?....etc... >

Report Level: use Hyperlink function

Hyperlink( Server:PortNo/wiasp/scripts......etc........... TaxtAsLink )

For JSP environment replace ASP with JSP.

Any of the above methods will create a Hyperlink in the report pointing to Another report. The arguments/prompts for this new report can be passes from the original report.

Thanks

Ravi