Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Have the Details of a Label report print x times.
- Thread starter rwn
- Start date
rwn,
You may want to post a bit more detail as to what your situation is. You need to print 10x of the same label, you need the Job # 10x times per label, you need...?
Please clarify, and hopefully someone can lend you a hand.
Cheers!
Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
You may want to post a bit more detail as to what your situation is. You need to print 10x of the same label, you need the Job # 10x times per label, you need...?
Please clarify, and hopefully someone can lend you a hand.
Cheers!
Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
- Thread starter
- #3
A Job Number is to be shown on a label report, the Job Number needs to be displayed 10 x on the page (thu8s 10 labels). So the size of the label is ~ 4 Wide x 2.5 High. So I need to have the Job be shown 10 times on meaning 10 labels.. I hope that helps!
rwn,
The only way that I know how to do this in Crystal Reports is to go into the Selection Expert and "Format with Multiple Columns", the you would need to play with the layout of your report until you fine-tuned it to print to your specific label layout (presumably, 2x columns of 5 labels). Your details (or visible) section would also then need to be formatted to the the appropriate height and white space added as needed to have the labels print properly/start in the correct positioning. Not sure if there is anything simpler than this approach, but I could not see a place to select a specific label layout in the printer settings in Crystal reports.
I know you have made this request in the Crystal Reports forum, and thus gave the above suggestion... if I may step outside the bounds of this specific forum for a moment, I would ask -- why would you not just use Crystal Reports to generate a CSV to import into an MS Word (or other word processing program) which allows for much easier handling of label work such as this? Further, if no manipulation of the datasource is needed by Crystal Reports to print the labels (asusming you were to use the original approach), you could bypass crystal altogether and hook MS Word (or other WP) directly to your datasource and print the labels by that means and bypass all the special formatting in CR. Just an idea to consider, as if manually formatting the label layout is the only option, it could be a bit tedious and perhaps not look/fit as well as using a program with tools built in to handle special printing scenarios.
Hope this helps (one way or the other), please advise should you have any further questions or concerns.
Cheers!
Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
The only way that I know how to do this in Crystal Reports is to go into the Selection Expert and "Format with Multiple Columns", the you would need to play with the layout of your report until you fine-tuned it to print to your specific label layout (presumably, 2x columns of 5 labels). Your details (or visible) section would also then need to be formatted to the the appropriate height and white space added as needed to have the labels print properly/start in the correct positioning. Not sure if there is anything simpler than this approach, but I could not see a place to select a specific label layout in the printer settings in Crystal reports.
I know you have made this request in the Crystal Reports forum, and thus gave the above suggestion... if I may step outside the bounds of this specific forum for a moment, I would ask -- why would you not just use Crystal Reports to generate a CSV to import into an MS Word (or other word processing program) which allows for much easier handling of label work such as this? Further, if no manipulation of the datasource is needed by Crystal Reports to print the labels (asusming you were to use the original approach), you could bypass crystal altogether and hook MS Word (or other WP) directly to your datasource and print the labels by that means and bypass all the special formatting in CR. Just an idea to consider, as if manually formatting the label layout is the only option, it could be a bit tedious and perhaps not look/fit as well as using a program with tools built in to handle special printing scenarios.
Hope this helps (one way or the other), please advise should you have any further questions or concerns.
Cheers!
Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question