Hi all, I have a report with a query to get orders information including order_id, I have to use this order_id to get the multiple rows from another table, If I join these two tables than I am getting multiple rows of order table. I wanted to write a sub report to get the sub table data in the sub report query by sending the order id to the sub report. But since this is very costly, I cant do it. I was suggested to created a datasource of the subtable by sending all the order ids to a query and use this datasource to fill the sub report. Can some one please guide me on how to create the datasource by sending all the order ids to a query and how to use this datasource to fill the sub report.
