reporting services - Is it possible to build a fully interactive web app on top of SSRS? -

i'm new ms bi tools , after reading bit, feel sql server + ssis + ssas fulfill needs on modelling , analysis side.

however, on top of it, build web application allows user select present on columns, rows, filters apply , kind of chart represent data into. (drag , dropping or whatever, using html). of course, after modelling data on ssas. should somehow exposing report builder inside web app.

i wondering whether there's possibility consuming web services i've read ssrs exposes, because sure building such solution hand-coding quite complex. or ws, in contrast, made displaying reports created using visual studio enablers? i've read of creating rdl reports , rendering them, somehow possible , connected i'm looking for?

if it's not possible, alternative, if any?

thanks

if have @ ssrs web service methods (find here https://msdn.microsoft.com/en-us/library/ms155071.aspx) see none of methods allows functionality of creating report scratch.

most if not all, of methods used interact existing reports. example if want retrieve metadata of report or of report manager whole e.g retrieve list of reports, retrieve list of report paramaters.

you can execute administrative tasks programatically using web services, such executing schedule, moving reports 1 location in report manager etc.

putting web interface on top of these functions seem suitable.

however build actual report scratch through web services alone doesn't seem possible. way can think of doing build xml structure of rdl programmatically. quite undertaking , honest better off creating reports manually.

as alternative i'd consider moving self service bi tool such power bi/excel (if stuck on ms bi stack) or alternatives such qlikview or tableau. in case need developer create data model or dataset required analysis , leave user visualise report.