1) Column Properties and Bound Column

Toggle Icon Minus 17Column 1- (Sr. No)

 

Step 1:

 

Click on the Column Property Tab. Change the Column Type to Serial Number. See the window below:

 

        bound table sr no.zoom25

                              Fig 1. Column Type

 

notes

By Default, Column Type is  General. It is essential to change the column type according to your column.

 

Step 2:

 

Change the header Text to Sr no for serial number.

 

        bound table header text.zoom25

                                    Fig 2. Column Type

 

Toggle Icon Minus 17Column 2- (Company Name)

Company Name could be the second field that you may wish to enter in your Bound Table. Follow the below steps to assign properties to your Columns:

 

bullet01 Step 1:

 

Click on Bound Column Tab. Find the bound column and right click on the column name. You will see three options;

 

a) First option is to add it directly to the Bound Table. As you click on this option, it will be automatically added to your table.

 

      bound table company column property.zoom25

                                 Fig 3. Bound Column

     

You can also select from the following options:

 

b) Add to Expression Table: This option allows you to add the column to your expression Table. You can create your own expression by adding multiple columns in this table. You can execute the Query and See the Result without Previewing it. See the window below:

 

      bound table company expression window .zoom25

                                  Fig 4. Expression Table

 

c) Insert to Expression Table: You can insert a new column in your expression window through this option. This option will clear or over-write your existing expression on the table. To insert New column, hit this option.

 

 

bullet01 Step 3:

 

Click on the Column Property. Set the Column Type to General. You may choose it to Dimension, as per your requirements.

 

              bound table company column property type .zoom25

                                            Fig 5. Column Type

 

notes

By Default, Column Type is  General. It is essential to change the column type according to your column.

bullet01 Step 4:

 

Change the header Text according to your needs. See the window below:

 

              boun table header text company.zoom25

                                            Fig 6. Column Type

 

 

Toggle Icon Minus 17Column 3- (Item Name)

Item is the main part of any Invoice. You can include the Item Name in your Bill by following these steps:

 

bullet01 Step 1:
 

Click on Bound Column Tab. Find the bound column and right click on the column name to add it in the Grid Table. The query of Column will be added in your Grid Table. See the window:

 

              bound table item name.zoom25

                                              Fig 7. Bound Column

 

bullet01 Step 2:

 

Click on Column Property, Select the Column Type to Dimension. You can check the window below:

 

            bound table item column.zoom25

                                       Fig 8. Column Type

 

notes

By Default, Column Type is  General. It is essential to change the column type according to your column.

 

bullet01 Step 3:

 

Change the header Text according to your Bill Design. See the window below:

 

            bound table item header.zoom25

                                     Fig 9. Column Type

       

 

Toggle Icon Minus 17Column 4- (Pack)

 

If you want to include Pack column in your bill, you have to follow the steps mentioned below:

 

bullet01 Step 1:
 

Click on Bound Column Tab. Find the bound column and right click on the column name to add it in the Grid Table. The query of Column will be added in your Grid Table. See the window:

 

        bound table pack.zoom25

                                    Fig 10. Bound Column

 

bullet01 Step 2:

 

Click on Column Property, Select the Column Type to Dimension. Check the window:

 

        bound table pack column.zoom25

                                    Fig 11. Column Type

 

notes

1) By Default, Column Type is  General. It is essential to change the column type according to your column.

 

bullet01 Step 3:

 

Change the header Text to give your Header a name according to your Bill Design. See the window below how to change a header text.

 

      bound table pack header.zoom25

                               Fig 12. Column Type

           

Toggle Icon Minus 17Column 5- (Qty)

 

If you want to include a column for Qty in your bill, you have to follow the steps written below:

 

Step 1:

 

Click on Bound Column Tab. Find the bound column and right click on the column name to add it in the Grid Table. The query of Column will be added in your Grid Table. See the window:

 

            bound table qty.zoom25

                                          Fig 13. Column Type

 

bullet01 Step 2:

 

Click on Column Property, Select the Column Type to Measure. Check the window:

 

            bound table qty column.zoom25

                                            Fig 14. Column Type

 

notes

By Default, Column Type is  General. It is essential to change the column type according to your column.

 

bullet01 Step 3:

 

Change the header Text to give your Header a name according to your Bill Design. See the window below how to change a header text.

 

          bound table qty header.zoom25

                                          Fig 15. Column Type

 

Toggle Icon Minus 17Column 6- (Rate)

 

To Mention the Rate or Price of every item, you need to enter a column for Rate. Follow the steps written below:

 

 

Step 1:

 

Click on Bound Column Tab. Find the bound column and right click on the column name to add it in the Grid Table. The query of Column will be added in your Grid Table. See the window:

 

          bound table rate.zoom25

                                     Fig 16. Bound Column

 

bullet01 Step 2:

 

Click on Column Property, Select the Column Type to General. Check the window:

 

            bound table rate column.zoom25

                                            Fig 17. Column Type

 

notes

By Default, Column Type is  General. It is essential to change the column type according to your column.

 

bullet01 Step 3:

 

Change the header Text to give your Header a name according to your Bill Design. See the window below how to change a header text.

 

          bound table rate header.zoom25

                                       Fig 18. Column Type

 

Toggle Icon Minus 17Column 7- (Amount)

 

Amount Column is reserved to mention the total amount of Every Item. Follow the steps below to add Amount:

 

Step 1:

 

Click on Bound Column Tab. Find the bound column and right click on the column name to add it in the Grid Table. See the window:

 

          bound table amount.zoom25

                                             Fig 19. Bound Column

 

bullet01 Step 2:

 

Click on Column Property, Select the Column Type to Measure. Check the window:

 

          bound table amount column.zoom25

                                     Fig 20. Column Type

 

notes

By Default, Column Type is  General. It is essential to change the column type according to your column.

 

bullet01 Step 3:

 

Change the header Text to give your Header a name according to your Bill Design. See the window below how to change a header text.

 

          bound table amount header.zoom25

                                   Fig 21. Column Type

 

 

How to Add a Column for Grand Total?

 

Adding a Column for Grand Total is necessary to get a Total of attributes. Follow the steps below to add a column for Grand  Total in your Bound Table:

 

notes

Grand Total could be calculated only for the Columns that are set Measure in the Column Property> Column Type.

 

 

Step 1: Click on Other Settings Tab. Select Other Settings Option and set Show Grand Total to True to add a column for Grand Total in your sale bill design. See the widow below:

 

          bound table grand total true.zoom25

                                      Fig 22. Bound Column

 

 

Step 2: Click on the Grand Total and then, Collection. A list of columns will appear, select the columns for which you want to calculate Grand Total.

 

        bound table grand total collection.zoom25

                                  Fig 23. Column Type

 

 

2) Column Style:

 

 

Column Style is used to give a special style to your Columns.There are many features in this tab. Few of them are as mentioned below that you can add in your Bound Table.

 

 

  bound table column style back color.zoom25

                          Fig 24. Back Color

 

Back Color:

 

You can change the Back Color of any column through this option.

 

  bound table column style font.zoom25

                           Fig 25. Font

 

Font:

 

You can change the style of Font and its size through this option.

 

  bound table column style horizontal alignment.zoom25

                      Fig 26. Horizontal Alignment

 

Horizontal Alignment:

 

This option is used to change the Horizontal Alignment of Columns. You can set it to Left, Right or Center according to your requirements.

 

  Column Style Preview:

 

It will look as follows after applying all the changes in the Column Style Tab.

 

bound table column style preview.zoom50.

   Fig 27. Column Style Preview

 

3)Other Settings:

 

This tab is used to change the additional settings.There are many features in this tab. Few of them are as mentioned below that you can add in your Bound Table.

 

 

bound table other settings.zoom25

                                  Fig 28. Aply Style type

 

  bound table other settings 1.zoom25

                     Fig 29. Appearance

 

Appearance:

 

a) Aply style type: You can select whether the changes are to be made in the entire table, in Header Row, in Data Row or Grand Total Row through  this option. See the window.

 

b) You can also change the Back Color from Appearance Tab.

 

 

 

 

 

 

 

 

c) Border style: This option allows you to change the style of Border used in the Bound Table.

 

d) Font: As cleared from the name, you can change the style of the Font through this option. It also allows you to give Horizontal or Vertical Alignment to your Table and change the Color of the font used in the table.

 

 

 

  bound table other settings 2.zoom25

                    Fig 30. Other Settings

 

Other Settings:

 

a) Fit to Page Width: Set this option to True to Fit it according to the Width of the Page.

 

b) Number of Rows per Page:You can specify the number of rows in your Bill for the data. Rows will be added internally in the Bill.

 

c) Number of Rows to Display: You can specify the number of rows you want to display in your Bill for the data. Rows will be displayed in our Bill.

 

 

How to Add Decimal in Values?

 

To add Decimal in Values, Click on Column Property> Column Expression> Number> Format. See the window below:

     

        bound table decimal.zoom25

                                   Fig 31. Add Decimal

 

Other Settings Preview:

 

It will look as follows after applying all the changes in the Other Settings Tab.

 

  bound table other settings preview.zoom50

    Fig 32. Other Settings Preview

Back To Top