The majority of reports had a command such as this, which failed:

SELECT "tblEPOnames"."strFirstName", "tblEPOnames"."strLastName", "tblEPOnames"."strUserID"

 FROM   "sjreportingprd"."dbo"."tblEPOnames" "tblEPOnames"

The other report had a command such as this, which succeeded:

SELECT tblEPOnames.lngEmployeeID, tblEPOnames.strLastName, tblEPOnames.strFirstName, tblEPOnames.strUserID, tblEPOnames.strDept,  tblEPOnames.strShift

FROM dbo.tblEPOnames

By resetting all of the commands to this syntax I was able to get it to work.