CODEWITHSUNDEEP
sqlexcelreporting-servicesparameters
Jumpman
Jumpman

Reputation: 67

Excel spreadsheet as parameter for report

Has anyone created a report that could use an Excel spreadsheet attached by the user as a parameter for the report? An example would be a list of potential customers in Excel, and whether they exist or don't exist in the database.

I know something like this is easier to accomplish with a manual SSMS query. However, we have several query requests similar to this which are common requests.

Basically want the user to attach their spreadsheet and compare it with data in the database and then spit out a comparison report.

Upvotes: 0

Views: 384

Answers (1)

Deepak Bhise
Deepak Bhise

Reputation: 171

Use SSIS job to load data from spreadsheet to database and then compare data in usual way with queries.

Upvotes: 0

Related Questions