Printable View
Can anyone tell me if there is a way to stop crystal reports queuing print jobs as 'Crystal Reports ActiveX Designer - test.rpt'.
I would very much prefer to have the reports as coming from my app, instead of that handle.
Is this possible ... and if so, how?
Can nobody offer any advice here ... its driving me mad. I'm not even sure that I'm opening the report the right way, and if I am ... why do I get this annoying problem.
Surely somebody must have come across this before. :(
What version of Crystal? How are you opening/viewing the reports in VB.
Look for an ApplicationName property. The Report object of the CRAXDRT library (version 8.5) has it.
Ok ... had a chance to calm down a bit now. Now lets see here.
I'm using Crystal reports 8.5 and I'm using the following code to open the report.
This is what I am doing so far, but as I say ... it prints out OK ... just with that annoying caption in the print spooler. Of course ... I'm going to be trying to print to specific printers soon (using selectprinter) but, well .. thats another problem.Code:Dim rptApp As New CRAXDRT.Application 'Used to load report
Dim rptCurrent As CRAXDRT.Report 'holds report object
Dim strSQL As String 'Holds SQL info
Dim rsData As ADODB.Recordset
Set rsData = New ADODB.Recordset
'//some code here to get the report name and the sql to use
'open the database
OpenDataSource App.Path & "\Data\data.mdb"
rsData.Open strSQL, ACon, adOpenKeyset, adLockOptimistic, adCmdText
'open the report
Set rptCurrent = rptApp.OpenReport(App.Path & "\data\report\" & reportname)
'attach data to report
rptCurrent.Database.SetDataSource rsData
rptCurrent.ReadRecords
'testing
rptCurrent.ApplicationName = "Working"
rptCurrent.DisplayProgressDialog = False
rptCurrent.ReportTitle = "Test"
rptCurrent.ReportAuthor = "Me"
rptCurrent.ReportComments = "Hello"
rptCurrent.ReportSubject = "Jimbob"
rptCurrent.PrintOut False
Any idea what I can do here? :confused: