[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 726
  • Last Modified:

Print a number of pages using a variable in Crystal Reports

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
MrWeen
Asked:
MrWeen
  • 6
  • 5
2 Solutions
 
mlmccCommented:
There is the Page N of M object you can use.

How are you printing multiple copies?

mlmcc
0
 
MrWeenAuthor Commented:
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
 
mlmccCommented:
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
MrWeenAuthor Commented:
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
 
mlmccCommented:
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
 
MrWeenAuthor Commented:
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
 
mlmccCommented:
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
 
MrWeenAuthor Commented:
There would never be more than 20 needed.
0
 
mlmccCommented:
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
 
MrWeenAuthor Commented:
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
 
mlmccCommented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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