linking a main report to a subreport based off a stored procedure

[misgirlny]

If anybody knows how to link a main report to a subreport on a parameter value if both are based off store procedures? I would like the main report's parameter values are passed to the subreports store procedures. I know how to do that if subreports a based off linked tables, but need to implement on stored procedure. I use Crystal 8.
Thank you in advance.

 

[Madawc]

I did several reports in Crystal 8.5, where the main report used a stored procedure and the subreports accessed the database. I'd just pass the relevant filed ([Subreport Links] under [Edit], letting it link to anything it was happy with.

I'd then replace the subreport selection with the value I actually wanted, creating a formual field to change the data type when necessary. I've never tried linking the output of two stored procedures, but the principle should be the same.

Madawc Williams
East Anglia, Great Britain

 

[misgirlny]

Thank you for you response. Unfortunately it does not work that way when subreport is based off a stored procedure with the same set of parameters that a main report. when I link the reports on a set of parameters, subreports promt for the main report passed parameters and for subreport's parameters, which is a double set. So far did not find any articles on CrystalDecisions KnowledgeBase site.