Report using SP

building reports desktopintelligence
1

I have a simple stored procedure with no parameters.When i excecute in SQL server it runs fine and gives me the result set.But when i use it as a dat source for a BO report it gives an error message.
No data to fetch.

We are in BO XI r2 sp2.
Is there anything i need to do this work.
Thanks,
–h

hourigan (BOB member since 2007-04-06)

2

I have tried in ORACLE and it use REF CURSOR to return the results to BO.

I hope there is something similar in SQL Server.

BO_Chief :us: (BOB member since 2004-06-06)

3

Y dont you try using a free hand sql as a data source something like this…

BEGIN
EXEC sp_name
END

Try it, it works for me…

Let me know if it helps u…

anuraga (BOB member since 2009-04-15)

4

Hi,

I am using BO XI r2 Sp4 . I also tried using a Oracle SP in free hand SQL with no parameter but i get error like “No column or data to fetch” .

When i run

BEGIN
EXEC SP_name
END

i get following erro. "Exception: DBD, ORA-01036: illegal variable name/number State: N/AI used ’

When i run EXEC SP_Name i get error like “No column or data to fetch”

I changed the odbc.sbo file also.

Thanks

aroranikhil (BOB member since 2005-03-21)