|Re: Use output of a dataset into another dataset [message #684925 is a reply to message #684735]
||Thu, 16 June 2011 09:35
| Jason Weathersby
Registered: July 2009
If you are trying to display user/details, you could make two datasets |
one for users and one for details. The details dataset can be
parameterized like select * from details where userid = ?. Then add a
table to the report for users. Then nest the details table in the users
table. You can then select binding table for nested table and set the
value of the parameter for the query to the details. Does this make
sense. This will perform more queries though.
On 6/16/2011 2:25 AM, Krishan Babbar wrote:
> Yes Jason,
> I can use Joint Dataset, but as per my understanding with Joint Dataset,
> I need to create total 3 datasets as given below.
> 1. First Dataset fetch data from table User for given Id
> 2. Second Dataset will fetch all the data from table Details.
> 3. Third would be Joint Dataset, which will fetch the required data
> Now problem is second dataset. In this dataset it will first fetch all
> the records which can be in lakhs or more, which ultimately decrease the
> performance. So i want to avoid this performance degradation.
> Am I right?
> what you suggest as an alternative?
> Krishan Babbar
Powered by FUDForum
. Page generated in 0.09762 seconds