I have tom ake a report with data from one table giving some information about something (general information) but beside of that we have events on this main item. If I make a normal report I can list de main information in a row and just under that row de events. The number of events is unknwon.

I would have a layout like this

TaskNr.        Description                        Creation Date
Taks 1          Test Reporting Services        10/06/2008
   Event 1     Started
   Event 2     Interupted
   Event 3     closed
Task 2          Another test                        11/06/2008
   Event 1    Started
Task 3    .....

etc....

But this is not the way I want the report. It should have the following layout

TaskNr.        Description                        Creation Date    Event 1    Event 2        Event 3 ....
Taks 1          Test Reporting Services       10/06/2008          Started    Interupted      Closed
Task 2          Another test                        11/06/2008         Started
Taks 3

As you can see the collums of the reports are not fixed but are depending of the events I get for a task. It is possible that I have 15 events, so there should be 15 additional collums (Event 1 up to event 15).

I hope I succeded to explain what I want

Another example would be the following.
I have products in a product table, in another tabel I have a record for each delivery of that product whit a delivery date and a quantity.
If I want to create a report which tells me when and how much of each product was delevered for a give period then it should look like this:

Produc Nr.    Description    01/06/2008    18/06/2008    14/06/2008    etc....
1254            product 1                5                                     8
1589            Product 2                                12
etc...

Can anyone help me?

Thanks