Generate a table from DB SQL Server
Hello everyone,
I need to generate on a BarTender label a table consisting of two columns: in the first column I will have an image while the second will be the description of the image. I managed to generate the table connected to the database but I can't filter by the product code that is printed in the label. How can i do it?
thanks
-
In the Database Connection Setup there is a filter option and from there you can configure the database lookup/query prompt to perform the selection for you.
0 -
Hi Peter,
in the filter section of the database connection configurator I don't know how to write the filter correctly. Bartender proposes me the list of values from the table, while I would like to have the value of txtCode (which is my value that I get from a text present on the layout). Is it possible to possibly filter based on a column in a datagridview for product selection?
0 -
Link the label to the database and then add the fields to your label from the database into your grid. In the Database setup then configure the filter to perform the lookup on the table and field that will contain the value you are entering.
If you use a Data Entry Form you can add a Text Input Box and link that to your database query/filter from the Linked Data Source option
0 -
Hi Peter,
I have tried to follow your suggestions without success. I created a new connection to the SQL Server table I need (for convenience I will call it A). Bartender automatically generated a join between databases for me (this goes to increase the number of products I have in the selector based on the related fields in table A). Unfortunately, the table I get is not being populated.
I will try to better explain the situation and the result I need.
I have a product view where a product row is related to many rows in table A. The table consists of 3 fields: codeProduct (I need it to relate products and table A), description and image.
I would like to generate a table in which the first column is the description of the image coming from table A, while in the second column I get the image written in A.image and as a filter I would like to use the value codeProduct created to relate a product row with many rows of table A.
Is this feasible?
0 -
Not 100% sure what you are trying to achieve but have you looked at the Records per Item setting in the Database Connection Setup? Not sure if that would help
0 -
The image shows the result I want to achieve. The text fields and barcode come from a SQL Server view. The table where you see description and the image instead must come from a table related via the product code field to the row I selected. The number of rows in the table is variable
1 -
With multiple records on the same label you will need to use the records per item option but you may also need to configure the rest of the data as a Page Template enabled via the Page Setup screens
0
请先登录再写评论。
评论
7 条评论