1. Dale
  2. Valentina Studio
  3. Friday, December 07 2018, 07:10 AM
  4.  Subscribe via email
Hi,

I created a label to print qr code from a receiving list. This receiving list has quantity of items received. From there, I need to print the number of qr codes per item. For example, I have the following;

Items Quantity
------- ------------
Item A 15
Item B 10
Item C 25

Although I only have 3 items, I need to print 50 qr codes total (15 for item a, 10 for item b and 25 for item c). How to do this on Valentina Studio Pro?
Comment
There are no comments made yet.
Dale Accepted Answer
Sergey, should this offers further info, here's the structure of the source table:

CREATE TABLE `purrrdetails` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`RRHeaderID` int(11) NOT NULL COMMENT 'Taken fron bw.PurRR\nHeader.ID',
`InvItemID` int(11) NOT NULL COMMENT 'Taken fron bw.InvItems.ID\n',
`UnitID` int(11) DEFAULT NULL COMMENT 'Taken fron cw.Units.ID\n',
`PackingID` int(11) DEFAULT NULL COMMENT 'Taken fron cw.Units.ID\n',
`UnitCost` decimal(12,2) DEFAULT NULL,
`Qty` decimal(12,4) NOT NULL DEFAULT '1.0000',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Receiving Report composition';

Thank you.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 21
Dale Accepted Answer
The quantities are entered from a Xojo app and they are stored in a mysql table.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 22
Sergey Pashkov Accepted Answer
You're generating reports from Xojo, right? Maybe (for the start) it will be simpler to populate the intermediate table in Xojo code.
Also, how do you get the quantities for each item? I'll try to create an example to do this task entirely in the Valentina Studio.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 23
Dale Accepted Answer
Uhmmm... I don't know if this is the right avenue to ask for help but I am not good in DB handling. I would be glad if you can point me to a sample stored proc that populates a temporary table from a field value of another table?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 24
Sergey Pashkov Accepted Answer
Hello Dale,

Looks like the only way to do it is to use a stored procedure and a temporary table:
1) Stored procedure fills the temporary table with records - one record for each label
2) The report is printed from this temporary table
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 25
  • Page :
  • 1
  • 2


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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories