Hello.

I have a ordinary (no cross-over) report in which I need to have the information on one row.
At the moment I have a report where the information is on four different rows.

For example:


Purchase order: 1A
Turnover              100000
All Costs                                 50000
Margin                                                 50000
Margin %                                                             50 %


The result should be that all of the info above should be on one row like this:


                                  Turnover    Costs        Margin        Margin %
Purchase order:1A    100000        50000        50000        50 %



The information to this report comes from a one field. This field returns data from many different tables.

The whole information consists like this:

Income
Financial income
Turnover
Project costs
Subcontracts
All Costs
Margin
Margin %

I don't want in my report any other information than Turnover, All costs, Margin and Margin %.

Does anyone have good tips for me how should I proceed?