Solved

Print a number of pages using a variable in Crystal Reports

Posted on 2013-05-22
13
475 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
[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
  • 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
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

 

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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 …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses

734 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