|
-
May 15th, 2003, 06:13 AM
#1
Thread Starter
Lively Member
Crystal Reports in print queue
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?
-
May 15th, 2003, 07:11 AM
#2
Thread Starter
Lively Member
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.
-
May 15th, 2003, 11:51 AM
#3
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.
-
May 15th, 2003, 07:14 PM
#4
Thread Starter
Lively Member
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.
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
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.
Any idea what I can do here?
Last edited by Stryker; May 15th, 2003 at 07:33 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|