Solved

SSRS  integration

Posted on 2016-07-27
  • .NET Programming
  • Visual Basic.NET
  • SSRS
  • MS SQL Server
  • MS SQL Server 2005
  • +1
5
95 Views
Last Modified: 2016-07-28
Hello,
How to integrate SSRS in vb. Net desktop app. I am using 2015 visual studio
Cheers
0
Comment
Question by:RIAS
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Nakul Vachhrajani
ID: 41732884
The 10,000 mile outline of what you need to do is:
1. Use the ReportViewer control
2. Store the Report Manager (WebService) URL of your reporting server somewhere
3. Store the path of the report on the Report Server in a table (alternatively, in case of pick & choose reports, you can iterate through the report directory and file list from the web-service)
3. When you want to display a report, build the Report URL (Webservice URL + Report Path) and invoke the Report Viewer control

I will try to see if I can get a tutorial for this somewhere.
0
 

Author Comment

by:RIAS
ID: 41732886
Cheers mate! i am using desktop vb.net app ,will it work ?
0
 
LVL 12

Accepted Solution

by:
Nakul Vachhrajani earned 500 total points
ID: 41732887
Here are tutorials that I could find:
- Integrating Reporting Services into Applications: https://msdn.microsoft.com/en-us/library/ms153697.aspx
- Integrating Reporting Services 2005 Into a Web Application: http://www.codeproject.com/Articles/15469/Integrating-Reporting-Services-Into-a-Web-App
1
 
LVL 12

Expert Comment

by:Nakul Vachhrajani
ID: 41732888
Yes, ReportViewer controls are available for on-premise (i.e. Windows app) too.
1
 

Author Closing Comment

by:RIAS
ID: 41732942
Cheers!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question