Using DataBand CountData property

[Jennypi]

Hello,

I have an Excel file like this:

Code: Select all

LINE#  PLANTS  FRUITS
Line1  3            2
Line2  2            3

And I would like to print labels like this:
Line1
Plant1
Fruit1

Line1
Plant1
Fruit2

Line1
Plant2
Fruit1

etc.

How can I do that?
Can you provide me with an example?

Thank you.

[Jennypi]

One more information: the number of plants and of fruits per line is always the same: 6 plants and 5 fruits for all.

[HighAley]

Hello.

Could you send us right data. There is only one Line1. Where do you get Friut1 and Fruit2?

Thank you.

[Jennypi]

Here it is.
I need one label per plant and fruit ->30 labels per line (6 plants * 5 fruits)

Thank you!

[Alex K.]

Hello,

Can you please send us a sample how it should look like.

Thank you.

[Jennypi]

I found how to solve my problem with a short script in the After print event:

Code: Select all

fruit=fruit+1;
if (fruit>5)
{plant=plant+1;
fruit=1;}
if (plant>6)
{plant=1;
fruit=1;}
[code]

Thanks.

[Alex K.]

Hello,

Ok. Let us know if you have any additional question.

Thank you.