Product: CODESOFT Enterprise
Version: All Versions
|
1. Create a connection to your database via Table Lookup. Under Data sources on the right-hand side, right-click and press Add.
2. You can choose an already existing connection by clicking the drop-down and finding it there, otherwise, you can click New... to make a new connection here as well.
3. Once you have your database selected, click the radio button to select SQL where you can add this custom statement allowing for all of your fields and rows to be brought in:
SELECT * FROM [Sheet1$] AS Sheet1_
SELECT * FROM [Sheet1$] AS Sheet1_
4. In the same window, you'll see a Data Formatting tab. Click on that to get to this window. You'll want to set your field and record separator to separate the values for the grid. For this example, there is a vertical line set for field separator and an up-caret set for the record separator. You will also want to set the relevant records to 0, so it brings back all of your data (if needed). Then press OK.
5. Next, you will be adding your Gridfield. Go down to the Objects toolbar and right-click on Extended Objects where you can find Gridfield.
6. Click on your Gridfield to open it and you will see this window. Under the Body component, you'll see your grid where you can click on that open more of the settings.
7. One of the first things you'll see is where you can set your column length to. For this example, set the Columns to 3.
You will want to make sure your column and line separator match what you previously set up in Step 4.
8. You will want to select on the right hand side the name of your Table Lookup. By default, it will be named TABLE0. Double click on it to add it, and it will appear on the left after.
9. Lastly, when going under the properties of the Gridfield, the general tab will have a check-box that says Manage multiple pages. Make sure to check this box. This will allow any fields on your label that won't fix on one label be printed on the next.
You can see here that the left over rows are put onto the next label if not able to fit.
|