Solved

Print a number of pages using a variable in Crystal Reports

Posted on 2013-05-22
13
398 Views
Last Modified: 2013-09-02
The user will know how many copies they will need of the report.  The issue is that they are not exact copies.  Only the page footer is different.  For example if there are 5 pages they should have on it in the footer "Page 1 of 5" through "Page 5 of 5".   How can I use a variable to get the report to print that many pages with the correct footer?

Thank you.
0
Comment
Question by:MrWeen
  • 6
  • 5
13 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39187462
There is the Page N of M object you can use.

How are you printing multiple copies?

mlmcc
0
 

Author Comment

by:MrWeen
ID: 39188923
That is the question.  The user will know the amount needed.  So if for example the user wants 5 copies they will enter in 5 for a variable.  How do I get that variable to print the number of pages that I want?

Thank you.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39189089
SO the pages is not the number of pages in the report but the number of copies?

How are you controlling the number of copies?

mlmcc
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:MrWeen
ID: 39193069
Yes.  It will always only be one page.  The # of copies of it is what I want to control and that each copy will see what # of how many copies it is.  E.G.  1 of 10, 2 of 10, 3 of 10 etc. for ten copies.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39193088
How are you getting Crystal to print the copies?

If you are doing it through the print control you can't do it.

mlmcc
0
 

Author Comment

by:MrWeen
ID: 39205715
Sorry for the late response.  I don't think I am explaining what I want properly.  When I say copies I mean the number of pages that will print.  So really I want the variable to print the detail section x amount of times once on each page.  Each page will be exactly the same except the footer which will say page 1 of x.  Does this make sense?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39206075
I fully understand what you want.

I know you can print multiple copies through the print control but you really need Crystal to specify the number of copies.

How many copies might be specified?
1, 5, 10, 1000?

mlmcc
0
 

Author Comment

by:MrWeen
ID: 39206417
There would never be more than 20 needed.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 500 total points
ID: 39206433
Does the report have a subreport?
If not you could create a master container report that has 20 report header sections each with its own copy of the report.
Each report could be modified to show the appropriate footer. or use the N of M page option.

You could then use conditional suppression to suppress the "extra" copies

PageNumber >= {?NumberofCopies}

mlmcc
0
 

Author Comment

by:MrWeen
ID: 39216724
I was hoping for something a little cleaner and simpler.  Is there no way to make the detail section loop depending on the variable?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39216770
You could create a table in the database with the values 1-100

You then select from it based on the value  {?NumCopies} >= {COlumnValue}

The cross join will create N records allowing you to print that many copies.


mlmcc
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

775 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question