Printable View
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.
why don't you use cross tab reports?
cross table query ? i am unable to understand, will you like to give me some example
thanks
How is the data currently being fed to your Crystal Report?
its not a crosstab query, but a crosstab report. check the screenshot attached with it
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.
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.