Crystal Report Help

[ieesab]

I am using VB 6.0 and access databse. I am having a table with fields like 'apple', 'grapes' , 'orange', 'milk' 'sugar', 'rice', 'potato' etc. One customer purchases apples only. Other customer purchases sugar and milk. And so on. I want to report with Crystal Report. i want to get rid of the empty fields in report. How can i do that so that every customer should have its relevant items. Please help me.

[badbee]

why don't you use cross tab reports?

[ieesab]

cross table query ? i am unable to understand, will you like to give me some example
thanks

[Hack]

How is the data currently being fed to your Crystal Report?

[badbee]

its not a crosstab query, but a crosstab report. check the screenshot attached with it

[ieesab]

Thanks badbee for kind help. However i am unable to open the attached images to get more help. I think that i understand the cross table query it may solve my problem.

[ieesab]

Thanks Hack, i am totally new in Crystal reports. I started the version 10 and connected the database through ODBC. Then i can feed single table data to the CR.