Re: Report with multiple stored procs

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ken Briscoe (youcant_at_sendmespam.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 09:41:31 -0400

"Telus" <satkins@skircr.com> wrote in message
news:Mq7dd.26425$z96.18210@clgrps12...
> Hello all. I've been tring for awhile now to generate a report that has
> three stored procedures as its inputs. Basically I need to generate an
> invoice. Here is what each procedure returns.

I don't think CR supports links between stored procedures. I don't think
this means that you can't have multiple SPs in one report, but it means
there'll be no logical link amongst them. You may want to consider creating
one SP that outputs exactly (and only) what you'll need on your invoice. 

-- 
KB  -  MCNGP "silent thug" #26
first initial last name AT gmail DOT com

Relevant Pages

  • Re: inconsistent report problems
    ... And finally, personally, I never directly assign a recordset to a report. ... Sylvain Lafontaine, ing. ... @Counties VARCHAR to something smaller. ... hundreds of stored procedures I've written before. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: inconsistent report problems
    ... Is this field associated with a control on the report or with the Sorting ... @Counties VARCHAR to something smaller. ... hundreds of stored procedures I've written before. ... CREATE TABLE #TempCounties (County VARCHAR(30)) ...
    (microsoft.public.access.adp.sqlserver)
  • Report with multiple stored procs
    ... three stored procedures as its inputs. ... of products and payments made on an order. ... detail section that lists each product and its amount. ... Ideally I would then have a balance owing in the report or page footer. ...
    (microsoft.public.vb.crystal)
  • Re: Temporary table not dropping
    ... SQL Server MVP ... -- "Samuel Allan" wrote in message ... I have a couple of stored procedures that generate datasets> for reports. ... > My problem is that after running report A, and creating version A of the> temporary table, running report B causes the temporary table to be created in> the image of A. The first time I run report B it is fine, but all subsequent> runs of report B fail. ...
    (microsoft.public.sqlserver.programming)
  • Re: Dynamic Query Sets as RecordSource
    ... Hi Bob see the Stored procedures I created below and how I pass parameters ... When running reports in ADP and you are passing parameters you will be using ... Reference to passing parameters will be referenced in the Input Parameters ... Report Properties ...
    (microsoft.public.access.adp.sqlserver)