This is probably simple to do

[EscapeUK]

I have a table of compaines and a table of item descriptions and a table of sales.

I would like to create a reports that shows the compaines listed along the top and the times listed down the side and the values inseerted.

It should look a bit like this.


item company1 company2 company3 company 5 total

bolts £100 £50 £150
nuts £30 £30 £30
wood £10 £10

total £140 £30 £50 £190

Please could someone provide me with very basic and simple instructions.

Thanks

 

[phirst]

Use the crosstab expert.
Select your 3 tables.
Put the item name in the rows, the company name in the columns and the sales values in the summarized fields.
If your version of SCR has crosstabs...

 

[emallon]

What your looking at here is developing a 'Cross-Tab' Report.
1) Start a new report and select 'Cross-Tab' type.
Make sure you use the 'Report Wizard'.
2) Select the tables you will use in the Data Tab. Next.
3) Link the tables in the Link Tab. Next.
4) On the Cross-Tab tab you will place the fields you want on your report by dragging them to the 'Row' or 'Column' boxes. So you would put 'Companies' in the columns area,
'Items' in the rows area and 'Sales' in the summarized fields box.

The last four tabs are for customizing the appearance of the report and filtering your data.

Start with this.