Solved

Printing Multiple Reports using .NET 2005 and Crystal

Posted on 2012-04-04
8
557 Views
Last Modified: 2012-04-11
I have an application that has a requirement to print multiple reports as one.  It will print one report.  When I add a second report, it will print the first report, then it logs a memory error.  I am thinking that maybe there is a property not set right.  Below is the code, then the error message.  Any help would be greatly apprecialted.  Using .NET 2005 and Crystal XI R2.

Public Class frmPrintJob
    Inherits System.Windows.Forms.Form

    Dim rsr As CrystalActiveXReportViewerLib11_5.ReportSourceRouter = New CrystalActiveXReportViewerLib11_5.ReportSourceRouterClass()
    Dim bPrintCalled As Boolean = False
    Friend WithEvents CrystalViewer As AxCrystalActiveXReportViewerLib11_5.AxCrystalActiveXReportViewer

    Dim last_msg As String = "<>"

#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()
        rsr = New CrystalActiveXReportViewerLib11_5.ReportSourceRouterClass
        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    Friend WithEvents txtStatus As System.Windows.Forms.TextBox
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(frmPrintJob))
        Me.txtStatus = New System.Windows.Forms.TextBox
        Me.CrystalViewer = New AxCrystalActiveXReportViewerLib11_5.AxCrystalActiveXReportViewer
        CType(Me.CrystalViewer, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'txtStatus
        '
        Me.txtStatus.ForeColor = System.Drawing.Color.Navy
        Me.txtStatus.Location = New System.Drawing.Point(8, 8)
        Me.txtStatus.Multiline = True
        Me.txtStatus.Name = "txtStatus"
        Me.txtStatus.ScrollBars = System.Windows.Forms.ScrollBars.Both
        Me.txtStatus.Size = New System.Drawing.Size(408, 112)
        Me.txtStatus.TabIndex = 2
        Me.txtStatus.Text = "_Status"
        '
        'CrystalViewer
        '
        Me.CrystalViewer.Enabled = True
        Me.CrystalViewer.Location = New System.Drawing.Point(428, 135)
        Me.CrystalViewer.Name = "CrystalViewer"
        Me.CrystalViewer.OcxState = CType(resources.GetObject("CrystalViewer.OcxState"), System.Windows.Forms.AxHost.State)
        Me.CrystalViewer.Size = New System.Drawing.Size(711, 592)
        Me.CrystalViewer.TabIndex = 0
        '
        'frmPrintJob
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
        Me.ClientSize = New System.Drawing.Size(1365, 621)
        Me.ControlBox = False
        Me.Controls.Add(Me.CrystalViewer)
        Me.Controls.Add(Me.txtStatus)
        Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle
        Me.MaximizeBox = False
        Me.MinimizeBox = False
        Me.Name = "frmPrintJob"
        Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen
        Me.Text = "Print Statements"
        Me.TopMost = True
        CType(Me.CrystalViewer, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)
        Me.PerformLayout()

    End Sub

#End Region
    Public Sub add_status(ByVal desc As String)
        If last_msg <> desc Then
            txtStatus.AppendText(desc & vbCrLf)
            last_msg = desc
        End If

    End Sub

    <CLSCompliant(False)> Public Sub add_report(ByVal r As CRAXDRT.Report)
        add_status("    Adding - " & r.ReportTitle)
        rsr.AddReport(r)
    End Sub

    Public Sub show_reports()
        CrystalViewer.ReportSource = rsr
        CrystalViewer.RefreshEx(True)
        add_status("Refreshing Data")
        CrystalViewer.ViewReport()

    End Sub


Here is the error message from the log:

4/4/2012 10:48:22 AM EXCEPTION REPORTED
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
   at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at System.Windows.Forms.NativeWindow.DefWndProc(Message& m)
   at System.Windows.Forms.Control.DefWndProc(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.AxHost.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.RunDialog(Form form)
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at System.Windows.Forms.Form.ShowDialog()
0
Comment
Question by:Meeskas
  • 4
  • 3
8 Comments
 
LVL 18

Expert Comment

by:vasto
ID: 37808119
You are using .NET with Crystal reports COM objects.  I can see "UnsafeNativeMethods" in the provided  error message. Did you try to use managed components instead ?
0
 
LVL 1

Author Comment

by:Meeskas
ID: 37808820
Not sure what you mean.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37808971
The dll CRAXDRT is a COM dll and is not licensed for use with .Net applications.

You will have to use the .Net viewer and code methods

mlmcc
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 1

Author Comment

by:Meeskas
ID: 37812931
But I have Crystal XI R2 installed.  Doesn't that license me to use CRAXDRT?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37814782
Yes, with VB6 no longer with .Net.  

mlmcc
0
 
LVL 1

Author Comment

by:Meeskas
ID: 37815220
Then why is the CRAXDRT dll included in the XI R2 bin?  What are you supposed to use instead?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 37818157
It is there for some kind of compatibility.  In further reading, CRAXDDRT is actually used by the .Net IDE to allow you to design reports.


http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/e0eb394f-931e-2b10-3b82-9413bfc3f457?QuickLink=index&overridelayout=true&29669634095258

CRAXDRT is included with CR XI so you can use it in VB6 applications.

mlmcc
0
 
LVL 1

Author Comment

by:Meeskas
ID: 37834973
Thanks for your help and the links to the documentation.  I basically recoded everything to use ReportDocument instead of CRAXDRT and to use only the .NET assemblies.  Everything works now.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

772 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