Doubt in Crystal Report Design

[elaya]

Hi,
im using crystal reports 9 , MS Access 97 and VB 6.
Is it possible to retrieve a column in the table to a row in the report?

[Malim]

Are you asking is it possible to create a crosstab query in crystal reports? If so, then yes. If that's what you are trying to do, and you are using Access 97, the easiest thing for you to do would be to use the crosstab query wizard in Access to create a crosstab query, then set the query as your record source.

[phrajib]

You can make crosstab in Access by using TRANSFORM and PIVOT. Read it from books. it will help you.

Example:

item quantity date

i1 20 15/05/03
i2 15 15/05/03
i1 25 16/05/03
i1 10 15/05/03


Query:

TRANSFORM sum(quantity)
select item
from table1
group by item
PIVOT Date


Result:

item 15/05/03 16/05/03

i1 30 25
i2 15 00


Wishing you best of luck .

Rajib