CODEWITHSUNDEEP
reporting-servicesssrs-2008
gh256
gh256

Reputation: 33

SSRS lookupset - row output

I am looking to use the lookupset function. I have a one to many relationship when one Risk has many Actions.

Using this function I can return it as a comma separated line, however what I really need is for each entry to display in a new row of a table, is this possible?

I have replaced the comma so instead of creating a comma separated line it does a newline, however I need it to line up with other values. This Is why I would like to to come out in rows in a table.

Upvotes: 1

Views: 4168

Answers (1)

Chris Latta
Chris Latta

Reputation: 20560

Can it display on separate lines rather than separate rows? If so, then you can simply separate the fields using carriage return/line feed pairs, like so:

=Join(LookupSet(Fields!Id.Value, Fields!Id.Value, Fields!FieldToLookup.Value, "LookupDataset"), vbCrLf)

Otherwise you are better off defining a subreport and embedding that in your table. The subreport is simply a report that is just a table with the report taking a parameter. You add this to the table in the main report using the toolbar and then set the parameters in the subreport properties to pass in the identification field name from the table's dataset.

Upvotes: 1

Related Questions