Results 1 to 4 of 4

Thread: Crystal Reports in print queue

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    108

    Angry 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?

  2. #2

    Thread Starter
    Lively Member
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    108
    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.

  3. #3
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    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.

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    108
    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
  •  



Click Here to Expand Forum to Full Width