Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted

Hai
Crystal report have followin sections

Crystal Reports by default provides five main sections:
Report Header – fields placed in this section are printed once, at the beginning of the report
Page Header - fields placed in this section are printed at the beginning of each new page
Details – fields in this section are printed with each new record
Report Footer - fields placed in this section are printed once, at the end of the report
Page Footer - fields placed in this section are printed at the bottom of each new page


In Details or Report Footer section u need to check,try to reduce the size,i think in Details section have lot of space in between records,so only print one row in one page.

Try to reduce all section height,like click and drag up
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900