Symptom
Running a Trial Balance Report with Report Groups and using the Drill Down function produces the following error.
The multi-part Identifier “tblDLtrans.sCodeIDF_1” could not be bound.
Invalid object name ‘##DDFSL1’.
Cannot drop the table ‘##DDFSL1’, because it does not exist or you do not have permission.
SELECT * FROM ##DDFSL1 ORDER BY nPosition
Once OK is select a longer error displays beginning with:
At System.DataSQLClient.SQLConnection.OnError(sql
Product Line