none
LOOKUPSET/JOIN to display in separate rows or columns?

    Question

  • I have 2 datasets and one tablix.  In the [ClaimantAddress] dataset, I have an [AddressType] field with either Residence or Mailing address.

    CLAIMS dataset = CLAIMID, FIRSTNAME, LASTNAME, CLAIMANTID fields

    CLAIMANTADDRESS dataset = CLAIMANTID, ADDRESSTYPE, ADDRESS, CITY, STATE, ZIPCODE fields and a calculated field FULLADDRESS.

    The tablix main is the CLAIMANTADDRESS column grouped by ADDRESSTYPE field. I use JOIN/LOOKUP SET to display data from the CLAIMS dataset.

    The report looks like this:

    Claim ID#

    First Name

    Last Name

    Claimant ID

    Mailing Address

    Residence Address

    123, 124, 125

    A, A, A

    B, B, B

    1111

    17 Giotto Dr

    17 Giotto Dr

    But is there a way for me to display the data into separate rows like this:

    Claim ID#

    First Name

    Last Name

    Claimant ID

    Mailing Address

    Residence Address

    123

    A

    B

    1111

    17 Giotto Dr

    17 Giotto Dr

    124

    A

    B

    1111

    17 Giotto Dr

    17 Giotto Dr

    125

    A

    B

    1111

    17 Giotto Dr

    17 Giotto Dr


    • Edited by AzuDaioh Tuesday, July 09, 2013 4:27 PM
    Tuesday, July 09, 2013 12:08 AM

Answers

  • Hi Azudaioh,

    As I said in that thread, we cannot display the lookupset results in multiple rows in Reporting Services currently. What we can do is displaying lookupset results in multiple lines.
    =JOIN(LOOKUPSET(Fields!ClaimantID.Value, Fields!ClaimantID.Value, Fields!ClaimID.Value, "Claims"), VbCrlf)

    Thank you for your understanding.

    Regards,


    Charlie Liao
    TechNet Community Support

    Wednesday, July 10, 2013 8:28 AM
    Moderator

All replies