What you should do is when they click on a button you should use the URL
which specifies the report, the parameters and the rendering as PDF. Then
the user can print the resultant PDF.

Call the button print preview and then it will make sense to them.

Bruce



"Jean-Nicolas BERGER" <j-n.enlevezmoi.berger@club-internet.fr> wrote in
message news:eZ7Bo7ZjHHA.5012@TK2MSFTNGP06.phx.gbl...
[quoted text, click to view]

I do this with the new winform control that comes with VS 2005 but I do not
know of any way to do what you want. URL integration (which is what you have
to use) has its limits. Perhaps someone else will have an idea.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Jean-Nicolas BERGER" <j-n.enlevezmoi.berger@club-internet.fr> wrote in
message news:e8oSJNajHHA.5012@TK2MSFTNGP06.phx.gbl...
[quoted text, click to view]

Hello,
I'd like to print SQL Server 2005 reports automaticaly within VB6.
For example, a clic on a button on a Client.frm form should print the
Client's name, list of commands, ...
I've tried something with the IE ActiveX control, but it seem's that I can't
control the render when there are several pages.
Thanks for your help.
JN.

[quoted text, click to view]
Thanks Bruce, but the name of the button should be "Print" and not
"Preview". The users don't want to click twice.
Is there a solution?
Do you have an example?
Thx.
JN.

Hello,
We are having a VB application and we call the reports using URL and passing
parameters to render in Excel Format. This opens an IE browser minimised and
pop-up with a File Download Dialog box.
User would like to avoid this File Download Dialog and always "Open" the
Excel file directly.
Is there a way to avoid this dialog??
If not, any programmatic way to open the rendered Excel file without
invoking IE directly from VB application.

Thanks for your help.