hi,
i have a peculiar problem. I have created a vb application which is used for printing bills using crystal report 8.5. The problem is in one bill we have many items, their rate and amount. When i m giving the print command, it prints the ascending record from the recordset. For ex;

for Invoiceno: B1001
particulars rate quantity amount
chairs 100 20 2000
tables 200 20 4000

grandtotal - 6000


This is the way it shud print the bill, but it is printing


Invoiceno: B1001
particulars rate quantity amount
chairs 100 20 2000


grand total- 6000


rest of it is printed on next page. i have msflexgrid for the frontend design.

guys plz help how to club the records in one page. is there any code for it, or we change some features in the crystal records.