Showing posts with label printing. Show all posts
Showing posts with label printing. Show all posts

Thursday, March 29, 2012

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and


PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and


PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and


PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

sql

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and


PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

Direct Printing with RS 2005?

I have tried the PrinterDeliverySamples with RS2000 without success. I have
read about new printing functionality with RS 2005. Is direct printing per
subscription to a printer supported wit hthe bnew version or not? Or do they
still just offer those $()§$!"& PrinterDevliverySamples?
Thanks.
--
Markus Pöhler
netpoint-edv gmbh
GermanyThere is a printer delivery sample with SQL 2005. (I don't know if it is
like SQL 2k, because I never messed with the 2k one.)
However you compile this, install it, change some config files. AND a
subscriber can choose the printer and print to the printer as part of a
subscription... However, the printer must be defined at the RS IIS box, and
Reporting services must run on a domain account ( not local system)...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"MarkusPoehler" <MarkusPoehler@.discussions.microsoft.com> wrote in message
news:DBF063C1-4D16-4891-A80A-6D9BD070456C@.microsoft.com...
>I have tried the PrinterDeliverySamples with RS2000 without success. I have
> read about new printing functionality with RS 2005. Is direct printing per
> subscription to a printer supported wit hthe bnew version or not? Or do
> they
> still just offer those $()§$!"& PrinterDevliverySamples?
> Thanks.
> --
> Markus Pöhler
> netpoint-edv gmbh
> Germany|||you can run under the local system
or network service accounts if you install the printers under all users and
computers. you'll need to use the rundll32 with the printui to do it, but
there are several script that already do it. you will also need to turn off
the printer validation on the ValidateUserData function in the sample.
Cade Roby
Lead Developer
Wolverine Power Supply Coop.
10125 W. Watergate Ave.
Cadillac, MI 49601
"Wayne Snyder" wrote:
> There is a printer delivery sample with SQL 2005. (I don't know if it is
> like SQL 2k, because I never messed with the 2k one.)
> However you compile this, install it, change some config files. AND a
> subscriber can choose the printer and print to the printer as part of a
> subscription... However, the printer must be defined at the RS IIS box, and
> Reporting services must run on a domain account ( not local system)...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "MarkusPoehler" <MarkusPoehler@.discussions.microsoft.com> wrote in message
> news:DBF063C1-4D16-4891-A80A-6D9BD070456C@.microsoft.com...
> >I have tried the PrinterDeliverySamples with RS2000 without success. I have
> > read about new printing functionality with RS 2005. Is direct printing per
> > subscription to a printer supported wit hthe bnew version or not? Or do
> > they
> > still just offer those $()§$!"& PrinterDevliverySamples?
> >
> > Thanks.
> > --
> >
> > Markus Pöhler
> > netpoint-edv gmbh
> > Germany
>
>

Direct Printing

Hallo,
we have a Windows Application in .Net.
Now we want to use Reporting Services. That is no problem.
But how we can print direct on a client pc?Hi sqlhaas,
You can do this by installing a new printer extension for RS. Take a look
at this article (under Yesterday's QOD):
http://www.sqlservercentral.com/newsletter/452004newsletter.htm
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
sqlhaas wrote:
> Hallo,
> we have a Windows Application in .Net.
> Now we want to use Reporting Services. That is no problem.
> But how we can print direct on a client pc?|||Check Bryan's log http://blogs.msdn.com/bryanke/articles/71491.aspx.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Jake Marx" <msnews@.longhead.com> wrote in message
news:u%23nFdEQvEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi sqlhaas,
> You can do this by installing a new printer extension for RS. Take a look
> at this article (under Yesterday's QOD):
> http://www.sqlservercentral.com/newsletter/452004newsletter.htm
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>
> sqlhaas wrote:
> > Hallo,
> > we have a Windows Application in .Net.
> > Now we want to use Reporting Services. That is no problem.
> > But how we can print direct on a client pc?
>

Direct printing

Hi there,
I know there has been a lot of discussions and irritations that RS does not
offer direct printing, instead the user has to export to pdf(or another
format) and then open that and print the report from there, but I would like
to know if it something that Microsoft is working on and if so when it may be
available.
Surely with the amount of interest shown in the printing it will be soon?
ThanksCurrently we are looking at including client side printing in the next
version of SQL. We have heard the cries of pain and are also looking at the
possibility of including it our next service pack. As of this time though we
have made no formal announcement on what will or won't be included in the
next SP.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"PLSH" <PLSH@.discussions.microsoft.com> wrote in message
news:FE9846D1-B924-4FEB-97B2-28C7D720D3AE@.microsoft.com...
> Hi there,
> I know there has been a lot of discussions and irritations that RS does
not
> offer direct printing, instead the user has to export to pdf(or another
> format) and then open that and print the report from there, but I would
like
> to know if it something that Microsoft is working on and if so when it may
be
> available.
> Surely with the amount of interest shown in the printing it will be soon?
> Thanks|||So basically you guys at Microsoft created this great product for viewing
reports and doing great things but figured when someone wants to view it they
surely wouldn't want to print and therefor left that part out . . . . . and
now after all this time still haven't included it? Ok, just wanted to make
sure.
Come on guys your product kicks @.ss, please can we have a way of printing
our reports without having to export them, open them and then print them.
Hopefully someone will come up with a reletively easy way to print soon.
PLEEEEEEASE!!
"Daniel Reib [MSFT]" wrote:
> Currently we are looking at including client side printing in the next
> version of SQL. We have heard the cries of pain and are also looking at the
> possibility of including it our next service pack. As of this time though we
> have made no formal announcement on what will or won't be included in the
> next SP.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "PLSH" <PLSH@.discussions.microsoft.com> wrote in message
> news:FE9846D1-B924-4FEB-97B2-28C7D720D3AE@.microsoft.com...
> > Hi there,
> >
> > I know there has been a lot of discussions and irritations that RS does
> not
> > offer direct printing, instead the user has to export to pdf(or another
> > format) and then open that and print the report from there, but I would
> like
> > to know if it something that Microsoft is working on and if so when it may
> be
> > available.
> >
> > Surely with the amount of interest shown in the printing it will be soon?
> >
> > Thanks
>
>

Friday, February 24, 2012

Different Font size when browsing and printing a report ?

Hi all,

Is it possible to setup different font size when a user is browsing or printing a report?

I have a lot of data to print on a report and i need tu use a font size of 7pt which is fine for printing but when the user is looking at the report on the browser a font size of 7pt is a bit too small and the bold doesn't work.

Tia

You can use a parameter (Web, Print) which would specify the font size 7, 12, and set the font property on the textbox to use the =Parameters!FontSize.Value + 'pt' expression.

I don't think the report can tell whether it's being printed or not internally.

cheers,

Andrwe

|||

Thanks Andrew,

I was hoping to find a way to do this without prompting the user beforehand.

Regards,

Eric

|||I am trying to implement the same thing , where i can make font size smaller than 8pt but show as font weight bold. any help will be appriciated.