Passing values to subreport 1

[Cagliostro]

I've seen already a thread about passing values, but this does not seem to be right one for my sityation.

I have a main report what have fields A,B,C...
and I have a subreport what have a stored procedure as a source, for example MyProc.
I want the subreport to use field A as a parameter for MyProc.
The subreport have a query or a stored procedure as source
I want to call the procedure like this:
exec MyProc @A, @B, @C...
Or the query like this
select .... from XXXXX where A=@A and B=@B and C=@C...
Anyway, parameters @A, @B, @C have to be initialized with values from the main report fielts A, B, C.
Is that possible?

I'm using CrystalReport what comes with VisualStudio2005 (a reduced version)and the database MSSQL 2005

Ion Filipski

 

[Cagliostro]

lbass, are you there?

Ion Filipski

 

[Madawc]

In Crystal, it's best to try something and see if it works, rather than working out in advance if it's possible.

For a subreport, most fields from the main report can be passed using Edit > Subreport Links. I think it won't pass fields based on several records. You also have to associate it with a subreport field, even if you don't want to keep the connection.

Whatever you define as a link will be posted as a selection line in the subreport's record selection. You can then change it.

Does this help?

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

 

[Cagliostro]

hmm, I will try

Ion Filipski