Solved

Call a SQL Reporting Services report from Windows App

Posted on 2006-11-20
2
216 Views
Last Modified: 2010-04-23
hi

i need to open a reporting services report in pdf format from a button_click() in a windows forms application.

i currently use:

Dim PI As New System.Diagnostics.ProcessStartInfo("iexplore.exe")
Str = Str & "&rc:Parameters=false&rc:Zoom=Page Width&rs:Command=Render&rs:Format=PDF"
PI.WindowStyle = ProcessWindowStyle.Maximized
PI.Arguments = Str
System.Diagnostics.Process.Start(PI)

but this is messy as it leaves open a "page cancelled" ie browser... is there any way i can just click on the button and the pdf report open directly?
many thanks

j
0
Comment
Question by:A4eIT
  • 2
2 Comments
 
LVL 14

Expert Comment

by:Ramuncikas
ID: 17978447
Your code launches IE, so here is nothing to complain about.
You need a bit different approach to the problem.

http://www.vbdotnetheaven.com/Code/Jul2003/2107.asp

Download pdf to user's temp dir and then launch Acrobat Reader (or even use ShellStart=True).

HTH
Ramuncikas
0
 
LVL 14

Accepted Solution

by:
Ramuncikas earned 500 total points
ID: 17978466
Or you can use My.Computer.Network.DownloadFile(<url>,<path>) if you're using .NET 2.0/VS2005.

But I think both cases will need authentication.

Don't hesitate to ask for further assistance if needed.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

816 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

10 Experts available now in Live!

Get 1:1 Help Now