Could anyone make a suggestion as to how to correctly produce a view for a crosstab report? I can't find any way to "pivot" the results, and have only been able to produce rows based on rollup etc, which then requires rather complicated code to manually pivot the results for output to a html table.

For example, I have the following in one table, AFLPrice:

Team Bookmaker Price
========================
Geelong IAS 1.45
Geelong SBA 1.50
Geelong GSB 1.47
Melbourne IAS 2.35
Melbourne SBA 2.20
Melbourne GSB 2.25

I need to express this in a view with output:

Team IAS SBA GSB
===============================
Geelong 1.45 1.50 1.47
Melbourne 2.35 2.20 2.25

Note that I do not know in advance how many Bookmakers I will have, nor therefore how many columns in the final crosstab.

I didn't think this would be such a challenge, but I just can't seem to get this type of view successfully.

If you have any suggestion for me, I would most appreciate it!


MTIA, Max Hugen

Hugen Enterprises Pty Ltd
207 Flood St, Leichhardt NSW 2040, Australia
Tel: 02 9560 3061
http://www.hugen.com.au