need to duplicate records (rows)

[hoppeli]

Hi all!

I am using CR 8.5 and SQL db (7.0). I have a dilemma as follows: I need to duplicate a detail section, if there is a certain string in a certain field:

detail section now: 008 4 5000 0,00 1234,00

If there is this "008", it means this row should be duplicated and then output should be:

detail section after: 008 5 5000 0,00 1234,00 (just change of that second field from 4 to 5).

How could I make that?

Thanks in advance!

Hoppeli

 

[GJParker]

Try inserting a 2nd detail section by right mouse clicking on details in the grey section to the left of the report canvas -> insert section below.

place the relevant fields in this new section and then use a conditional suppression formula to hide the field if 008 is not present.

right mouse click on details in the grey section -> section expert -> (x-2) to the left of Suppress (No Drill Down) -> enter the formula

{MyTable.Field} <> '008' (replace {MyTable.Field} with your field name

To increment the number on the 2nd field use a formula e.g.

Previous(MyTable.Field2) + 1

HTH


Gary Parker
MIS Data Analyst
Manchester, England

 

[hoppeli]

GJParker, you made my day. I had tried it earlier, but somehow, as being beginner, did not succeed in doing that.

Now I have a solid foundation to continue.

THANKS!

 

[GJParker]

Glad to help.

Gary Parker
MIS Data Analyst
Manchester, England