Create Invoice in Crystal Report using C#.net

Manoj Patil
Manoj Patil used Ask the Experts™
on
I am having a problem with showing crystal report
I am getting records like following
PurchaseOrderNumber   MaterialName   Rate   Quantity
             0001                     ABC                  10        100
             0001                     PQR                  20        4300
             0001                     XYZ                   30        450

When I am trying to display it on Crystal Report it shows me,
single record on one Page means

             0001                     ABC                  10        100

2nd record on another Page

             0001                     PQR                  20        4300

3rd record on third Page
             0001                     XYZ                   30        450


I want to display it on the same page. How to do it.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AndyAinscowFreelance programmer / Consultant

Commented:
Check the properties of the groups on  the report.  You probably have something like 'start new page' selected for each record/group.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Where did yoi put the fields?

Did you put them in the page header rather than the details?

How is you report designed?
Do you have a group on the invoice?

mlmcc
Manoj PatilSr. Software Engineer

Author

Commented:
Check this attached Report
I have added it in Details section. And also checked my query which returns 3 rows

Manoj Baburao Patil      Jayamala Nagar, Sangvi      TIN777      00001      Jul 29 2012 12:00AM      asdasd      7/29/2012 3:25:00 AM      asdasd      13      12      156      NULL      6

Manoj Baburao Patil      Jayamala Nagar, Sangvi      TIN777      00001      Jul 29 2012 12:00AM      asdasd      7/29/2012 3:25:00 AM      saddgdfg      12      13      156      NULL      23

Manoj Baburao Patil      Jayamala Nagar, Sangvi      TIN777      00001      Jul 29 2012 12:00AM      afasd      7/29/2012 3:25:00 AM      NULL      10      5      50      NULL      15

crptVendorPO1.rpt
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
The problem is you made the detail section so large.  The entire detail section is printed for each record.

The attached report is probably closer to what you want

mlmcc
crptVendorPO1-1-.rpt
Hi,

All you need to do is go to the Section expert, then go to Paging Tab. Select the detail section and then uncheck the "New Page after". Then click OK. Just like on the print screen in my attachment.

Please let me know if anything.

Regards,
Igor
crystal-reports-seccion-expert.jpg
Manoj PatilSr. Software Engineer

Author

Commented:
@mlmcc
Thanks for reply,
I am getting something more than what I want. Check the output
The Vendor details are displaying with the number of records.
Report OutputGet the updated Crystal Report file
crptVendorPO1.rpt
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
You need to move the common information to the group header.

mlmcc
crptVendorPO1.rpt
Manoj PatilSr. Software Engineer

Author

Commented:
Really Thanks for your efforts.
You have save my time.
Thanks again.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial