Crystal Report from Stored Proc?

Hello,
I have a crystal report, that selects data from a stored procedure. When I
use Sql Server 2000, every thing was ok, but one day, I did update both
VS.NET 2003 and Sql Server 2000 to VS.NET 2005 and Sql Server 2005. This
report gets correct result if I run on my computer (where the Crystal Engine
was setup from VS.NET 2005 package).But when I run the report on another
computer (where the Crystal Engine was setup from Merge Module from
BusinessObjects) report can not recognize all parameters in Stored Procedure
(note that, if the report selects data from a table or view then it works
ok everywhere, only wrong if it selects from a stored procedure).


.

Relevant Pages

  • VB.NET and design-time dataset generated control
    ... One of the modules has around 7 forms and each form will print one report. ... Stored Procedure as "GetCustDetails". ... In this .xsd file, one field is manullay added called "Select" ... Now I sent the binaries to the client. ...
    (microsoft.public.vsnet.general)
  • SOLUTION: Reports in ADP based on stored procedures; child rowset error
    ... I have a report that is based on a stored ... Then I just set the report's RecordSource ... Then I had to add a second parameter to the stored procedure. ... RecordSource property from my ADP report into the immediate window, copy it, ...
    (microsoft.public.access.reports)
  • SOLUTION: Reports in ADP based on stored procedures; child rowset error
    ... I have a report that is based on a stored ... Then I just set the report's RecordSource ... Then I had to add a second parameter to the stored procedure. ... RecordSource property from my ADP report into the immediate window, copy it, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Dynamic SQL based Crystal Reports
    ... or can I use one coded by hand to bind to? ... Create an stored procedure ... Fill the Dataset with the Report Data. ... > the Dataset - CR needs the proper dataset table names to load the data ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: inconsistent report problems
    ... adParamReturnValue parameter. ... Is this field associated with a control on the report or with the Sorting ... @Counties VARCHAR to something smaller. ... set the record source of the report to the stored procedure, ...
    (microsoft.public.access.adp.sqlserver)