Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Having a problem with subreports!

Status
Not open for further replies.

cutiger93

Programmer
Jan 11, 2001
55
US
I have a main report and a subreport and both are using a stored procedure. When I preview the report in CR 7.0 I can see the report fine, but when I use the my CRM application to run the report it tells me that it "Cannot Open SQL Server". Seems to me that the connection information is not getting to the subreport. Does anyone know how to solve this. Thanks in advance.
 
Edit the subreport and do a "set location" on it
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top