We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
2 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Create Invoice in Crystal Report using C#.net
Posted on 2012-12-23
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
- +1
8 Comments
Active today
Check the properties of the groups on the report. You probably have something like 'start new page' selected for each record/group.
Active today
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
Active 7 days ago
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
Active today
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
Active 7 days ago
@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
Featured Post
From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.
You need xMatters.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This document covers how to connect to SQL Server and browse its contents. It is meant for those new to Visual Studio and/or working with Microsoft SQL Server. It is not a guide to building SQL Server database connections in your code. This is mo…
This article is for Object-Oriented Programming (OOP) beginners.
An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Course of the Month2 days, 19 hours left to enroll
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.