Can I hide header of Report in browser, when I print using browser

Hi;
I am trying to use Printing in browser for reports which are developed in
SQL Reporting Services. Now, when I try to print reports using browsers and
go to file menu and select Print Preview then it preview all the stuff which
I have in browser including that header of report which is used to change
pages and exporting options. How can I hide that header when I print.
Thanks.
--
Essa, M. Mughal
Software Developer
iLogic Inc., CanadaOne solution would be to provide a "print format" button that would display
the report without the toolbar. (You can turn off the toolbar using URL
commands.)
"Essa" <essamughal@.hotmail.com> wrote in message
news:5E84C2B5-9753-4510-B5F3-14DD542920F3@.microsoft.com...
> Hi;
> I am trying to use Printing in browser for reports which are developed in
> SQL Reporting Services. Now, when I try to print reports using browsers
and
> go to file menu and select Print Preview then it preview all the stuff
which
> I have in browser including that header of report which is used to change
> pages and exporting options. How can I hide that header when I print.
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> iLogic Inc., Canada|||Printing from the browser is not recommended using SQL Server 2000 Reporting
Services (RTM and SP1). This issue will be addressed in an upcoming release.
Meanwhile, the recommened technique is to export to PDF and print using the
PDF file.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Essa" <essamughal@.hotmail.com> wrote in message
news:5E84C2B5-9753-4510-B5F3-14DD542920F3@.microsoft.com...
> Hi;
> I am trying to use Printing in browser for reports which are developed in
> SQL Reporting Services. Now, when I try to print reports using browsers
and
> go to file menu and select Print Preview then it preview all the stuff
which
> I have in browser including that header of report which is used to change
> pages and exporting options. How can I hide that header when I print.
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> iLogic Inc., Canada

Can I force printing?

I have a script or SP that takes a very long time to perform
multiple tasks, and after each one there is a PRINT statement
that shows the time and what was just accomplished, to help me
monitor what's happening and estimate how long it will take.
In a script, I can put a GO after each PRINT to cause the output
to appear immediately, but that's not possible inside an SP.
Instead, it seems the output goes to a buffer, and the buffer
is only output when a PRINT causes the buffer to become full.
Sometimes there is a long delay before the buffer fills. Is
there a way other than GO to cause immediate printing? (I
guess I could just use longer messages, and fill up the
buffer with every one, but that's not very elegant.)

Thanks,
Jim G
Countrywide Home LoansYou can use RAISERROR...WITH NOWAIT to cause messages to avoid buffering.
Messages will be displayed immediately when using a tool like Query
Analyzer:

RAISERROR ('my message', 0, 1) WITH NOWAIT

--
Hope this helps.

Dan Guzman
SQL Server MVP

<jim_geissman@.countrywide.com> wrote in message
news:1125531618.828313.53510@.z14g2000cwz.googlegro ups.com...
>I have a script or SP that takes a very long time to perform
> multiple tasks, and after each one there is a PRINT statement
> that shows the time and what was just accomplished, to help me
> monitor what's happening and estimate how long it will take.
> In a script, I can put a GO after each PRINT to cause the output
> to appear immediately, but that's not possible inside an SP.
> Instead, it seems the output goes to a buffer, and the buffer
> is only output when a PRINT causes the buffer to become full.
> Sometimes there is a long delay before the buffer fills. Is
> there a way other than GO to cause immediate printing? (I
> guess I could just use longer messages, and fill up the
> buffer with every one, but that's not very elegant.)
> Thanks,
> Jim G
> Countrywide Home Loans|||Thanks, Dan.

Jim Geissman

can an sql procedure start printing a report ?

How can i start printing a report from a trigger activated store procedure ?It's possible.
Basic process:
1. Set up printer delivery extension as described in the books online
(and test that it works nicely)
2. Set up subscription to send required report to printer extension.
3. Go to SQL Agent and find the newly created job. You'll see that the
actual step is just a stored procedure that launches an even in the Report
Server database. Copy --> Paste the step details into the relevant stored
procedure.
"elbert chavarro" wrote:
> How can i start printing a report from a trigger activated store procedure ?