crystal report store procedure

charleschin

May I know how run a store procedure first before crystal report first run?





Scenario:

  When crystal report runs, it will generate the select SQL statement from table that I declare in crystal report database connection.

But on top of that, I need to run my store procedure first in order to generate data for those SQL table. How do I actually run my store procedure first before crystal report run?





Any advice welcome, Thanks!

k-1

你可以把 SELECT statement 放在你 generate data 的 stored procedure 里。
然后 set 你 Crystal Report 的 Data Source 去 那个 stored procedure.。
又或者，用 application program generate data 再 display 那个 report。

秋天的楓葉

有没有E－BOOK可以参考吗？ 偶要需要学＂水晶报告＂