Conerting Deski report to Webi

[system]

Hi Experts,
I have a Deski XI report created using stored procedure.
Is it possible to convert the deski report created with stored procedure into the ebi report.
When i tried converting using report conversion toll it is giving the error like as below.
Not converted:DP Stored Procedure.
I really appreciate your help.

---

Kalyani (BOB member since 2007-02-26)

[SebastienGoiffon]

Hi,

Make a search on BOB because there is a useful post explaining how to use stored procedure within webi.

BR
Sebastien

[system]

In WEBI you cannot create report using Stored Procedures. This is possible only using DESKI.

Check this link also may be help you…!!

120×120 10.4 KB

Hi guys! today I was lucky and managed to make stored procedures working in WebI. I’m glad to share this ‘know how’ and say goodby to DeskI Change parameter Force SQLExecute in odbc.sbo to Always Add parameter Force SQLExecute = Always into oledb.sbo Create query in WebI with the same structure your SP returns Change SQL to following set nocount on /*SELECT any_field FROM any_table*/ exec your_stored_procedure @prompt('enter value','A',<other prompt parameters>) you can even use tem…

---

srijaggu (BOB member since 2007-09-07)