PIVOT Views

[Grah]

Hi Folks,

I need to find out if its possible to Pivot the results from a multiple table view?

we have a view that nornal returns


Col1, Col2, ..... Col10
row1
row2

But for a report they want a view to return

Row1, Row2....
Col1
Col2
...
Col10

And if one more person tells me it can be done in access....

[akkerend]

What tool do you use?

[marist89]

[QUOTE][i]Originally posted by Grah [/i]
[B]And if one more person tells me it can be done in access....
[/B][/QUOTE]
In access, you have to create a query called a crosstab query.

[Grah]

Hi sorry for the delay, Tool we have Oracle 8i and use the standard supplied worksheet.

The idea behind these pivotted views are for reports to run of them. The reports are on Crystal which I have never used