separate records printing 关注

0
Avatar
Nuno Ferreira

I want to print labels by accessing an excel file.
but I do not want to print all the records.
I'd expect the bartender to go through 25 lines and print the label.
line 25, line 50, line 75 and so on.

Label1:

object1:(grab 1º cell)    to   object2:(grab24º cell)  

label2:

object1:(grab 25º cell)    to   object2:(grab49º cell)

 

label3:

object1:(grab 50º cell)   to    object2:(grab74º cell)

and so on...

I want to automate this since I have files of 10 000 lines.
Can anyone give me an idea, please?
I have already checked sql commands to put in the bartender's filter.
I've tried playing with the supression and offset, but not working.

 

6 评论

0
Avatar
Peter Thane

This may help:

Create your page size the correct size but then make your label size 1/25th of the page.

Add the appropriate database fields onto the small label now displayed. 

If you have any fields that you want to appear only on the top of the page, then you will need to add a counter field and use some suppression.

  1.  Add a field off to the side of the label with a value of 1, give it a name via the Change Data Source Name button and then in the Transforms make the field serialised incrementing field that resets when the total reaches 25.
  2. For the fields at the top of the page then add these on and then use the Transforms>Suppression>Suppress when the following expression is True option and configure it be suppressed unless the named data source in point 1 above is equal to 1.
  3. For any fields at the bottom of the page then repeat the process but the set the suppression expression to unless that field equals 25

If the File>Print Queried records is set to All then at print time the whole database will be printed but with 25 records per page.

 

0
Avatar
Nuno Ferreira

Hi Peter. Maybe I'm not explaining what I mean.I do not want 25 labels per page, I plan to pick up Cell  1 and 25, 26 and 75, 76 and 100 and so on.

Below is a link to box.com where I thank you for downloading because I have there my excel and a pdf with image of what I intend ...

The numbering although it seems, is not sequential, so I have to grab the specific cells, in this case multiples of 25.

I hope you can help me in this dilemma, I also have some difficulties in the syntax of vbscript embedded in the bartender, as it is not a native vbscript.Where can I find some manual or similar that can clarify me about the syntax?I hope you can help me, because maybe my problem may be the problem of many here.Many thanks Peter

My link:

https://app.box.com/s/qg7vadh6ebjat6nnx0zjyl6ilcpd04wi

 

0
Avatar
Peter Thane

Sorry that is beyond my limited VB knowledge.

I am fairly certain it can be achieved but I am not sure what the exact code will be. 

0
Avatar
Nuno Ferreira

 
No problem, thank you anyway Peter.
Do you know of any manual or tutorial where I can learn more about vbscript in bartender?
 
Many thanks
 
 
0
Avatar
Peter Thane

No I dont think anything like that exists. Most of my VB has been self taught or from the Help menu notes as well as looking for practical examples of using specific commands from the internet. 

If you know or can find someone who programs in VB I am sure they could help you quite quickly.

0
Avatar
Nuno Ferreira

OK. Thanks anyway Peter.

 

请先登录再写评论。