Hi ,
i am Stuck on Crystal report .. my problem is i need to Print Purchasing Details using Two tables
1.Customer table
2.Menu Table..
customer table has only one Row, but menu table has More then One Rows and "QNo" is Same for each table ...
i write that below Query
mysql>SELECT a.*,b.* FROM tb_customer a INNER JOIN tb_Menu b ON a.id=b.Qno WHERE Id= 1/1 AND a.id=b.qno GROUP BY menuname
In Crystal report viewer it display but , menu details print only one record per page, next page it print second Record why ? at the same time i used sub report for Menu ,, it will print nicely as what i expected , but the probles is if a Menu has "5" Records menas the whole report will print 5 times ? help me..
I want to Print Like that
Customer Details
Qno: 100
Name :UserName
Address : xxxx
Menu Details
Breakfast
1.Apple Juice
2.Orange Juice
3.Burger
Lunch
1.Bread Omelet
2.Milo