Solved

Visual FoxPro Crystal Reports Viewer Programmatically Printing the Selected View (page Tab) on the Crystal OLE Control

Posted on 2011-09-28
8
863 Views
Last Modified: 2012-05-12
I am using the Crystal Reports 9 ActiveX Ole Control on a Visual FoxPro 9 form. I am able to run reports correctly. Because we wanted our users to be able to select different printers besides their Windows default printer, we have over-ridden the control's print routines and display a standard Windows printer dialog. All this has been working fine.

My question involves reports with the ability to drill into groups. If our users drill into a group and then print, only the results from the preview tab are printed. How can I specify to print from the active view (page tab the user is sitting on when they click print)?
0
Comment
Question by:ContrAcct
  • 5
  • 3
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 36718740
How are you printing?
If you are printing through code you may have to capture the drill in parameters and pass them to the report.  Not sure you can do that.

There is a printer select control you can put on the report.  They should be able to et the printer then use the print icon to print the current page.

mlmcc
0
 

Author Comment

by:ContrAcct
ID: 36718845
There must be a way to specify the active view for printing. I know how to find the active view index, I just need to know where to pass that value.

My form has an Ole Crystal control, and the control has a property that stores the report object. I have a custom printing routine that subverts the objects standard print routine. My VFP 9 code for printing is as follows:

Local llReturnValue, lnSelect, lnOriginalOrientation 
lnSelect = Select()
llReturnValue = .T.
llPrintToFileEnabled = .F.
Store "" to lcPortName, lcPrinterName, lcPrintRange
Store 0 to lnCopies, lnCollate, lnFromPage, lnToPage, lnOrientation

lnOriginalOrientation = this.oReport.PaperOrientation

lnReturnValue = WindowsPrinterDialog(llPrintToFileEnabled, @lcPrinterName, @lcPortName, @lnCopies, @lnCollate, @lcPrintRange, @lnFromPage, @lnToPage, @lnOrientation)

With this.oReport
	If InList(lnReturnValue, 1, 2) && Print or apply

		.SelectPrinter("", lcPrinterName, lcPortName)
		.PaperOrientation = lnOriginalOrientation 

		If lnReturnValue = 1
			llCollate = lnCollate = 1
		
			Do Case
				Case lcPrintRange = "RANGE"
					.Printout(.F., lnCopies, llCollate, lnFromPage, lnToPage)
				Case lcPrintRange = "CURRENT"
					lnPageNo = this.GetCurrentPageNumber
					.Printout(.F., lnCopies, llCollate, lnPageNo, lnPageNo)
				Otherwise 
					.Printout(.F., lnCopies, llCollate)
			EndCase
		EndIf
	EndIf
EndWith

Select (lnSelect)
Return llReturnValue

Open in new window

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 36744090
I don't know how to do it.

mlmcc
0
 

Author Comment

by:ContrAcct
ID: 36817424
Does anyone else have any ideas?
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:ContrAcct
ID: 36818303
What about using the Crystal Reports Print Control ActiveX object? Does any have an foxpro experience with printing using that control?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 36818331
0
 

Accepted Solution

by:
ContrAcct earned 0 total points
ID: 36905088
Found a Crystal Reports Viewer 11.5 ActiveX Control that uses a better Windows printer dialog. It prints correctly. As a warning to others, though, it does not like to be placed on a modal form. Previous versions of the Viewer ActiveX Control could be jerry-rigged to work correctly. 11.5 could not.

Thanks anyway.
0
 

Author Closing Comment

by:ContrAcct
ID: 36935276
The other answers were barely helpful and actually dismissive.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now