Reporting using fetchxml

(0) Share

Report

Posted on by Vighnesh

1,942

Hi All,

I have an out of box entity called opportunity and created two custom entities called opportunity contracts and opportunity service lines with one to many relationship. I am trying for an online fetchxml report using visual studio 2019. I am trying to use lookupset in conjunction with join function to print the child columns in a comma separated value with in the same column. It works for opportunity to opportunity service lines, and the same formula is not working for opportunity opportunity contract.

Formula for service lines: =Join(LookupSet(Fields!opportunityid.Value,
Fields!mms_opportunityidValue.Value,
Fields!mms_servicelineid.Value, ,OppSLines),/,/)

Formula for contract lines: =Join(LookupSet(Fields!opportunityid.Value,
Fields!mms_opportunityidValue.Value,
Fields!mms_contracttype.Value, OppCon),/,/)

All responses (1)

Answers (0)

RudyZhang Microsoft Employee on at

Like (1)

Report

Reporting using fetchxml

Hi,

We have analyzed your requirements and according to the official documentation, the function /LookupSet/ is used with these limitations. Please check if you are violating these restrictions when using it.

Please refer to the documentation at the following link
https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-lookupset-function?view=sql-server-ver16

In addition, we are reproducing your operation in a test environment to try to discover the cause of this problem. If there is any progress, we will reply below.

I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.

Best Regards,
Rudy Zhang