Skip to Content
0
Former Member
Jul 31, 2007 at 02:58 AM

How can we show data in rows when it is in Columns........

18 Views

I have strucked with a simple but a complex problem.

I have a Report with data in vertical rows..need of the hour is how can we show that data into column structure.

here is the table sample which i have in Database..

Location chrg_type Effective_date

xxxxxxx xxxx xx-xx

thhis is the structure in effective date we have several months in it in a single column i want show the effective date or effective month in various columns instead of a single column.

my required table is....

Effective_date Effective_date

Location chrg_type xx-xx xx-xx

xxxxxxx xxxx xx-xx

any tough heads?????