SQL Server Performance

Most urgent - Display a field horizontally -detail

Discussion in 'SQL Server Reporting Services' started by mkmathi, Dec 14, 2005.

  1. mkmathi New Member

    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

  2. FrankKalis Moderator

  3. FrankKalis Moderator

  4. mkmathi New Member

    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

  5. Madhivanan Moderator

    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
  6. mkmathi New Member

    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

  7. mkmathi New Member

    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

  8. Madhivanan Moderator

  9. mkmathi New Member

    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

  10. FrankKalis Moderator

    Thanks for posting the link! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
  11. mkmathi New Member

    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

  12. Madhivanan Moderator

    Good to know you got solution [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  13. vsnreddi New Member

    good keepitup mathi..



    SURYA



Share This Page