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),/,/)
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
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
1,942
Share
Report
All responses (
Answers (
