Re: view vs. function vs. procedure - really basic question

Rank Novice (pnwms@xxxxxxxxx) 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@xxxxxxxxxxxxx

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

Relevant Pages

  • Re: Distributed queries and Crystal Reports
    ... Is it Crystal Reports 9 or 10? ... Those allow you to join stored procedures as ... > options to be set for the connection. ... > stored procedure, including setting the options in all possible ...
    (microsoft.public.sqlserver.programming)
  • Re: stored procedures, multiple selects, and crystal reports
    ... the dataset create the XSD for you. ... > I have a stored procedure which returns 3 tables. ... I've been having problems with the push method for large ... > from crystal reports editor. ...
    (microsoft.public.vb.crystal)
  • Re: SET FMTONLY On
    ... Created a new Crystal Reports 8.5 report. ... Pro SQL Server 2000 Database Design ... > I have a stored procedure which returns rows of data, ... > When I point crystal to the stored procedure I get an error message from ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing datasource locations
    ... I have tried this on both version 9 and 10 of Crystal Reports, ... stored procedure datatypes are re-declared." ... But it does work on all the DB platforms if one use a SQL Command to ... >> Stored Procedure to a SQL Command datasource is a bug? ...
    (microsoft.public.vb.crystal)
  • SET ANSI_NULLS ON & ANSI_WARNINGS ON
    ... This is driving me NUTS! ... I have a stored procedure (SQL Server 2000 and part of data from Linked ... The problem is that I can't seem to call this from Crystal reports. ...
    (microsoft.public.vb.crystal)
Loading