How do I create custom report from stored procedure

Question

Hi,I need to create a report form stored procedure. My stored procedureselects the data and inserts in temp table.I am executing stored procedurefrom pre query and selecting coloumns from temp table . But I am gettingerror   Invalid object name temp. Is it possible to execute the report from storedprocedure.mohan-------------------------------------##-----------------------------------------------##Newsgroup Access Courtesy Tax and Accounting Software ForumsWeb and RSS accessto your favorite newsgroup - microsoft.public.pos - 40088 messages andcounting!##-----------------------------------------------##

cptsoft · Accepted Answer

Hi,

I need to create a report form stored procedure. My stored procedure selects the data and inserts in temp table.I am executing stored procedure from pre query and selecting coloumns from temp table . But I am getting error Invalid object name temp. Is it possible to execute the report from stored procedure. mohan

-------------------------------------

##-----------------------------------------------## Newsgroup Access Courtesy

formatting link

Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - microsoft.public.pos - 40088 messages and counting! ##-----------------------------------------------##

How do I create custom report from stored procedure

Join the Discussion

Didn't find your answer?