ReportViewer + SQLCE Local DB + Multi-table Query.. is this possible?

[thebatfink]

Hi. I am trying to create a report using report designer tool in VS2010. I have a database in my project already but whenever I start this report, it wants me to create a new dataset and not allow me to use my existing..

So I create a new dataset, add all the tables to it, but it will only let me create a report on a single table within this dataset. What I would like to do is create a report based on a query.. is this possible? if so.. how?

 

[Lotok]

I wrote a short blog post last year on switching out the Datset, it was a quickie so not too concise. If you still need help ask.
The Curve | ReportViewer With Dynamic Datasource

You know you can also use a custom class etc as datasource though (not mentioned on blog post). The Report files are just XML and the initial creation just sets what data types etc are expected.

 

[thebatfink]

Hi, thanks for the reply. No doubt my lack of experience is to blame here, but that just leaves me scratching my head even more.

I don't understand why there are reporting functions built in, but that they can't even do a simple thing like join tables. Its a fundamental part of database design for the last 30-40 years? Is it really the case that there are no simple report building tools for applications using local databases and not sql server?

 

[Lotok]

You can use a custom class as the data source. Create a class to hold your data and populate it however you choose.

Sent from my GT-I9100 using Tapatalk 2