using mailing label expert

[ArnaudAbadie]

I am using Crystal Reports 8.5.
I'am trying to mailing label report that takes a user input number of copies, and prints each record that many times in a row.
If the user inputs 3, I want to print 3 of the first mailing
label. Can I do this in Crystal?

 

[kenhamady]

See the following newsletter for the different techniques for forcing duplicates.

http://www.kenhamady.com/news0111.html

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[ArnaudAbadie]

Thanks Instructor but I can't do it that way. It's not good programming
What I had in my mind was doing it via formula or parameter.
Simply specifying the number of iteration for my report label detail.

Any other idea would be welcome

Thanks in advance

 

[kenhamady]

Unfortunately, Crystal doesn't have an automatic iteration of a detail feature. The only way to do this within the report is to use one of the two techniques mentioned in my article.

Of course, since you are a programmer, you could simply create a recordset with the appropriate number of duplicate records and pass them to the report.





Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[ArnaudAbadie]

I finally found a solution by inserting a subreport (my label).
It works perfectally now .
Thks for help

Regards
Arnaud

 

[kenhamady]

I am curious. How do you control the number of times that the subreport appears?

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[JMcVeigh]

Hi
I am running into the same sort of thing...I am using a table that has one instance of a record, but I need to set up a parameter for the number of copies that are needed.

Can you share how you got yours to work?
Thanks!

 

[kenhamady]

There are several techniques outlined in an article on my website. see:

http://www.kenhamady.com/news0111.html

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[JMcVeigh]

Thanks for the tips, but I don't have the option of creating a table.
any other ideas?

 

[kenhamady]

If you have an existing table of any kind that has a numeric key, you might be able to pirate that table for this report to serve as the inflation table.

Or you could use the first technique mentioned in the article, which involves conditionally suppressed sections.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com