VS 2008 Crystal Basic: SQL Server 2005 CE connection

[ssmith147]

I am trying to connect Crystal Reports Basic to a SQL Server CE database but the wizard doesn't seem to allow this- or I don't understand the basics of SQL Server CE well enough yet.

Can someone tell me how to make the connection, if this is even possible? If its not, what should I do to create a reporting system for the software I'm developing?

Thanks for any help offered!

[Hack]

Have you looked at the SQL Server Reporting Services?

[ssmith147]

Briefly, but not in depth. With so many options its taking me some time to explore all the sensible potentials, and if I'm not mistaken the SQL Server option is at the bottom of the list!

I have had some success in creating datasets in the new project and then using those datasets as the source for the report. However, I have not yet tested those reports in debug mode to see if any information is pulled from the database (just ran out of time yesterday). Its first on my list to try as soon as I get some time after work.

If I need to use the SQL option, is there any advice you can offer me on the subject?