select * from qmd_xlsFiles order by dateLastModified desc select sr.savedReportId, sr.userReportName, sr.ownerId, sr.ownerType, sr.userId, m.ownerId userOwnerId, m.fsl_tablecode userOwnerType, m.firstName, m.lastName, m.email, sr.scheduledDeliveryEmail, sr.lastRun from tbl_SYS_SavedReports sr inner join tbl_FSpro_members m on m.fspro_userid = sr.userId where sr.reportCode = and sr.scheduledDelivery = 'Y' and sr.userReportName = and sr.lastRun >= select sr.savedReportId, sr.userReportName, sr.ownerId, sr.ownerType, sr.userId, m.ownerId userOwnerId, m.fsl_tablecode userOwnerType, m.firstName, m.lastName, m.email, sr.scheduledDeliveryEmail, sr.lastRun from tbl_SYS_SavedReports sr inner join tbl_FSpro_members m on m.fspro_userid = sr.userId where sr.reportCode = and sr.scheduledDelivery = 'Y' and sr.userReportName = and sr.lastRun >= select sr.savedReportId, sr.userReportName, sr.ownerId, sr.ownerType, sr.userId, m.ownerId userOwnerId, m.fsl_tablecode userOwnerType, m.firstName, m.lastName, m.email, sr.scheduledDeliveryEmail, sr.lastRun from tbl_SYS_SavedReports sr inner join tbl_FSpro_members m on m.fspro_userid = sr.userId where sr.reportCode = and sr.scheduledDelivery = 'Y' and sr.userReportName = 'Wedge.Z2.C&U' and sr.userReportName = 'Wedge.Z3.C&U' and sr.lastRun >= select sr.savedReportId, sr.userReportName, sr.ownerId, sr.ownerType, sr.userId, m.ownerId userOwnerId, m.fsl_tablecode userOwnerType, m.firstName, m.lastName, m.email, sr.scheduledDeliveryEmail, sr.lastRun from tbl_SYS_SavedReports sr inner join tbl_FSpro_members m on m.fspro_userid = sr.userId where sr.reportCode = and sr.scheduledDelivery = 'Y' and sr.userReportName like and sr.lastRun >= select sr.savedReportId, sr.userReportName, sr.ownerId, sr.ownerType, sr.userId, m.ownerId userOwnerId, m.fsl_tablecode userOwnerType, m.firstName, m.lastName, m.email, sr.scheduledDeliveryEmail, sr.lastRun from tbl_SYS_SavedReports sr inner join tbl_FSpro_members m on m.fspro_userid = sr.userId where sr.reportCode = and sr.scheduledDelivery = 'Y' and ( sr.userReportName like or sr.scheduledDeliverySubject like ) and sr.lastRun >= select mfr_name as name from tblManufacturers where mfr_id = select broker_name as name from tblBrokers where broker_id =

#lsdateformat( dateLastModified, "MM/DD/YYYY" )# #htmleditformat( _fileName )#
Report Name (ID)	Client	User	Distribution	Last Run
#htmleditformat( userReportName )# (#savedReportId#)	#htmleditformat( qmd_client.name )# (#ownerId#)	#htmleditformat( firstName )# #htmleditformat( lastName )# <#htmleditformat( email )#> select mfr_name as name from tblManufacturers where mfr_id = select broker_name as name from tblBrokers where broker_id = #htmleditformat( qmd_userClient.name )# (#userOwnerId#)	#htmleditformat( _email )#	#lsDateFormat( lastRun, "MM/DD/YYYY" )#
Can't find a matching saved report