Use Strored procedure and view in report

[Sot]

I am using crystal 8.5/Sqlserver 2000
In my crystal reports..I am trying to use view(visit_accledger_rpt_vw
AS) and stored procedure(sp_GetFinancial)...
i am trying to get a value(@get_max_detailno_withinIns) from view and pass the value to stored procedure as a parameter(@transno)
and try to get one output(co_ins) value.... have any one give me idea to do it...

ravi

 

[synapsevampire]

I suspect that @get_max_detailno_withinIns is not a value from the View, rather a formula which is derived from data within the View.

What you're then wanting to do is link this formula to a stored procedure parameter and output the result of the SP, is this correct?

I would suggest that you do this on the database in a different Stored Procedure.

I haven't tried this (and can't right now), but you may be able to place the stored procedure in a subreport and link via this formula in the main report.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com