locked
Put the result att one row RRS feed

  • Question

  • User1226526163 posted

    Hi,

    I have 3 tables with one to many relation. Somtehing like this:

    TBL1

    ID, col2, col3, col4

    1, aaa, bbb, ccc

    2, ddd, eee, fff

    3, ggg, hhh, iii

    TBL2

    TBL2ID, COL1

    1, test

    2, test1

    3, test2

    TBL3

    TBL1ID, TBL2ID

    1, 1

    2, 1

    3, 1

    At the moment i have group for tbl2 in the report and details for the tbl1  looking like this

    TBL2ID, col2 (tbl1), col3 (tbl1), col4 (tbl1)

    1, aaa, bbb, ccc

       ddd, eee, fff

       ggg, hhh, iii 

    Now i want it to look like this:

    1,  aaa, bbb, ccc, ddd, eee, fff, ggg, hhh, iii 

    Is it possible to accomplish in ssrs or in the query. I have tried with pivot but it doesnt work beacuse i have to pivot on more then one col.?

    Monday, August 22, 2011 7:42 AM

Answers