Printing Selected Pages

[jdteichmer]

Thanks in Advance!
I have created a report that is grouped on Customer ID then Account Number. I have created two detail sections each with its own subreport. Each subreport links to the Customer ID and Account Number of the main report and selects records from other tables matching the Main report.

Details Section A has the NewPage After option set

Details Section B has the NewPage After, Reset PageNumber After options set.

I would like to only print the records that generate a certain page count. I am not sure where I can control the print output using TotalPageCount. In addtion (maybe another question) I also would like to have the option to send it to a PDF rather than print.

 

[synapsevampire]

What does "I would like to only print the records that generate a certain page count" mean?

So if you have enough records to make a 6 page report you want it, otherwise you don't any report?

Or are you trying to limit the report to only the first X pages?

Try posting technical information if you know it, such as the Crystal version, database used, how you're executing reports, example data and expected output for better results.

You might use a suppression formula on each section to limit the number of pages by using something like pagenumber > 6, perhaps even basing it on a parameter.

-k

 

[jdteichmer]

Sorry for the lack of information. I hope this will help.

I am using Crystal Reports Version 9. I am interfacing it with version 2.3 of Dataflex.

There are three main tables I use to create the report, one supporting the main report, and one each supporting the sub reports. There are additional tables for each report supplying minor information such as code descriptions.

The main report has key customer information i.e. Account ID, SSN, Address...

The first sub report, which is contained in detail section A, uses a table that contains general account information i.e. account totals, fund totals...

The second sub report, contained in detail section B, uses a table that contains transaction history for the account.

I have Crystal reporting all the customer specific information in the report header. The next area to print is detail section A, which I have built to fill the remaining portion of the first page. I have it set to issue a new page after. Finally detail section B prints, this could be more than one page, depending on the amount of transaction history. After detail section B prints I reset the page number so that the next customer to print will start at page one.

Because of limitation with our mailing service we are forced with sorting these reports by page count, all customers with a two page report (one sheet front and back) must be grouped together; all with three or more must be together(multiple sheets).

I want to be able to set a parameter to tell Crystal to only print those reports that have two pages (one sheet front and back) and then set the parameter to print for those greater than two pages.

Thnaks

 

[synapsevampire]

I guess all you're trying to say is that you need to sort them by the number of pages per customer.

This is a fairly complex piece of business because of the nature of Crystal.

I think that I'd approach this a bit differently, rather than focusing on the number of pages, make multiple passes of the report based on the number of records per each transaction subreport (I believe that to be your page extending culprit here).

This probably means firing a hidden trans subreport early in the main report to learn whether it meets the criteria of 2 pages, or 3-4.

This is an ugly technique, and ultimately I would address this by using something on the database itself.

Hopefully someone here will think of a more clever solution.

-k

 

[Turkbear]

Hi,
Is it necessary to actually mail the report to the users instead of sending them a link to the report which they can then run on their own?

 

[jdteichmer]

I will look into how I can sort this out in the database and add a field if I can. I had thought of this as a last resort, hoping Crystal would provide a simpler way.

Turkbear, eventually this is where we want to go. We are looking for solutions to email each customer there report as a PDF attachment as well as provide a location where they can either, run the report on demand, or download a report already created as a PDF.

I am new to Crystal Reports and will take any advice on direction for doing this.

thanks again!