| |
| *** No Order History Records Qualified *** | |
|
| |
| Item Count: | #NumberFormat(_ResultSetCnt,",")# |
| |
| Date Type: | #GetDateType(attributes.params.rpt_datefield_opt)# |
| |
| Current Month Date Range: | #dateformat(_mFromDateTY,"mm/dd/yyyy")# - #dateformat(_mToDateTY,"mm/dd/yyyy")# |
| |
| Rolling 12 Month Date Range: | #dateformat(_yFromDateTY,"mm/dd/yyyy")# - #dateformat(_yToDateTY,"mm/dd/yyyy")# |
| |
| Territory: |
#_TName#
|
| |
| Office: |
All Offices |
| |
| Office: |
#ValueList(qmd_OfficeList.officeName, ", ")# |
| Territory: |
#_TName#
|
--->
| |
| Distributors: |
All Distributors
SELECT cdr_dstname
FROM tbl_CDR_Distributors
WHERE cdr_recordid IN ()
ORDER BY cdr_dstname
#qmd_DistName.cdr_dstname#,
|
| |
| Manufacturers: |
All Manufacturers
SELECT Mfr_Name
FROM tblManufacturers
WHERE Mfr_Id IN ()
ORDER BY Mfr_Name
#qmd_MfrName.Mfr_Name#,
|
| |
| Sales Reps: |
All Sales Reps
SELECT UserName
FROM #ERPDatabaseName#.Users U
WHERE U.UserID IN ()
SELECT firstName, LastName, firstName + ' ' + Lastname as RepName
FROM tbl_FSPro_members M
WHERE FSPro_userid IN ()
AND ownerid =
AND fsl_tablecode =
ORDER BY LastName, firstName
#qmd_CRMRepName.RepName#,
|
| |
| Item Codes: | #REPLACE(attributes.params.rpt_items_opt,",",", ","all")# |
| |
| Category Codes: | #REPLACE(attributes.params.rpt_cat_opt,",",", ","all")# |
| |
| |
| Run By: |
#htmleditformat( client.user )# <#trim( htmleditformat( client.email ))#> |
|
| TY = This Year |
| LY = Last Year |
| % = Percent Variance |