How do I create custom report from stored procedure

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! ##-----------------------------------------------##

Reply to
mohan3446
Loading thread data ...

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 Forums Web and RSS access to your favorite newsgroup - microsoft.public.pos - 40088 messages and counting! ##-----------------------------------------------##

Reply to
cptsoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.