Creating a Level

Creating a Level

Level is heart of any report.

Report cannot run without adding levels.

Authorized user can create a level.

Following information is required for creating a level.

Level gives idea as which columns [Data] to show in report.

For example

select  customerid, companyname, contactname, contacttitle, address, city from customers

Here Customerid, Companyname etc.. are known as columns.

There can be multiple level  & each level can be linked to each other.

Following are the basic properties of Level.

Level ID

Each new level will have a unique ID representing level information.When user adds first level Level ID starts with 000001 & so on.

Level Head

Level Head is heading of each level or caption.This is useful when user views the report and one can make out from the name of  Level Head as what will be the content of each level in report.

Parent Lvl ID

This is very important when one is designing report having multiple level. In above example there are two level. First level gives details of Customers & second level gives details of Orders.

For Level ID  000002  ParentLvl ID  will be 000001  because Orders are link with Customers. In short whenever user click on any Customer, Order details of same customer should be shown in Second Level.

Case I

All child levels have one 'Parent ID'

Case II

Child Level does not have same parent ID.

View Type

Each level can have different View Type in report. Different View Type are as follows:

Grid View

Card view

Banded View

Border Style

Select Border Style.

Level Query

User can predefine queries using Query Manager option. For example user wants details of all the customers as seen in above example, query will be written like

" select  customerid, companyname, contactname, contacttitle, address, city from customers " & this will be saved as  CustQuery.

Query will be define each domain wise

Parent Keys

This is used when there are multiple levels & we need to set relation to each level. For example there is a relation between Customer Level & Order Level.

Common column in both the levels is Customerid

Child Keys

This is used when there are multiple levels & we need to set relation to each level. For example there is a relation between Customer Level & Order Level.

Child key is field of that particular level which needs  to set relation with parent key of Customer Level.

After selecting query and clicking on Generate Cols. you must has to Execute SQL & then generate report columns. This will enable the user to view the report.Save the generated columns and click on Exit.

User Guide 17