Crystal Reports XI Labels

[lakshhari]

Hi,

I'm new to Crystal XI and I have a need wherein I am accessing a date field from a table and I want this date to be printed as labels based on the number of copies that the user enters as a parameter. Sometimes they may just need 10 labels and sometimes maybe 2000.

Is there a way to do this using the Mail label wizard. I checked the forums here but couldnt find anything that matched my requirement.

I'd appreciate some tips to do this.

Thanks!

 

[Madawc]

I think the only method is to have the detail line repeated several times, suppressing the higher occurences based on the parameter. I've not used the Mail wizard.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lakshhari]

i tried that and it is cumbersome. I would like to use the Mail label Wizard out of crystal to do this. If anyone has any idea how to do this, please reply.

Thanks!

 

[dgillz]

It is not possible with the mail wizard to get X number of labels. Your report needs to purposely create row inflation as Madawc says, then you conditionally suppress labels based on the recordnumber>{?NoOfLabels}

It is not cumbersome, if you already have the label you can do the rest in 5 minutes.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lakshhari]

Thanks Madawc and dgillz.

I'll try that again.

 

[chelseatech]

There is another solution using a Counter table.
You need a table in your report with a single numberic field with values of 1,2,3,4,.... up to as many as you would ever need.
Put the table in your report, but DONT join it in. Select from that counter table for {Counter.Key} <= {?No of Labels}
That will join to multiple records, create a cartesian join, which normally isn't allowed, but will create the number of labels you need.
I've used the same table in a similar way with a <= join to a record with a lable count field. That will create different numbers of lables for each master record.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm