Header Properties

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

Header Properties:

 

Connection properties

Connection: Connection is used to make a connection through Microsoft Access, Microsoft Sql Server, Microsoft Excel and Text File.

Execute Query

Execute Query: Execute Query is used to retrieve all the fields that you might have entered in the  Sale Bill. It will let you know about the fields and its query so that you an add it in the designing to retrieve the data from database.

Execute Query exp

Execute Query Expression: This option is used to retrieve data directly from database.

Edit Expression

Edit Expression: This icon allows you to modify the existing query.

Save query

Save Query: You can generate a new data table from the existing data table through this option available.

Save Expression

Save Expression: This is a simple expression that is used to get the values from the existing expression or values.

Save query Expression

Save Query Expression: You can save your data that you have retrieved directly from the database through this option.

Delete Expression

Delete Expression: This icon is used to Delete any expression from the Sale Bill.

Close seleted Tab

Close Selected Tab: If you want to close any particular tab, simply click on this icon to close selected Tab.

Return Expression

Return Expression: Click on this link to Return an expression via inserting an expression in the sale bill designer form.

Edit Error Field

Edit Error Field: If you want to Edit your field that contains error, click on this link to edit error Field.

Expression Designer

Expression Designer: Expression Designer allows you to design your own Expression for the query. Simply click on this icon to design an expression for your Bill.

Design Custom Data

Design Custom Data Table From Expression: If you want to design a table of your own that contains your expressions well, Click on this con. It will help you in design a table of data that is derived from the Expression. You can make changes in it according to your needs.

 

notes

Click on the Field you want to retrieve value from the database.

 

 

bill design header properties.zoom15

 

Fig 1.Executing a Query

Executing a Query:

 

Select Execute Query or Press F5 from your Keyboard. It will give a complete list of all the fields and their queries so that you can select it from the Connection(s).  See the window.

 

Now select the Query according to the Fields of your Header, and Select your Query from Bill Header. For Example: To enter the query of Name, Select Account_Name from the Bill Header.

 

 

insert field.zoom22

 

Fig 2.Inserting Field

 

Inserting Field:

 

Right Click on the Field and click on Insert Field.

 

 

field added.zoom25

 

Fig 3.Adding Field

 

Adding Field:

 

The field will be automatically added to your Table. See the window.

 

header with all queries.zoom25

 

Fig 4.Header with queries

 

Complete Header with Queries:

 

Similarly, select the queries for other fields from the Executed Query and add it in your Tables. See the window:

 

notes

You can See your Design by clicking on the Print Preview Option on Toolbar.

 

Back To Top