1. Cecilio
  2. Report Editor
  3. Среда, Ноябрь 22 2017, 07:51 AM
  4.  Подписаться через 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.
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
Cecilio Ответ принят
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.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
It's always from top to the bottom, and it is not easy to change.
Комментарий
There are no comments made yet.
Cecilio Ответ принят
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.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
PBI Ответ принят
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
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Also, auto_size must be unchecked for the Page Body region, so the empty parts wouldn't be skipped.
Комментарий
There are no comments made yet.
  • Страница :
  • 1


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