select cdr.cdr_dstname, cdr.fsl_dstid, cdr.cdr_dstCompanyType
from tbl_cdr_distributors cdr
where cdr.ownerid =
and cdr.fsl_tablecode =
and cdr.cdr_recordid =
select skuid
from tbl_ofs_brokerskus
where ownerid =
and ownertype =
and skuid in ( )
select qryDistributorSales.*
from qryDistributorSales, qrySyndicatedSkus
where qryDistributorSales.skuid = qrySyndicatedSkus.skuid
select cast(#_categoryField# as varchar) #_categoryField#, cast(#_categoryIdField# as integer) #_categoryIdField#, sum( forecast_amt ) forecast_amt, sum( forecast_qty ) forecast_qty,
sum( lyforecast_amt ) lyforecast_amt, sum( lyforecast_qty ) lyforecast_qty, '' as chartColor
from qryDistributorSales
group by #_categoryField#, #_categoryIdField#
select *
from qryDistributorSales
order by #_orderBy#
#qryDistributor.cdr_dstname#
#_chartName# - TY #_mfrUOM.unitOfMeasurePlural#
Invoice Data #dateformat(_calendarVars.tyPlanStartDate,"m/d/yy")# - #dateformat(_calendarVars.tyPlanEndDate,"m/d/yy")#, as of #dateformat(_calendarVars.asOfDate,"m/d/yy")#