Print a report columnwise

[prao]

Hi All

I need some help in displaying the data in column. I have a table, which as a column "Position Type", the data stored in this column is "Contract" or "Perm". The data is stored in rows.

Example : Log # Sales Rep Position Type
------ ------------ -----------------
1 XXX Contract
2 XXX Perm
3 ABC Contract
4 XYZ Perm

I need to create a report and display the data in the following order

Sales Rep Contract Perm Total
------------ ----------- ------- ------
XXX 1 1 2
ABC 1 0 1
XYZ 0 1 1
--------------------- -------
Total 2 2 4
=================

Please it is very urgent. I need to come with some result soon. Please help me.

Thanks

 

[Sohaila Taravati]

Use crosstab query

 

[Sohaila Taravati]

Or maybe you made your report through wizard and the wizard set it up for you like that. In that case just move your fields and set them horezontally, that should work to.

-> (Lables)SalesRep Contract Perm Total
-> (Fields) SalesRep ContractNum PermNum Total
I hope that works for you

 

[prao]

Hi Sohaila

Thanks for the reply.

Regarding crosstab, I have not used the crosstab queries.

Regarding the build the report thru wizard. No the wizard did not arranged the column in vertical order. First I created a query with union, the first part of union will be "Contract" total for the Sales Rep and the other part of Union is "Perm" total for the sales Rep.

The query result will look like this

XXX Contract 1
XXX Perm 1
YYY Contract 1
ABC Perm 1

I think you understand what I said. I will apperciate if you can help me.

Thanks
Prao

 

[Sohaila Taravati]

You definitly have to use crosstab query. When you try to creat a new query, there are options you can choose from. Choose the crosstab and the wizard will takc you through the steps and you will see what I am talking about. There is a very good example in Northwind database on your machine that you can use.