Dynamics Community Forum Thread Details

Passing string parameter from one dataset to another fetch xml query(dataset) in Sql Server Data Tools

Hi All,

I am creating a report via SQL Server Data tools using fetch xml extension.

I have a Main dataset.And it's attributes are then displayed in the report. One of those fields is a string attribute named "Customer Identification Number".

I have a Second dataset. Where is fetched Custom Entity which doesn't have any relation to the Entity from the first dataset. (This Custom Entity serves the mapping puropses and is filled by another interface, there are mainly two string fields: 1. Name = Customer Identification Number, 2. Leading Account Number

So in my report I have to display for each record which contains Customer Identification Number this Leading Account Number from the second dataset.

What I did is I used the Lookup function to map the same Customer Identification Number from both datasets

=Lookup(Fields!custidnumber.Value, Fields!custidnumber.Value, Fields!csp_leadingaccount.Value, "DSIdMapping")

Which is working fine and I see the correct data in my report. I am just worried if in this mapping entity will be for example million records, will my report fetch all of them and then apply the lookup function for the specific record?

Because I have also tried to fetch the data from second dataset directly for each record using parameter but it didn't work, those are steps I did:

1. Create Parameter of Customer Identification Number from first datasete

2. in Fetch XML query add a condition that the customer identification number should be eq to parameter

3. Same lookup function

Thanks in advance for any suggestions and hints!

Thanks!

Quick Links

Leaderboard