Posted by Erland Sommarskog on 07/24/05 11:09

Rank Novice (pnwms@yahoo.com) writes:
> I'm a developer, not a DB admin. I'm writing a .NET app that uses
> crystal reports.
>
> The table I need to output is built inside a stored procedure. No
> choice, it makes use of some temporary tables. (Believe me I've tried
> to get around that.)
>
> Crystal reports seems to only know about tables and views. It looks
> like a view cannot call procedures. It can call functions, but in turn
> they also can't call procedures. I am hosed, what now?
>
> Performance is not a factor here, small data sets, I just gotta get the
> thing working.

We use Crystal a lot in our shop. And stored procedures with a lot of
temp tables.

Our Crystal does not even now that there is an SQL Server database at
the other end. The "database" we present for Crystal is a TTX file, which
defines the fields for the report. We feed Crystal the data it needs
by passing it ADO recordsets (we are still on VB6). While you can use
ADO recordsets from .Net with the OleDb .Net data provider, this is not
something would like to do. I don't know, but I would expect Crystal to
be table to be fed a data set as well.

As David said, asking in a forum for Crystal might be a better strategy.
I know that Business Objects (or whatever the company is called) has
web forums on their web site.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]