|
Re: Use output of a dataset into another dataset [message #684439 is a reply to message #684386] |
Wed, 15 June 2011 14:47 |
|
Can you use a joint dataset?
Jason
On 6/15/2011 10:10 AM, Krishan Babbar wrote:
> I have to create a report using output of 2 separate databases.
>
> I have
>
> Database A at system One
> Database B at system Two
> Table "Details" in database B having relationship with table "User" in
> database A
> Table Details may have lakhs of records.
>
> Schema of table "User"
> Id EncryptedId
> UserName
> etc.
>
> Schema of table "Details"
> EncryptedId
> Address
>
> EncryptedId is the only field showing relationship between both tables.
>
>
> I have to show the following in my report, user will give his Id
>
> Information from table User of Database A +
> Information from table "Details" of Database B
>
> My problem is to fetch EncryptedId first from table "User" then use that
> in query fetching data from table "Details".
>
> Please suggest the solution or let me know if my question is not clear.
>
> Thanks
> Krishan Babbar
>
>
>
|
|
|
|
Re: Use output of a dataset into another dataset [message #684925 is a reply to message #684735] |
Thu, 16 June 2011 13:35 |
|
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.
Jaosn
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?
>
> Thanks
>
> Krishan Babbar
>
|
|
|
Powered by
FUDForum. Page generated in 0.03917 seconds