Re: Repoting tools and stored procedures?
On 7 Jan 1997, Jason Hay wrote:
> HI All,
> I am trying to develop some reports using a windows base report writer and
> using stored proc's as the data source for a report.
> I am yet to find a report writer that supports stored procedures on
> Informix.
>
> Is anyone else using stored procedures to produce reports on the windows
> platform(16 or 32)?
>
We used Crystal reports with NE 2.12, WIN 3.1.
It cannot use Sto. Proc. directly in the reports.
We create a Sto. Proc. and then create a view that uses the Stoproc and
then use that view to create the report.
create procedure student_pay( ssn)
----
----
end procedure
create view vw_stu_pay (ssn, fname, lname, pay) AS
SELECT ssn, fname, lname, student_pay(ssn)
from student
Then use the view to create reports.
> If so then I would be
interested to hear what reporting tool and > connectivity you are using.
>
> Thanks in advance for your help
>
> Jason Hay
>
>
Rajeev Nimmagadda SRK
rajeevn@jcdcrs4.jcdcnet.org # (512)393-7204
################################################################