RandomActofKindness
Programmer
Hi,
I have a report that contains a subreport. The report passes the subreport a clientid, and a locationid. The subreport is from a stored procedure (in SQL server 2000). What I want to do is take the clientid parameter that is passed from the report to the subreport and pass that to the stored procedure (The stored procedure is: create proc myproc(@cid) as...). However, I can't find a way to set the @cid parameter field that is automatically created in Crystal to equal to the clientid passed from the main report. Is this even possible? Any advice is appreciated.
Cheers
I have a report that contains a subreport. The report passes the subreport a clientid, and a locationid. The subreport is from a stored procedure (in SQL server 2000). What I want to do is take the clientid parameter that is passed from the report to the subreport and pass that to the stored procedure (The stored procedure is: create proc myproc(@cid) as...). However, I can't find a way to set the @cid parameter field that is automatically created in Crystal to equal to the clientid passed from the main report. Is this even possible? Any advice is appreciated.
Cheers