#_dateRangeFieldsHTML# SELECT DISTINCT b.BROKER_ID, b.BROKER_Name FROM tblBrokers b, tbl_SMA_BrokerOfficeLink s, tblBrokerOffices o WHERE s.BrokerID = b.BROKER_ID AND o.BROKER_OFFICE_ID = s.BrokerOfficeID AND MFR_ID = ORDER BY b.BROKER_Name select mac.maCategoryId, mac.ownerId, mac.ownerType, mac.name, mac.IsDefault from tbl_CRM_MarketingActivityCategories mac where mac.ownerId = #_territoryFieldsHTML# bothMfrBroReps="False" ---> select operatorId, companyName from tbl_OPR_CLientOperators where ownerId = and FSLTableCode = and oprCompanytype = '1' and territoryId IN () union select hq.operatorId, hq.companyName from tbl_OPR_CLientOperators hq inner join tbl_OPR_ClientOperators units on units.oprParentCo = hq.operatorId where hq.ownerId = and hq.FSLTableCode = and hq.oprCompanytype = '1' and units.territoryId IN () order by companyName

Customer Type:	Operators & Distributors Operators Only Distributors Only
Group By:	Sales Rep, Account Territory, Account
Broker Company	-- Broker Company -- #broker_name# multiple
Campaign:	singlemultiple
Initiative Category:	-- All -- #htmleditformat( name )#
Initiative:	All    Initiative Related  Not Initiative Related
	#_maSelectHTML#
Distributor:	singlemultiple
Sales Rep Type:	All Reps    Broker Only    Manufacturer Only
Sales Person:	#_html#
	How should sales person be applied? selected>For Sales Person On Call selected>For Sales Person On Account
Operator List	--- my lists --- #htmleditformat( listName )# &##160;&##160; List being processed, temporarily unavailable -- public lists -- #iif( isProcessing EQ 'Y', de("disabled=""disabled"""),de(""))# >#htmleditformat( listName )# &##160;&##160; List being processed, temporarily unavailable singlemultiple
Distributor List	--- my lists --- #htmleditformat( listName )# &##160;&##160; List being processed, temporarily unavailable -- public lists -- #htmleditformat( listName )# &##160;&##160; List being processed, temporarily unavailable
Call Status:	-- All -- Pending Finalized
Item Status:	-- All -- Sale No Sale Follow Up Not Shown LTO singlemultiple
Method:	-- All -- Face to Face Phone Email singlemultiple
Classification:	-- All -- Operator Classifications    #htmleditformat( abbreviation )# - #htmleditformat( description )# Distributor Classifications    #htmleditformat( abbreviation )# - #htmleditformat( description )# singlemultiple
Segment:	-- All -- #repeatstring(" ",(clientseglevel-1)*2)##htmleditformat( description )# singlemultiple
Group Member Status:	-- Any Group Membership -- GPO    #htmleditformat( affiliationName )# Managed By    #htmleditformat( affiliationName )# singlemultiple
Include Membership Group Info: (Excel Only)	Yes    No      Name & Member Number Name Only
No Sale Reasons:	-- All -- #htmleditformat( reasonName )# singlemultiple
Call Type:
Chain HQ:	-- All -- #htmleditformat( companyName )# singlemultiple
Competitor:	multiple
Product (L2):	search
SKU (L1):	search
Top # of Records: (Excel Only)	by Annual Cases Annual Lbs Annual Dollars Sort By: Territory Volume
Focus Products Only:	Yes    No
Show Comments:	Yes    No
Page Breaks:	Yes    No
Criteria Page:	Yes    No