Map Columns fromDatabase to SSRS Report

Question

Hi All I have a table in the Database ID NAME 1 A 2 B 3 C 4 D I just wanted to show in my SSRS Report column names as A B C D How to Map these table Name Values in SSRS Report and also if i add one more value in the table it should automatically map into SSRS Report Column.Could anyone help on this please. Thanks Prasant

John Penn · Answer

Great! Please mark my answer as accepted - thanks!

Prasant Jinaga · Answer

Hi John...ThanksIts working with matrix!!!:-)

Suthish Nair · Answer

Why don't convert Rows to Columns using SQL and bind to Report. Convert Rows to Columns in SQL Server 2008/2005

John Penn · Answer

Without knowing what you intend to display under each column I'd suggest that you try a matrix instead of a table.

ID	NAME
1	A
2	B
3	C
4	D