Coffeehouse Thread

6 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

SSRS data, needed features

Back to Forum: Coffeehouse
  • User profile image
    figuerres

    hey if anyone can pass this on to the sql ssrs folks:

     

    1)  first class support for calling a web service like web api

    2)  first class support for JSON as a "data set"  that can contain nested collections and objects.

    3)  be able to pass a collection to a sub report , then the sub report does not need to make a connection or a call.

  • User profile image
    Ian2

    That all sounds like stuff that should be in there already.  Have they throttled off on SSRS recently?

  • User profile image
    vesuvius

    @Ian2:No, SSRS does not have the ability to connect to REST  web services, the connection types are available here https://msdn.microsoft.com/en-us/library/ff519553.aspx (look at the menu on the left)

    I have just had to create a hybrid MVC/Webforms websitewhere we load the ASP.NET reporting control in an IFrame as there are no JavaScript based reporting components in SQL server, though I believe SQL 2016 will add better mobile support. SQL reporting 2016 will be the first real update since SQL 2008, that is how slowly things move in SSRS, I think we may get these features in SQL 2020

     

     

  • User profile image
    Ian2

    Colour me a little surprised (it's quite a while since I have used SSRS but it doesn't sound like it has kept pace)

  • User profile image
    figuerres

    Colour me a little surprised (it's quite a while since I have used SSRS but it doesn't sound like it has kept pace)

    the data engine has json now that is good.

    ssrs  did get some good updates but not enough of them.

     

    the core ssrs seesm to be still mostly the same as ssrs 2008/20012   but with the .Net 4 runtime and the portal updated for better html5 rendering.

     

    the report view controlls seem to still mostly be the same as prior one sbut they did drop the activex for printing.

    --use pdf file output to print now.

  • User profile image
    figuerres

    @Ian2:No, SSRS does not have the ability to connect to REST  web services, the connection types are available here https://msdn.microsoft.com/en-us/library/ff519553.aspx (look at the menu on the left)

    I have just had to create a hybrid MVC/Webforms websitewhere we load the ASP.NET reporting control in an IFrame as there are no JavaScript based reporting components in SQL server, though I believe SQL 2016 will add better mobile support. SQL reporting 2016 will be the first real update since SQL 2008, that is how slowly things move in SSRS, I think we may get these features in SQL 2020

     

     

     

    SQL 2016 SSRS  has some really nice mobile report options and KPI reporting options that can make a nice dashboard of charts and graphs for executives.

    *IF* you do not need the interactive view and you want a report retuned  you can call the report server api to render a pdf directly if you want that.

    i have a web api call that calls ssrs and returns a pdf to my front end, if you want some info on how to do that with 2016 i can help you out.

    also i think the interactive ui can be accessed with a bit of work w/o the asp.net server controll.

    the asp.net server controll mostly calls back to the soap api to do the work.

     

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.