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.