SQL Server Performance Forum – Threads Archive

Most urgent – Display a field horizontally -detail

Hi All, Currently I#%92m struggling to display a field horizontally in Reporting services. For example: Consider customer table I want to display customer ID field horizontally in details like below
customers :
——————————————————-
A001 C002 C003 C004 C005 C006 C007 C008 C009 C0010 D001 D002 D003 D004 D005 D006 D007 D008 D009 D0010
——————————————————
Is there any way to display customer field in table like above. [?] Thanks [8D] Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

Check out "pivot table" in BOL or google for this term or "Crosstab query" —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Oops, sorry, just realised that this is Reporting Services related… —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Hi all help me out Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

In Crystal Reports you can use Join function which joins all the values of a field. Try the same in SSRS also Madhivanan Failing to plan is Planning to fail

I tried i don’t think so.
Is there any way to put a field in a table cell details section and make it grow horizontally for all records? Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

In crystal report we have format with multiple coulmns
Same think i need in reporting service Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

Refer this
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true Madhivanan Failing to plan is Planning to fail

Hi All, I solved the above issue
please refer below link
http://blogs.msdn.com/chrishays/articles/193285.aspx It will give us Report Xml file to display horizontally.
you have to modify that XML file based on your requirment. Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

Thanks for posting the link! [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

Thanks for all your Suggestions. Welcome !!!!!! Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

Good to know you got solution [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Madhivanan Failing to plan is Planning to fail

good keepitup mathi..

SURYA

]]>