Page 1 of 1
Using DataBand CountData property
Posted: Wed Jun 11, 2014 2:31 pm
by 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.
Re: Using DataBand CountData property
Posted: Wed Jun 11, 2014 3:11 pm
by Jennypi
One more information: the number of plants and of fruits per line is always the same: 6 plants and 5 fruits for all.
Re: Using DataBand CountData property
Posted: Thu Jun 12, 2014 7:07 am
by HighAley
Hello.
Could you send us right data. There is only one Line1. Where do you get Friut1 and Fruit2?
Thank you.
Re: Using DataBand CountData property
Posted: Thu Jun 12, 2014 7:11 am
by Jennypi
Here it is.
I need one label per plant and fruit ->30 labels per line (6 plants * 5 fruits)
Thank you!
Re: Using DataBand CountData property
Posted: Thu Jun 12, 2014 10:03 am
by Alex K.
Hello,
Can you please send us a sample how it should look like.
Thank you.
Re: Using DataBand CountData property
Posted: Thu Jun 12, 2014 10:44 am
by 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.
Re: Using DataBand CountData property
Posted: Thu Jun 12, 2014 11:29 am
by Alex K.
Hello,
Ok. Let us know if you have any additional question.
Thank you.