Repeat records depends of value
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22323
Printed Date: 02 May 2024 at 4:32am
Topic: Repeat records depends of value
Posted By: makis_best
Subject: Repeat records depends of value
Date Posted: 05 Jun 2017 at 10:10pm
Hi
I use crystal reports XI
I try with no success to repeat the detail section as many times as a value of a field.
My dataset gives me a field with a number.... let say the number 4
I want the detail section repeat him self 4 times with all the info i have in detail section.
For example.
If the detail section have had to print the info "11002 - My offer for it is"
then I want to return 4 times the same detail with the number like
11002 - My offer for it is 1
11002 - My offer for it is 2
11002 - My offer for it is 3
11002 - My offer for it is 4
How I can do it.
Thank you for your help.
|
Replies:
Posted By: lockwelle
Date Posted: 23 Jun 2017 at 8:26am
us a number table to join to your query. Join on all values <= to field that you need.
a number table is table that looks like:
1
2
3
.
.
.
n
|
|