I gang

Automation of SSRS (3) Reports built and Export to Excel

Automation - SSRS Report to Excel

We have SQL Server 2008 r2, and office 2010. I have created stored procedures that write to SQL tables. Skills needed: SSRS, Excel, .Net, SSRS scheduling of reports and stored procedures, Visual Studio 2008, and SQL Server 2008 r2

We have multiple hospitals (Hosp#1, Hosp#2, etc) . Need a way to automate the process to create the attached Excel report has 3 tabs, so 3 reports per hospital. Not sure how SSRS will know to get the next hospital view and export to Excel.

- Preferred scenario for Freelancer in SSRS (but open to better solution:

I need SSRS to do the following:

• Need (3) reports created in SSRS with logo

• Create a reports in SSRS like the attached Excel with charts, formulas, and functionality based on SQL server tables and views. Each section in the attached file is a separate table and query. Not sure how to do this in SSRS.

Automation part:

• Schedule SSRS to run SQL stored procedures that will write to SQL server tables and update views

• Then export SSRS report to Excel keeping the formatting and charts.

• Then schedule the next job in SSRS to export the next report to Excel

• Need Tabbed SSRS report for each hospital (all hospitals have the same format) Just need to make sections visible or not visible based on if id for hospitals has data for it or not.

. Also need a way to change the logo and hospital name for each hospital.

Attached is a better version of the hospital excel file.

Thanks,

Ben

Færdigheder: .NET, Rapport Skrivning, SQL

Se mere: write to freelancer, views for freelancer, update skills freelancer, ssrs job, reports freelancer, report formatting freelancer, preferred freelancer how, logo 123, i need a freelancer to create a logo, how to write reports, how to write report format, how to write on freelancer, how to write a job report, how to update skills in freelancer, how to open freelancer, how to get job of freelancer, how to get freelancer job, how to get freelancer 1.0, how to get a job in freelancer, how to get a freelancer job, how to do reports, how to do logo, how to create name logo, how i have a job of freelancer, freelancer update skills

Om arbejdsgiveren:
( 24 bedømmelser ) Pleasanton, United States

Projekt-ID: #5987572

Tildelt til:

abdellatif81

Hired by the Employer

$25 USD / hour
(11 bedømmelser)
4.8