Thursday, March 29, 2012
Directly print to Printer
I have a VB Application with Crystal Report 8. If I click the print button in VB, I dont want to show the Crystal Report. I want to print the contents of the report directly to the Printer without showing the report. Is there a way to do this?
Thanks in advance
MadhivananFrom memory, so.........please forgive any errors from failed memory......:-))
assumes using CR active x control:
Dim objPrintApp As CRAXDRT.Application
Dim objReport As CRAXDRT.Report
Set objPrintApp = New CRAXDRT.Application
Set objReport = objPrintApp.OpenReport(strReportSourcePath & strSourceFile)
objPrintApp.LogOnServerEx "pdsodbc.dll", "database", "database", "user", "pwd"
' set PromptUser to False, NumberOfCopies to value >=1
' all parameters in brackets are optional.
objReport.Printout [PromptUser], [NumberOfCopies], [Collated], [StartPageNumber], [StopPageNumber]
dave|||Thanks springsoft. I think this is for CR9 but what is the code for CR8?.
Madhivanan
Directing batch pring jobs to a remote printer
Has anyone tried directing batch sql reporting services print jobs to a remote printer? Any tips on how to do this would be appreciated.
Thanks,
John
Directing batch pring jobs to a remote printer
Has anyone tried directing batch sql reporting services print jobs to a remote printer? Any tips on how to do this would be appreciated.
Thanks,
John
Direct Printout of PDF still not possible?
I've been doing some research on the problem, that it is not possible to
print out a report in a PDF directly. The "open" or "save" dialogue comes up
first. I did read in some postings that there should be a possibility after
SP2 of the reporting services. By the way, I am using the 2000-Version of
the RS. Still, I can't find a proper solution to send a PDF directly to the
acrobat reader.
Does anyone has a solution to this?
Thx in advance.
Regards
MichaelWhy would you want to do this' View the reports through report manager,
.pdf files surely just makes them unedittable, how can that be helpful
unless you want to present them in an email or something and in that case
you would want to save the reports so you had a back up?
Sorry if i've missed the point but i can't see why you'd want to do this?
bob
"Michael Bender" <technik@.salescom.de> wrote in message
news:dl2776$f5o$02$1@.news.t-online.com...
> Hi everybody,
> I've been doing some research on the problem, that it is not possible to
> print out a report in a PDF directly. The "open" or "save" dialogue comes
> up first. I did read in some postings that there should be a possibility
> after SP2 of the reporting services. By the way, I am using the
> 2000-Version of the RS. Still, I can't find a proper solution to send a
> PDF directly to the acrobat reader.
> Does anyone has a solution to this?
> Thx in advance.
> Regards
> Michael
>
Direct Printing
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 Print using URL in 2k5
URL
http://xxx.xxx.xxx.xxx/ReportServer?%2ffolder%2fReport&Parameter=LAPTOP&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html
I saw in a previous post where GetImage is no longer available. This URL
was lifted from behind the print button on the report viewer control in SRS00
SP2. However when I grab the URL in 2k5 we have this
ReportViewerWebControl.axd?ReportSession=
Is there a way to fake this report session so I can still direct URL print?
I have seen the previous posts recomend using the report viewer control,
that works great in some cases just not this one. I dont want to show the
report to the user just promt them to print it.
ThanksHey Fred,
I have the exact same requirement to print directly via a URL. Did you
ever find an answer/solution to this issue? Any help or suggestions/links
you can provide would be most appreciated (I have looked high and lo for
answers).
Michael C
"FredG" wrote:
> In SRS 00 sp2 we were able to call the printer direct by using the following
> URL
> http://xxx.xxx.xxx.xxx/ReportServer?%2ffolder%2fReport&Parameter=LAPTOP&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html
> I saw in a previous post where GetImage is no longer available. This URL
> was lifted from behind the print button on the report viewer control in SRS00
> SP2. However when I grab the URL in 2k5 we have this
> ReportViewerWebControl.axd?ReportSession=> Is there a way to fake this report session so I can still direct URL print?
> I have seen the previous posts recomend using the report viewer control,
> that works great in some cases just not this one. I dont want to show the
> report to the user just promt them to print it.
> Thanks
>sql
Direct print possible?
using the ReportViewer control?On Apr 10, 2:28 am, georges <geor...@.discussions.microsoft.com> wrote:
> Is it possible to print a report directly without having to first preview it
> using the ReportViewer control?
What .NET language and environment are you using?
In C#, ASP.NET, this should help:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/e82168c08b00ce18/33d2f61564ce1a2a?lnk=st&q=print+reporting+services+in+asp.net&rnum=2#33d2f61564ce1a2a
Regards,
Enrique Martinez
Sr. Software Consultant
Direct print in RS 2000 no longer works in RS 2005 --what's the secret?
I have a Windows Forms application in VS 2005 that displays reports inside a
System.Windows.Forms.WebBrowser. The user can print using the print icon
within the browser window, but I also have a big Print button on the form
that prints directly. Now, with RS 2000, my print button worked fine, I
directed the ActiveX control to directly print like this:
rsBrowser.Navigate(ReportServicesPath & SpecifiedReportURL &
"&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html")
But, I've now upgraded to SQL 2005 and RS 2005, and this code doesn't work,
although printing via the print icon still works fine. What is the
equivalent of the above code for RS 2005'
The above code puts an error into the browser window:
>>
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
a.. Specified argument was out of the range of valid values. Parameter
name: offset
<<
I looked at the error log, but it is impenetrable to me.
Thanks,
C17Hello C17,
I understand that you want to use the URL access to print the report.
In Reporting Services 2005, the RC parameter prefix is changed and you
could not use the GetImage now.
I would like to suggest you use the ReportViewer control.
Here is the article for your reference:
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.report
viewer(VS.80).aspx
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you. The ReportViewer control looks like a better way to display
reports anyway. I will switch over to it.
--C17|||Hello C17,
If you have any question, pleae feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
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.