I have used the Data Shape commands successuflly in the past, but am confused by this error. I am trying to create a parent/child/grandchild relationship for a report I am writing. Initially I used the same temp table names for #Hours & #Days, but changed the temp table names when I first received the error. I now have #Hours, #Hours1, and #Hours2...same for #Days. Here is the error
Microsoft OLE DB Provider for SQL Server (0x80004005)
Invalid object name '#hours1'.
/dtreference/inquiry/bah-byshift.asp, line 27