title: Generate PDF reports from SQL Server reports.rdl C#
body: <p>Let me start by asking for your patience as I am ignorant of SSRS and not so sharp on the WCF technology that I intend on using to perform the task I want.</p>
  
  <p>I have a SQL Server Express instance with data I want to get daily reports out of. I can not schedule tasks on SQL Server (and the reports server I think I can in the full blown but not in Express) , but I can schedule via windows task. </p>
  
  <p>So I am writing an application that will use predefined rdl's  to generate my reports and send the reports back via email. I am not sure how rdl's data connection is set from my C# application - I created rdl's in its own project, but it looks like I need to do rdlc conversions for my application. </p>
  
  <p>What I would like to do is query the database via the reports and then send those reports out in an email to a set group of recipients (pulled from their email field in the users=reports result table.</p>
  
  <p>[FYI] I also have a web application that might need to generate these same reports.</p>
  
  <p><strong>Now on to my question:</strong></p>
  
  <p>I am not sure if I even need WCF to do anything here, as it looks like from this post  <a href="https://stackoverflow.com/questions/2684221/creating-a-pdf-from-a-rdlc-report-in-the-background/2686205">Creating a PDF from RDLC report</a> that I can simply run that code and point to my data source and the bytes will be returned to me (so far fine for a desktop quick and dirty getter - I think)</p>
  
  <p>Now is the same functionality possible in a web application - it would be nice to reuse the same code.</p>
  
  <p>Can some one provide me with some proper guidance for this kind of functionality with the technologies involved - so I can code something proper and maintain KISS  principle.</p>