1. Cecilio
  2. Report Editor
  3. Wednesday, November 22 2017, 07:51 AM
  4.  Subscribe via email
I try to create inventory labels with a stock field.
(use report, not family labels)

I have 2 difficulties:
1st my report only prints 4 columns.
2nd I want to create a label for each unit of the stock field.

Example:
Article Id: 20 Name: aaaaa Stock: 5 (create 5 labels)
Article Id: 21 Name: bbbbb Stock: 4 (create 4 labels)

Thanks for the help.
Attachments (2)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Also, auto_size must be unchecked for the Page Body region, so the empty parts wouldn't be skipped.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Sergey Pashkov Accepted Answer
Hello,

1) Create a new paper format 80 mm width, height will be ignored, margins are 0
2) Create a new report (not a label for now) and select the paper format for it
3) Change the height of the Page Body region to 40 mm
4) Check ignore_pagination property for the report
5) Select the Page Body region and set the bottom margin to 3
Attachments (4)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
PBI Accepted Answer
hi,
I switched to version 10.4.22 of Valentina Studio hoping that the problems with creating reports for printing labels would be solved but I still have several difficulties with Valentina Studio and Valentina Report for XOJO :(

First Problem:

I have to print on roll labels with the dimensions shown in the image, how should I set the parameters?

thank you
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Sergey Pashkov Accepted Answer
It's a simplified version of the report, it prints labels from top to the bottom, too.

- only Page Body region is available
- Page Body has "size" property - the size of the resulting label
- there is no "columns" property - it fits as many columns as possible

Not too many differences, so ordinary report can be used.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
Cecilio Accepted Answer
Okay. I see that there is a component called "Label". How is it used, does it have a tutorial?

I used "Report" to create the labels with 6 columns.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 5
Sergey Pashkov Accepted Answer
It's always from top to the bottom, and it is not easy to change.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 6
Cecilio Accepted Answer
Hi Sergey.

In point 1:
Can the labels go from left to right and NOT from top to bottom?
Now (top to bottom):
1 2 3
1 2 3
1 2 3
From left to right:
1 1 1
2 2 2
3 3 3

In point 2:
I am generating sql query. Thank you.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 7
Sergey Pashkov Accepted Answer
Hi Cecilio,

1) Do you have enough records returned by the query? On all pages 4 columns?

2) It can only be done on the SQL/datasource side.

For example, you can dynamically create a query in code:
( SELECT 20 AS ArticleId, 'aaaaa' AS Name ) UNION ALL ( SELECT 20 AS ArticleId, 'aaaaa' AS Name ) UNION ALL ( SELECT 21 AS ArticleId, 'bbbbb' AS Name )

But the query will be very long.

Also, you can create a SQL function which creates a local temporary table (it is alive during the connection) with the necessary number of labels for each article id.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.