locked
Row to column conversion RRS feed

  • Question

  • User960994976 posted

    Hi All,

    I am a newbie to crystal reports.

    i have a datatable like,

    State

    City

    KA

    BNG

    KA

    KDM

    PB

    PBB

    PB

    DBC

     

     

    How can i display in crystal report as following.

    KA

    PB

    BNG

    PBB

    KDM

    DBC

    Thanks in advance.

    Friday, July 13, 2012 1:41 AM

All replies

  • User-661350001 posted

    Its very difficult to achieve this in crystal reports please do this SQL server and return the formatte data

    Friday, July 13, 2012 1:46 AM
  • User960994976 posted

    Hi ,

    Thanks for a quick reply.

    On formatting in sql server , it will  return n number of rows and columns. Can u plz tell me how to display it in report.

    Thanks & Regards,

    Sahoo

    Friday, July 13, 2012 1:52 AM