HI Hector,

thanks for the reply.  

I can confirm i have a successful connection to the sql compact database and see data when i press the test query button.

I can also confirm the path is correct by copying the result into windows explorer.

The data being returned looks like:

I am using vs2010 and wpf (vb.net).

I have only just started to look at the infragistics reporting so i will most likely be doing something silly.

1. All i have done is added the item "Infragistics Report" to the project
2. Added a datasource (sqlcompact 3.5) and specified the table. Pressing the test connection returns data.

I just tried dragging the datasource field onto the report (Expr1) and pressed the preview button and i get the error 

"Infragistics.Reports.Engine.EngineException: Error in DataContext =DataSources.sqlDataSource3.
An error occurred while binding an expression."

What am i doing wrong?  

Do i need to use the Report Viewer object?

Hi

The string did include the "Microsoft....."

As you suggested i changed it to:

<add name="WpfApplication1.MySettings.sqlDataSource3" connectionString="Data Source=C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5\Samples\Northwind.sdf;Persist Security Info=True"
providerName="System.Data.SqlServerCe.3.5" />

However i still get the same error when i press the "Preview" button. 

Infragistics.Reports.Engine.EngineException: Error in DataContext =DataSources.sqlDataSource3.
An error occurred while binding an expression.

I have started a blank project to rule out any other conflicts.  I have no code populating any data objects, nor do i have any report viewer configured.  Do i need to do this or should the "Preview" button "just work"?

Are you able to do a very simple example pulling data from the northwind database?

I will do that, however, do you get a window like the following when you create the connection?

EDIT: Try rebuilding, closing and reopening the report, just in case.

Attached a simple example that uses the Northwind database using SQL Compact Edition (4.0 in this case, but it should be almost identical in 3.5).

Note that the image data of the Employees table in the Northwind database has an OLE header, which would cause the employee photo not to be displayed. If you want to display such images, you would need to use an Object Data Source and manually remove such header. One does not need to do so for normal images.

Hi Hector,

sorry, i am receiving the same issue with your sample.

This is what i did.

1. Uninstalled SQL Compact 3.5 SP2
2. Uninstalled SQL Compact 4.0
3. Installed SQL Compact 3.5 X86
4. Installed SQL Compact 3.5 X64
5. Installed SQL Compact 4
6. copied northwind db to location specified in app.config
7. I get the exact same error

I also did a test where i renamed the db and then pressed the "Preview" button.  I get the exact same error.  Could it be that the designer cannot see the database file when previewing?

run the upgrade utility and all is well again :).

Hi Hector,

I just opened my original WPF project and it will no longer compile since running the service release.

I am receiving alot of errors similar to below:

Warning 15 Could not resolve this reference. Could not locate the assembly "InfragisticsWPF4.Controls.Editors.XamMaskedInput.v12.2, Version=12.2.20122.2022, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb, processorArchitecture=MSIL". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. WpfApplication1

How do i resolve this?  

No problem, glad I could help. Feel free to post anytime!

:)  Happy Days.

Must have been the service release.

Thankyou for your assistance (and patience).

I will no doubt have a few more questions as i start using the reporting tool but i will raise them in separate threads.

thanks again

pfechner

I am able to properly display the report with the solution provided.

However, I can also see from the solution provided that you have 12.2 Volume Release installed, you need to install the latest service release.