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
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. # 1
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. # 2
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. # 3
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. # 4
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. # 5
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. 3 weeks ago
  2. Report Editor
  3. # 6
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. 3 weeks ago
  2. Report Editor
  3. # 7
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. 3 weeks 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.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories