Connect to SQL Server 2005 CE Database

I'm using VS 2008 and the included Crystal Reports. I'm having trouble making a connection to SQL Server 2005 CE.

Has anyone had success making this happen? As it is, I can connect through a dataset, but this leaves me with some limitations. Specifically, I'm having trouble working with datasets with more than one table. I can't set the report to agther data from two reports and I can't select any linked records, or dependent records (not sure if that's the right word) because I don't know how to use this line of code very well:

Code:

---

Me.ReportFile.SetDataSource(DsCustomersReports.Tables(0))

---

It looks like the Tables() array can only point to one table. Even if it could point to more, I wouldn't know how to set it up to send the right data to the right fields.

I want to connect directly to see if I can get around this problem using the wizards.