SQL Compact 4.0 Connect ReportViewer

Question

Hi

I am building a local report in a MVC 4 app thats using SQLCE 4.0.

The method I am using worked perfectly in another app when using SQL 2012 but its not working using Compact 4.0.

When I try and set the Data Source Instance of the dataset, the value wont get accepted. I have tried using data adapters as well and I get the same result. However, using data adapters, I can see the data coming through when i test the query. I just cant view the data through the report viewer.

This is the error: 

• An error occurred during local report processing.
  • The report definition for report 'Report2' has not been specified
    • Object reference not set to an instance of an object.

How can I instantiate the dataset?

Anyone know how to get around this?

Thanks

 

Answer 1

Hi Geeee,

Thank you for your question. 
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 
Thank you for your understanding and support.

---

Maggie Luo
TechNet Community Support

Answer 2

Hello,

ReportViewer does not work well with MVC, its a known limitation and unsupported configuration. Can this issue be re-produced using ReportViewer in WebFarm ?

Thanks

Runeet

Answer 3

Hey Geeee,

Did you get a chance to try using RV in Web Forms with your current SQLCE 4.0 database ?

Thanks

Runeet

Answer 4

 Hi Runeet

Yes, I got it working thanks.