Is this (im)possible? Cant figure out...

[Balder]

Hallo All,

I hope this is this correct forum for this topic...

I have a table with Company, Quantity, date, YearMonth (and a lot of other fields...)

Yearmonth is a calculated field.

Example:

Company|Quantity|Date......|YearMonth

-------------------------------------------------

A......|.....150|17.01.2006|2006-01

B......|..... 50|18.01.2006|2006-01

B......|..... 10|25.02.2006|2006-02

A......|.....350|30.01.2006|2006-01

A......|.....220|20.02.2006|2006-02

C......|......80|12.03.2006|2006-03

Now i need to create a report showing the cummulative data of timeframe 2006-01...2006-02 (so a subset of the records)

Of course that is a simple selection and then run a report showing the data.

But how to proceed using Internet Web Publishing?

(As IWP is not supporting reports...)

The report should look like:

...........A|.B

----------------------------------------

2006-01 |500|50

2006-02 |220|10

----------------------------------------

.........720|60

I tried to figure this out but without success.

Remark Number of records appr. 50.000

So loops via IWP etc are no real option.

Number of unique companies appr. 50 and growing...

Your help is appreciated!

All the best for 2007 from The Netherlands