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.
Create a datasource inside a report to be used in sub report
in Products
Posted
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.