Import an Excel Spreadsheet into ReportWriter and generate Excel files

Is there a way import a complex Excel spreadsheet in RS and use that to generate new spreadsheets with having Excel installed? TIA!

David L. Crooks

asked Oct 20 '09 at 12:19 PM in Default

dcrooks
41 ● 2 ● 2 ● 2

(comments are locked)

1 answer:

If you wanting to use a SSRS model to report from the Report Builder you can create a view that looks at the EXCEL sheet as a "linked server".

Once the view is created you can create a dsv with SSRS and then you will be able to report off that model.

Then, using the export function or subscription you can generate xls/csv files.

answered Oct 20 '09 at 01:27 PM

sp_lock
8.1k ● 20 ● 26 ● 29

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Oct 20 '09 at 12:19 PM

Seen: 1639 times

Last Updated: Oct 27 '09 at 01:37 PM