Avatar of Manoj Patil
Manoj Patil
Flag for India asked on

Create Invoice in Crystal Report using C#.net

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.
Crystal Reports.NET ProgrammingC#

Avatar of undefined
Last Comment
Manoj Patil

8/22/2022 - Mon
AndyAinscow

Check the properties of the groups on  the report.  You probably have something like 'start new page' selected for each record/group.
Mike McCracken

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 Patil

ASKER
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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Mike McCracken

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
igordevelop

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 Patil

ASKER
@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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Manoj Patil

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