Day6 Enquiry

ENQUIRY
OBJECTIVE
Objectives of the course are to
Introduction to ENQUIRY Application
Creation of enquiry through Designer
Drill down Enquiries
2
INTRODUCTION TO ENQUIRY
3
INTRODUCTION
Enquiry is the T24 Utility used to retrieve a data from the system
This application allows to specify report parameters without using

programs
Subroutines can also be attached to achieve more functionality and

to create complex enquiry
Enquiries may be used to produce reports online, or from the end of

day
4
CREATION OF ENQUIRY
Enquiry can be designed in below ways

o ENQUIRY
o ENQUIRY DESIGNER
Enquiry Designer Creates a record on the ENQUIRY table
Once created the processing of the resultant ENQUIRY is identical
5
ENQUIRY Application
This file holds the parameter definitions of the enquiries used by the
enquiry system
Allows to define an on-line enquiry without any coding requirements
Parameters specifies the file to be listed, the fields to be displayed

and where, the formats and conversions to be applied prior to
display and the break points (if any) to be used
Parameters can also define internally calculated data, totals/sub-

totals, decision processing, user routines and finally a link to a lower
level enquiry
6
ENQUIRY APPLICATION
Example 1
Enquiry To display the Working Balance of each Customer
File Name Account
Fields Used Account Number, Account title,

Currency, Working Balance.
Condition Working Balance should be greater than

zero.
7
OUTPUT
8
Example:
Enquiry to calculate the Working Balance of each Customer
File Name Account
Fields Used Account Number, Account title,

Currency, Working Balance.
Condition Working Balance should be greater than
zero.
9
SOLUTION
Col Name Actual Value Description
Page size 4,19 Indicates the size of the page. The data gets
displayed from the 4th row till 19th row
File Name ACCOUNT The actual file from where the data is
retrieved.
Fixed WORKING.BAL Any VALID condition can be given here.
Selection ANCE GT 0
Fixed Sort CUSTOMER Since the report is based on Customer we
need to sort the report Customer wise. By
default it is Ascending.
Selection CUSTOMER If there is any restriction on selection of the
Fields records then you can specify it here.
Suppose you want to select only records
whose CUSTOMER No which is greater than
100400 then you have to fill the Op and
Mandatory field.
10
Sel Fld EQ Various operands are available from which
Oper we can select any one.
Required Yes If Yes then the selection field along with the
Sel value has to be given. Otherwise it will give
an error message. This can control
processor time by limiting the size of each
enquiry.
Header @(2,2)LIST OF The format is @(2,2)LIST.... where
CUSTOMER @(C,L)(C=2,L=2) is the screen column and
WITH line position and LIST.. is the text to be
WORKING displayed.
Header @(20,2)BALAN -----------,,---------------------,,

CE GT ZERO
11
Design and equiry to display Acc.no and name of the customers
Solution
Field Name ACCOUNT NO This is the name of the field. (Variable

Name)
Operation @ID/FILED NO. This is the actual field in the table or file.
Column 1 The value will be displayed from column

2
Length Mask 10R The length of the field is 10 and right
justified
Field Lbl ACCOUNT NUMBER We can specify the col heading here. But
this heading will be displayed only if it is
a Grid Enquiry. By default the Attribute
will be Grid.
12
Actual Value Description
Field Name Custname This is the name of the field. (Variable

Name)
Operation CUSTOMER This is the actual field in the table or
file.
Column 17 The value will be displayed from
column 17.
Length Mask 10L The length of the field is 10 and left
justified
Conversion LINK CUSTOMER,2 Actual File or table we are using here
is Account. In account file only the
Customer Id will be stored. When you
want to get the Name of the customer
then you have to LINK to the
Customer file and specify the actual
field no. in which it is stored or the field
name.
13
Design an enquiry which displays data as below
Working Balance of each Customer
Cust No. Cus Name Acct No. Work Balance
111111 XXXXXXXXX 23456 1000.00

111111 XXXX 34567 2500.00
111111 XXXXXXXXX 45678 3500.00
XXXX _______
XXXXXXXXX 7000.00
XXXX
222222 YYYYYYYYY 56789 3623.00

222222 YYYY 78965 5623.00
YYYYYYYYY -----------
YYYY 9246.00
14
Field Name Account.Number This is the name of the field. (Variable Name)
Operation ACCOUNT.NUMBER This is the actual field in the table or file.
Column 37 The value will be displayed from column 37
Length Mask 16R The length of the field is 16 and right justified
Field Name Working.Balance This is the name of the field. (Variable Name)
Operation WORKING.BALANCE This is the actual field in the table or file.
Column 50 The value will be displayed from column 50
Length Mask 19R2 The length of the field is 19 and right justified
and two decimal place.
With the above detail the columns will be created and even the data will also get displayed.
Now we need to get the total for each Customer. Since the report is based on Customer
there should be break on each Customer. The steps needed for creating a break for a
particular field are.
To define the variable for the break field Actual field name for the break has to be specified
The total for that break field and The label for that break field
15
Field Name B.Cus Variable Name on which the break is to

be applied
Operation B C CUSTNO Break Change on Customer. Variable
Name for Customer which is used above
should be given.
Field Name D.Cus This is also a Variable name.
Operation F CUSTNO Field Customer.
Display Break B.Cus The break field has to be specified
Field Name Cus.Total This is also a Variable name.
Operation TOTAL Working.Balance Customer wise total will be displayed
Column 50,+1 The column where the grand total for
each customer will be displayed. +1 is to
indicate that the total should come in the
next line.
Mask 19R2 The length of the field is 19 and right
justified and two decimal place.
16
Field Name C.Total This is also a Variable name.

Operation Total Work Balance The label for the total of each customer
has to be specified here.
Column 45,+1 The column from where the label has to
be displayed is specified here. +1 is to
indicate that the label also should come
in the next line.
Field Name Line This is also a Variable name.
Operation _______________ To get a line for total
Column 45,+1 The column from where the line has to be
displayed is specified here. +1 is to
indicate that the line also should come in
the next line.
17
Field Name Lline This is also a Variable name.

Operation _______________ To get a line for total
Column 45 The column from where the line has to be
displayed is specified here.
If we want to break the report page wise, (i.e) each customer one page then the
following values are to be given in these fields
Field Name Custno This is the name of the field. (Variable
Name)
Operation CUSTOMER This is the actual field in the table or file.
Field Name B.Cus Variable Name on which the break is to be
applied
Operation B C CUSTNO Break Change on Customer. The variable
Name for Customer has to be specified
here.
Column P Since the report is page-wise we have to
give P here.
18
Field Name B.Cus Variable Name on which the break is to

be applied
Operation B C CUSTNO Break Change on Customer. The variable
Name for Customer has to be specified
here.
Column P Since the report is page-wise we have to
give P here.
Field Name D.Cus This is also a Variable name.
Operation F CUSTNO Field Customer.
Column 13,2 The column where the Customer Number
has to be displayed has to be given here
rather then giving in column. 13th col and
2nd row
Section Header Header indicates that the Customer No.
should be printed in header.
19
20
21
22
23
OUTPUT
24
ENQUIRY DESIGNER
25
SCREEN DESIGNER Example
26
GRAPHICAL USER DESIGNER
From Tools Menu Select Enquiry Designer

Enter Name of the Enquiry
Enter the name of the file in the field File Name from which the data
is to retrieved
This will display the list of fields for the corresponding file
Select the tab Data Columns
Start to define field name , Columns etc
Use Multi value to define more fields
Now view the output of Enquiry
27
ENQUIRY ATTRIBUTES
An enquiry is defaulted as a GRID enquiry, to show a selection of

data
To change, use either the Advanced tab in Enquiry Designer, then
Attributes or Field 52 on the Full View.
Examples include
PAGE - to change to a page layout
ALLDATA- to always extract all data that matches the criteria
28
DRILL DOWN ENQUIRY
Data displayed in one Enquiry can be used as the selection criteria

for another enquiry e.g. if you run ACCT.BAL.TODAY, you can select
a specific account
If in your enquiry you have data equivalent e.g. Account number, it

can be used to launch another enquiry and auto-select the specific
data
By double clicking on the link you can start up a lower level enquiry,
drilling down to further analyse data
29
Example
Design a Drill down enquire which displays Data as below
30
Solution
31
32
33
34
35
SUMMARY
You should now understand how to

Create, format and edit of enquires
Getting data from another application
Drilldown
Design a enquiry through Enquiry Designer
36

Day6 Enquiry

Uploaded by

Copyright:

Available Formats

Day6 Enquiry

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Day6 Enquiry

Uploaded by

Copyright:

Available Formats

ENQUIRY

Objectives of the course are to

Introduction to ENQUIRY Application

Creation of enquiry through Designer

Drill down Enquiries

This application allows to specify report parameters without using

Subroutines can also be attached to achieve more functionality and

Enquiries may be used to produce reports online, or from the end of

Enquiry can be designed in below ways

Enquiry Designer Creates a record on the ENQUIRY table

Once created the processing of the resultant ENQUIRY is identical

Allows to define an on-line enquiry without any coding requirements

Parameters specifies the file to be listed, the fields to be displayed

Parameters can also define internally calculated data, totals/sub-

File Name Account

Fields Used Account Number, Account title,

Condition Working Balance should be greater than

Enquiry to calculate the Working Balance of each Customer

File Name Account

Fields Used Account Number, Account title,

Header @(20,2)BALAN -----------,,---------------------,,

Col Name Actual Value Description

Field Name ACCOUNT NO This is the name of the field. (Variable

Column 1 The value will be displayed from column

Field Name Custname This is the name of the field. (Variable

111111 XXXXXXXXX 23456 1000.00

222222 YYYYYYYYY 56789 3623.00

Field Name B.Cus Variable Name on which the break is to

Field Name C.Total This is also a Variable name.

Field Name Lline This is also a Variable name.

Field Name B.Cus Variable Name on which the break is to

From Tools Menu Select Enquiry Designer

An enquiry is defaulted as a GRID enquiry, to show a selection of

Data displayed in one Enquiry can be used as the selection criteria

If in your enquiry you have data equivalent e.g. Account number, it

You should now understand how to

Design a enquiry through Enquiry Designer

You might also like