I have a report in which i have 2 sections. There is a different data provider for each section. So, i have 2 data providers i.e DP1 & DP2. I want to pass results of a column in DP1 to the DP2.
I know i can do that by including a subquery in DP2 but i do not want to do that as DP1 queries against 100 million row table and i do not want that query to be run twice.
What are my options
I know i can do that by including a subquery in DP2 but i do not want to do that as DP1 queries against 100 million row table and i do not want that query to be run twice.
What are my options