locked
display horizontally RRS feed

  • Question

  • User-1075092149 posted

    i would like to ask about how to display the detail value horizontally.

    that mean i have field_1 wheich contains "1","2","3"

    how can i display as belows:

    field_1 : "1"    "2"    "3"

     

    instead of displaying vertically as normal before

    Friday, September 9, 2011 12:15 AM

All replies

  • User1135668169 posted

    Hi,

    use the following query, which will show the data in horizontally.

    SELECT DISTINCT 

    STUFF((SELECT ',' + cast(empid AS VARCHAR) FROM employee
    FOR XML PATH('')),1,1,'') AS Tmp
    FROM employee AS A

    Friday, September 9, 2011 1:13 AM
  • User-1075092149 posted

    Hi,

    use the following query, which will show the data in horizontally.

    SELECT DISTINCT 

    STUFF((SELECT ',' + cast(empid AS VARCHAR) FROM employee
    FOR XML PATH('')),1,1,'') AS Tmp
    FROM employee AS A

     

    can crystal report set to display horizontally

    Friday, September 9, 2011 2:18 AM
  • User1135668169 posted

    No i don't have any idea about crystal report, but you can post the same in "Crystal Forum".

    Friday, September 9, 2011 2:36 AM
  • User-1075092149 posted

    No i don't have any idea about crystal report, but you can post the same in "Crystal Forum".

     

    where is crystal forum?

    Friday, September 9, 2011 4:07 AM
  • User-1075092149 posted

    No i don't have any idea about crystal report, but you can post the same in "Crystal Forum".

     

    where is crystal forum?

    Friday, September 9, 2011 4:07 AM
  • User-1075092149 posted

    No i don't have any idea about crystal report, but you can post the same in "Crystal Forum".

     

    where is crystal forum?

    Friday, September 9, 2011 4:07 AM