End user Transfer variable to SQL to get results in a Excel file? MS SQL
By - Beavisx_K_90
If your dataset isn’t too large and the user input/filtering is minimal, could you pull all of the data in to a refreshable spreadsheet and let them use filters on the columns? I may be oversimplify your question.
SSRS can do this. It's not the fastest thing in the world when it comes to generating large datasets in a spreadsheet, but it'll do the job.
Look in to that. Suspect its the easiest thing you can do without exposing end users to any SQL at all.