I can make reports with access dbs using CR8.

I tried to connect to make a report with SQL Server, I create and test the connection using the report expert, then go on to create the report.

When I try to open the report from vb, I get this error:
'Server has not yet been opened'

Any idea what I have missed?