Need Help on Sharepoint and SSRS Integration

Hi,

We have a requirement to consolidate the data from two different sources (i.e, from SQL database and SharePoint list) and this consolidated report needs to be sent in an email.

We need to achieve this OOTB in SharePoint 2010.

We have tried the below approach:

Created SSRS report (i.e., RDL file) which will accept two parameters “From Date” and “To Date” to get the SQL data; so that, we can capture the data from report and save it in the SharePoint list. Once the data is available in SPList we can trigger an email using SP Designer workflow.

We tried to read the HTML content from report using JQuery, but we are unable to capture the report data. Report data is not available in page view source.

Please let us know if anyone has any alternate solutions or a work around for this requirement.

Thanks,

Prasanna