Solved

SSRS  integration

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

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 11

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 11

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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…

760 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

20 Experts available now in Live!

Get 1:1 Help Now