cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report 13.0.2000.0+VB 2010 - Print n times same record

Former Member
0 Kudos

Hello experts,

give you an example:

I have a table with one field and two record and the field values are "DOG" and "CAT".

I would like to create a report that will allow me to decide how many times repeat the value found.

example 1 (3 TIMES DOG AND 2 TIMES CAT):

DOG

DOG

DOG

CAT

CAT

example 2 (ONCE DOG AND 6 TIMES CAT):

DOG

CAT

CAT

CAT

CAT

CAT

CAT

It's possible to do this at runtime using VB 2010 code or crystal report function?

Now the report is:

DOG

CAT

Thanks in advance.

Edited by: Actarus_1975 on Aug 9, 2011 5:49 PM

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

I found the solution here :

Thanks

Former Member
0 Kudos

Thanks for replay Debi but i don't understand

Former Member
0 Kudos

select the field in the detail line and create a group on the field; then select the field in the detail line again, right click and insert a summary in the group footer. tell the summary to count

OR

create a cross-tab with the field as the rows, then put the field in the summarized fields and tell it to count them.

Former Member
0 Kudos

Hello Don,

i can write number of times per field on database.

NAME #TIMES

DOG 3

CAT 6

What is the best method for you?

YOU COULD GIVE ME A SAMPLE CODE?

Former Member
0 Kudos

Group on the field and insert a summary on the field to count them.

Debi

0 Kudos

Hello,

I've moved your question to the Report Design Forum. Once it's done in the designer you can take the same steps in code using RAS.

Question, how or what is going to determine or prompt for the number of times the records duplicate?

Don