Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Printing Multiple Reports using .NET 2005 and Crystal

Posted on 2012-04-04
8
Medium Priority
?
573 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 101

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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 101

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 101

Accepted Solution

by:
mlmcc earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

782 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