Hello, i need to create a report with more than one queries to retrieve diferent types of objects, to show in the same table. How i can do this ? Thanks for your help.
2 Replies
Thanks for your reply Matthijs.
I tried to use nested queries but i didn't had success!!
To solve this necessity, i changed the code of the standard report, and added a my customized code.
Thanks for your help.
M. Duitshof on
The queries have to be nested. You have to find a way to build your Query 2 within Query 1.
Query 2 can be defined in a data table or in a separate query, as shown below.
In the table you can show data fields from superior queries next to data fields from the current query.
good luck,
Matthijs