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.
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.
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.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Check the properties of the groups on the report. You probably have something like 'start new page' selected for each record/group.
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
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
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
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
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
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
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
@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.
Get the updated Crystal Report file
crptVendorPO1.rpt
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.
Get the updated Crystal Report file crptVendorPO1.rpt
Premium Content
You need an Expert Office subscription to comment.Start Free Trial