Solved

SSRS  integration

Posted on 2016-07-27
  • .NET Programming
  • Visual Basic.NET
  • SSRS
  • MS SQL Server
  • MS SQL Server 2005
  • +1
5
90 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now