reporting services - Display Multiple Record values in SSRS -

i have 2 tables like

      id     name        1      xyz        2      pqr         id    value         1     x         2     y         1     p         2     q 

i need output follows in ssrs report

              xyz     pqr                x       y                p       q 

just create stored procedure generate "join" on "id" column. use stored procedure datasource new "dataset" in ssrs report.

on sidenote, why report require grouping laid out horizontally?