Can i create a livereport that runs a stored procedure

Helloi am trying to create a livereport that will execute a stored procedure first and from that generate a report from the outputs of the stored procedure.

Find more posts tagged with

Comments

Chris_Jones

Message from Jones, Christopher L. (IT) via eLinkYes you can rather easy just include exec before calling the storedprocedure in the reportexec sp_StoredProcedureThank you,Chris -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Wednesday, August 15, 2007 8:01 AMTo: eLink RecipientSubject: Can i create a livereport that runs a stored procedureCan i create a livereport that runs a stored procedure Posted byMokobane, Dikeledi on 08/15/2007 07:58 AMHelloi am trying to create a livereport that will execute a stored procedurefirst and from that generate a report from the outputs of the storedprocedure.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/Livelink_LiveReports_DiscussionLivelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Dikeledi, Yes you can run a stored procedure form a Livereport.How you enter the name and parameters depends upon the RDBMS you areusing.I think the following advice is correct.When you run a stored procedure from a Livereport....in Oracle sp_name parm1, parm2, etc.in MSSql exec sp_name parm1, parm2, etc. Be aware that in a Livereport, only output from one select statementwill be returned in the results window.RegardsLindsayUK-Support, Open Text-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 15 August 2007 13:01To: eLink RecipientSubject: Can i create a livereport that runs a stored procedureCan i create a livereport that runs a stored procedurePosted by Mokobane, Dikeledi on 08/15/2007 07:58 AMHelloi am trying to create a livereport that will execute a stored procedurefirst and from that generate a report from the outputs of the storedprocedure.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/Livelink_LiveReports_DiscussionLivelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.