CODEWITHSUNDEEP
reportbuilderssrs-2019
borkybork
borkybork

Reputation: 1

Create a comprehensive table based on 2 datasets in Report Builder

I'm using Report Builder for SSRS 2019 and I basically need to create a table based on the customer list from dataset1, and all the projects associated with them from dataset2. Also need to leave out any customers that are not in DataSet1.

DataSet1 and DataSet2 (https://i.sstatic.net/4a34GXuL.png)

I have =LookUpSet(CStr(Fields!Customer_Name.Value),CStr(Fields!Customer_Name.Value),Fields!Project_Name.Value, "DataSet2"). The report runs but it's giving me an #Error in the table and I can't figure out what I'm doing wrong. When I add JOIN in the formula, it lists all the projects in one cell, but I need them in separate rows. would anyone have any idea? thanks in advance!

Desired Result (https://i.sstatic.net/OML3ls18.png)

Upvotes: 0

Views: 17

Answers (0)

Related Questions