|Table with nested Datasets [message #1713774]
||Fri, 06 November 2015 15:25
| Keith Clark
Registered: July 2014
I am trying to create a report that has datasets like:|
select * from customers
select * from orders where custid = ?
(where the ? parameter links to the current custid of DataSet1)
I would like the report to be like such:
And so on.
I am thinking I want a table (for DataSet2) within a table (for DataSet1) to display all the orders per customer, but I am not sure how to link DataSet2 back to the current DataSet1 record.
Anyone have any examples?
[Updated on: Fri, 06 November 2015 15:26]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.02265 seconds