Row to column conversion

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.

Answer 1

User-661350001 posted

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

Answer 2

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