# DBDEF

TBLQUERY:
select table_name as tname from user_catalog where  table_type IN('TABLE','VIEW') order by table_name

FIELDQRY:
select column_name as cname,data_type from user_tab_columns where table_name =


TBLQUERY:
select table_name as tname, table_type as tabletype from INFORMATION_SCHEMA.TABLES where table_schema = 'dbo' and table_type IN ('BASE TABLE','VIEW') order by table_name

FIELDQRY:
select column_name as cname, data_type from Information_schema.columns where table_name =


# DBQUERY

SQLQUERY:
Select * from categories where CategoryName = '<@=form:Category=@>'


# FOLDERS

DESCRIPTION:
These reports are run from other reports


# LISTBOX

LISTBOXQUERY:
Select CategoryID, CategoryName from Categories


LISTBOXQUERY:
Select CUSTID, CustName from CustDiscountTable


LISTBOXQUERY:
Select SNO, LaborCategory from PriceList


LISTBOXQUERY:
select description, value from statictable where codename='listnummonth'


LISTBOXQUERY:
select description, value from statictable where codename='listyear'


LISTBOXQUERY:
select description, value from statictable where codename = 'listquarter'


LISTBOXQUERY:
select employeeid, lastname + ', ' + firstname as EmpName


# RPTTBL

RPTNAME:
Report 02 - Simple Report with Sort and Chart


RPTNAME:
Report 04 - Cross Tab Report of Employees


RPTDESC:
Card Layout of sales by category with graphs


RPTNAME:
Embedde Sales for Category without Graph


RPTDESC:
A sample of how to join information from different sources


RPTDESC:
demonstrates the print preview capability


RPTDESC:
Executive Report of Inventory by Category


RPTDESC:
Cross Tab Report of Employee Performance by Country


RPTDESC:
Cross Tab Report of Sales by Category and Region


RPTNAME:
Yearly Sales Penetration/Retention By Category


RPTDESC:
Cross Tab Report showing new sales by employee


RPTNAME:
Distribution of Orders By Transaction Size

RPTDESC:
Cross tab report of Distribution of Orders By Transaction Size and Percent


RPTNAME:
Distribution of Order Counts by Transaction Size

RPTDESC:
Cross tab report of Distribution of Order Counts by Transaction Size


RPTNAME:
Gross Margin Contribution Report by Order

RPTDESC:
Standard Style Report of Gross Margins by Order


RPTDESC:
Executive Report of Back Orders by Employee


RPTNAME:
New Customer Acquistion Report by Month/Category


RPTNAME:
Gross Margin Contribution Report by Products

RPTDESC:
Simple Report of Gross Margin Contribution


RPTNAME:
YOY Sales Penetration Analysis by category

RPTDESC:
cross tab report - YOY Sales Penetration Analysis by category


RPTNAME:
employees per sector - stock comapny profile


RPTDESC:
Cross tab report to track movement of stocks


# SELECTBL

DESCRIPTION:
Timestamp (EEE, MMM d, yyyy ' at ' hh:mm a)


DESCRIPTION:
Group Sort (Prints Totals & Sub-headers)


# TBLINFO

NOTES:
List of customers with discount percentages


