Multiple Instance of Stored Proc in a report

[stuartgmilton]

Hi folks,

I have a report based on a stored proc which takes parameters.

Is it possible to have multiple instances of this stored proc within a report which have different parameter values?

And further to this, is it possible to have different sp's within the same report.

I always come across the same problem of error messages or, only one parameters screen comes up??

HELP! )

Stuart

 

[Madawc]

I'd have thought you could re-write the stored procedure to collect data into the same table on the basis of different parameters. If this is a problem, ask at the SQL forum.

I doubt it would be possible to have two stored procedures in the same report, except using a subreport, which would be inefficient. Rather, it would be inefficient unless the subreport is run just once, in the report header or footer. If this is what you want, then save your report under another name and then import it as a subreport.

Crystal version makes a difference. In Crystal 8.5, you couldn't even combine stored procedure detaisl with regular tables.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10