Invalid object name '#Tmp_PDPR' while setting up Data Source Stored Procedure

jwjwjw1990

I've created a FastReport and would like to retreive the data with a Stored Procedure. Within the stored procedure, a temporary table is created, called #TmpPDPR. While defining the parameters in FastReport, it gives me the error Invalid object name '#TmpPDPR', and then continues to the Define Columns window. Does this mean it won't work?

jwjwjw1990

I found the solution. Add this before the query:

Set FMTOnly OFF

https://stackoverflow.com/questions/45635406/query-with-temp-table-cant-execute-without-set-fmtonly-off