HELP CENTER

This page will show the table of (Sales) which will be used in all our demos,

This table is about

• Sales Segment (Government, Midmarket, Channel partners)

• Country (Germany , France , Mexico)

• Product types (Carretera , Montana )

• Discount band

• Manufacturing Pricing

• Cross sales and discounts

• The date of sale (Year and Month)

Go to Home page click the (Add report) button and enter the information shown below

• The primary report name :the report name in the primary language e.g. English

• Secondary Report name : the report name in the Secondary language e.g. French

• Select the page size : (A4 ,A3 , A2 ,A1 ,A0)

• Select the view type (Landscape or Portrait)

• Click on the required direction (Left-to-right or right-to-left)

• Click Next

• The page for creating datasets will appear. To create new datasets click (Add Data Set) the page will appear then enter the information as shown below:-

• Select Sql Type (Procedure or SQL query)

• If it’s a SQL Query enter your SQL Query

• Write the name of the query (Alias of dataset) this is mandatory.

• Add the number of rows per page per datasets. ,you can use this option if you want to use forms. For example I want to show one employee profile for each page .

• To write a complex dataset , depends on a complex query which uses many tables with complex relations.

• The query Editor will check if there are any errors in the SQL statement and it will show you what the error is. For Example if I write the wrong table name an error will appear the table name is incorrect.