Click here to Skip to main content
Click here to Skip to main content

Setting Crystal Report Margin at Runtime

, 21 Feb 2008
Rate this:
Please Sign up or sign in to vote.
This article discusses how you can create a dynamic Crystal Report and set its Margin at runtime.

Introduction

This article discusses how you can create a dynamic Crystal Report and set its Margin at runtime.

Using the Code

The below function fills dataset's table from the Northwind database, and at form load, it loads the report and sets its datasource.

//
// Any source code blocks look like this
 Private Sub FillDataTable()
        Dim strQuery As String
        strQuery = "select * from  [Current Product List] "
        Dim sqlConn As New SqlConnection("Data Source=.;_
	Initial Catalog=NorthWind;UID=sa;Password=lumensoft2003;")
        Dim da As New SqlDataAdapter(strQuery, sqlConn)
        Try
            da.Fill(objdsReport, "dtProduct")
        Catch ex As Exception
            MsgBox(ex.Message, MsgBoxStyle.Critical)
        Finally
            sqlConn.Dispose()
            da.Dispose()
        End Try
    End Sub

// on form load

    Private Sub frmReport_Load(ByVal sender As System.Object, _
	ByVal e As System.EventArgs) Handles MyBase.Load
        RptViwer.Width = Me.Width
        RptViwer.Height = Me.Height
        Dim objDoc As New CrystalDecisions.CrystalReports.Engine.ReportDocument
        FillDataTable()
        objDoc.Load(My.Application.Info.DirectoryPath + "\rptProduct.rpt")
        ' as 1 inch equal to 1440 tups
        objDoc.PrintOptions.ApplyPageMargins_
	(New CrystalDecisions.Shared.PageMargins_
		(1 * 1440, 1 * 1440, 1 * 1440, 1 * 1440))
        objDoc.SetDataSource(objdsReport)
        RptViwer.ReportSource = objDoc
    End Sub

//

If you have any questions, please email me at mailto:altafamber@yahoo.com.

History

  • 22nd February, 2008: Initial post

License

This article, along with any associated source code and files, is licensed under The Common Development and Distribution License (CDDL)

About the Author

altafsagar

Pakistan Pakistan
No Biography provided

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web03 | 2.8.140709.1 | Last Updated 22 Feb 2008
Article Copyright 2008 by altafsagar
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid