I have two tables like
| ID | NAME |
| 1 | A |
| 2 | B |
| ID | VALUE |
| 1 | X |
| 2 | Y |
| 1 | P |
| 2 | Q |
Now I want to display in my SSRS Report something like this.
| A | B |
| X | Y |
| P | Q |
Could anyone help me out on this how to display in the Report.
Thanks,
Prasant
| ID | NAME |
| 1 | A |
| 2 | B |
| ID | VALUE |
| 1 | X |
| 2 | Y |
| 1 | P |
| 2 | Q |
| A | B |
| X | Y |
| P | Q |
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Prasant JinagaPosted Jul 1, 2011, 5:56 AM
Thanks,
Prasant
Dorababu MekaPosted Jul 1, 2011, 5:52 AM