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 I find the default printer

I have successfully modified the routines from here http://msdn2.microsoft.com/en-us/library/ms252091(VS.80).aspx and can print OK on the Development machine but I have had to code the default printer name

I want to be able to get the users default printer and also set the orientation I don't know if this is possible in ASP

I have been able to get the default printer but cannot change the orientation any ideas?

To Get and Set the default Printer works OK
PrintDocument printDoc =newPrintDocument();
string printerName = printDoc.PrinterSettings.PrinterName;//Get the name
printDoc.PrinterSettings.PrinterName = printerName;//use the name

This below does not seem to work??
printDoc.PrinterSettings.DefaultPageSettings.Landscape =true;

|||

HI,jnc:

Try to change this line :

printDoc.PrinterSettings.DefaultPageSettings.Landscape =true;

To this:

printDoc.DefaultPageSettings.Landscape =true;

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Perfect timing, I was just revisiting this and your solution worked fine