• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3600
  • Last Modified:

Create Multiple pages in one report

Hi Experts,

I am currently creating a purchase order system for a friend of mine. I have decided to use crystal reports to print the purchase order but have limited knowledge of crystal reports. I am using vb.net 2005 that has crystal reports incorporated into it. I have populated a dataset lets say with the following Columns: -

Company Name, Description, PO_Number, Line, Price

And the following data: -

Covers, Bracket, 1923, 1, £9.99
Covers, Bracket 2, 1923, 2, £10.99
Covers, Bracket 3, 1923, 3, £19.99

Homebase, Paint, 1924, 1, £9.99
Homebase, Brush, 1924, 2, £2.99

What I want to do is create a report that will create 2 purchase orders 1 for the company called Covers and one for the company called Homebase. Once these have been created I want to be able to preview the reports using the crystal report viewer and have the 2 pages to view instead of having to show each individual purchase order in the crystal report browser. Just one report instead of having to run the report twice. I know how to show the whole report in a crystal report browser and have specified the dataset and columns to show on the report just not how to create the individual pages instead of having one page that will show both companies. I hope this has made sense.

Many Thanks
1 Solution
Create a group name using the company name. The company information appears in the group header (& footer, if desired). The individual items are the detail lines. Right-click on the Group Header section title, choose Format Section, and check New Page Before. Now each company will appear on its own page.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now