Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: How to multiply records in CR Post Reply Post New Topic
Author Message
kidcarson
Newbie
Newbie


Joined: 28 Dec 2007
Online Status: Offline
Posts: 2
Quote kidcarson Replybullet Topic: How to multiply records in CR
    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

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
kidcarson
Newbie
Newbie


Joined: 28 Dec 2007
Online Status: Offline
Posts: 2
Quote kidcarson Replybullet Posted: 30 Dec 2007 at 12:43am
Thank's, that's a good idea. I'll try it. 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.