How to multiply records in CR
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1943
Printed Date: 28 Apr 2024 at 10:03am
Topic: How to multiply records in CR
Posted By: kidcarson
Subject: How to multiply records in CR
Date Posted: 28 Dec 2007 at 4:06am
Hi,
can anyone help me by the following issue:
I'd like to print out some stics in CR. I get all the data for each item that I need into CR. One field is quantity - now I would like to print so many detail sections, as quantity (for example if quantity is 13, I need 13 sticks, that looks the same) . How could I do this?
Thanks
|
Replies:
Posted By: BrianBischof
Date Posted: 28 Dec 2007 at 7:01am
You can create a table with just the numbers 1...x (where x is the most sticks you'll ever need to print) and then join this new table to your report. Set the table link to be "less than or equal to" the number. That way, the detail records will get repeated for every record that links to this new table. When you print the report, the details will be repeated as many times as the number in the quantity field.
-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
Posted By: kidcarson
Date Posted: 30 Dec 2007 at 12:43am
|
Thank's, that's a good idea. I'll try it.
|
|