Reporting in visual basic with SQL server compact edition

See more:

SQL-CE

Visual-Studio

, +

Hi All,

I have an application which uses Sql server compact 4.0 as a database, and written in Visual basic. Now for further development I want to add reporting in it. I have install Crystal report on visual studio 2010 SP1 but found that there is no way to connect SQL server compact edition in it. There are few ways I found which uses datatable but datatable only support Sql server compact 3.5

It will be very grateful if someone can suggest me any reporting software other than Crystal Report or any way to connect Sql server compact 4.0 to CR or any way to downgrade sql server compact 4.0 to 3.5.

What I have tried:

I have tried using crystal report with DSN, but unfortunately there is no ODBC drivers for Sql Server compact edition.