locked
How to open a SSRS report using a web busines type in a screem

    Question

  • How to open a SSRS report stating the parameters in the code.
    by clicking on a link I want to open a specific report in SSRS. if the report has parameter I pass them in the code.

    in a windows forms application I can do this using reporting viewer component. but as I do this in v2 lightswitch
    Wednesday, March 28, 2012 12:52 AM

Answers

  • If you're adamant that you need the report viewer component, I best leave you in the capable hands of Derek at Spursoft.

    To others who would like to see SRSS reports via a browser I suggest you set your web link to the Report URL on your Report server and watch IE do its stuff. You might just like to try it on SQL Server 2012.

    http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx enjoy!

    Thanks, Keith


    E tenebris lux. ±

    • Marked as answer by Marden LR Saturday, April 07, 2012 4:55 AM
    Thursday, April 05, 2012 7:39 PM

All replies

  • Hi Sophia,

    thanks for the helpbut none of theselinkshelp :(
    they showhow to integratewith theasp.net Iwant to know ishow to integratewith thelightswitch

    Wednesday, March 28, 2012 10:05 PM
  • Shameless plug alert. 

    http://visualstudiogallery.msdn.microsoft.com/5617c9a0-c8e9-4a63-b3fc-b0356dad430f


    Derek

    Bad plug when you put in the wrong link.
    Friday, March 30, 2012 5:00 PM
  • where can I find a trial to test, or a demo to see how it works.

    Thanks.

    Saturday, March 31, 2012 12:20 AM
  • I am trying now to set up a demo site.  There is no trial.  I will post back here when the demo site is up.

    Derek

    Monday, April 02, 2012 2:56 PM
  • Thank you.
    Please when you are ready post the demo codes here.  let's make this topic a reference to your product.

    I'll wait for the demo.

    Monday, April 02, 2012 5:03 PM
  • I'm assuming you are running an OOB LS app and you want the report shown in a LS screen and not in a browser launched outside LS!

    Why don't you try out and mod Yann Duran's "Launch URL" approach and launch a browser within your screen and pass the Report Server url (with or without parameters) of the report you want to view!

    http://code.msdn.microsoft.com/Add-URL-To-LightSwitchs-0f74eef4

    Enjoy, Keith


    E tenebris lux. ±


    • Edited by PlusOrMinus Thursday, April 05, 2012 12:50 AM
    Thursday, April 05, 2012 12:45 AM
  • Hi PlusOrMinus,

    you could set an example:
     open a SSRS report passing parameter the start date and end date

    Thursday, April 05, 2012 1:25 PM
  • Whoops!

    I should have included Spazo's example:

    http://code.msdn.microsoft.com/How-to-make-Web-Access-in-ffba8c2d

    This collection of examples also shows how to display HTML (The default rendering of reports from the Report Server)  in the LS screen in an OOB app! You could equally use the approach to display your "online" help, Intranet site for app, ...

    Are you asking me to produce a working example? Do you know how to use SSRS? Do you know how to build reports with Report Builder? Do you know how to build a string, that you would normally use within a browser to look at your reports?

    I am toying with the idea that I should post a walkthrough example (C# - VB if someone volunteers to convert), when I have time, of how you can much enhance your LS apps with readily available (usually free - certainly for Express versions) reporting / printing tools that MS offer via SSRS. I can see why the LS team do not include a reporting tool, it would take up a lot of resource to support.

     Keith


    E tenebris lux. ±

    Thursday, April 05, 2012 2:24 PM
  • I already know all about how to create, edit and deploy a report in SSRS.
    In windows forms I can do what I want for there I use the report viewer component.
    but I need to do the same in the lightswitch. but he does not have the report viewer component :(

    • Proposed as answer by PlusOrMinus Thursday, April 05, 2012 7:18 PM
    • Unproposed as answer by PlusOrMinus Thursday, April 05, 2012 7:29 PM
    Thursday, April 05, 2012 3:28 PM
  • If you're adamant that you need the report viewer component, I best leave you in the capable hands of Derek at Spursoft.

    To others who would like to see SRSS reports via a browser I suggest you set your web link to the Report URL on your Report server and watch IE do its stuff. You might just like to try it on SQL Server 2012.

    http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx enjoy!

    Thanks, Keith


    E tenebris lux. ±

    • Marked as answer by Marden LR Saturday, April 07, 2012 4:55 AM
    Thursday, April 05, 2012 7:39 PM