title: SQL Server Compact Edition and reporting. Is SSRS an option?
body: <p>I need to create a simple, stand-alone application that will allow for users to input some data and then print a report.  I would prefer to use SSRS as a reporting engine but I also want to keep my data store very simple.  </p>
  
  <p>I have another, sizable smart-client application that uses SQL Server Express edition as a user back-end.  From experience, SQL Server Express is certainly an option, however, integrating a database creation and maintenance process is a bit of a nightmare, due to various end-user constraints.</p>
  
  <p>SQL Server CE is much easier to use for my needs, if that is an option.  Can I use SQL Server Compact Edition with SSRS?  </p>
  
  <p>Yes, I am aware that I will still need to install SQL Server Express if I want to use SSRS.  I'm fine with that requirement.  My primary concern is that I'd rather not have to automate the database creation process within SQL Server Express, which is what I have to do with the other smart-client application I mentioned. </p>
  
  <p>Instead, I'd rather use a local SQL Server CE database file that I can bundle with my application and connect to from within SSRS.  Can this be done?</p>
  
  <p>If this isn't possible, is there some other, simple alternative (excluding the use of Crystal Reports) that would allow for simple reporting and inclusion of a database file with the application installer?</p>