Add Sort Fields
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2210
Printed Date: 19 Apr 2024 at 9:56am
Topic: Add Sort Fields
Posted By: Joe_G
Subject: Add Sort Fields
Date Posted: 01 Feb 2008 at 10:04pm
|
Can someone please help ?
 Inside Button click.... using Visual Studio 2005
I am trying to add sort fileds to my reports. I can't seem to get the code to WORK !!!!!! I need to do it this way from VB.net 2005 Dim crReportDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument Dim sDatabaseFile As String = "c:\data\mydata.mdb" Dim sTableName As String = "tmpTable" Dim crDatabaseFieldDefinition As CrystalDecisions.CrystalReports.Engine.DatabaseFieldDefinition Dim crSortField As CrystalDecisions.CrystalReports.Engine.SortField Dim crSortFields As CrystalDecisions.CrystalReports.Engine.SortFields
crReportDocument.Load( "C:\reports\myReport.rpt")crReportDocument.DataSourceConnections.Item(0).SetConnection(sDatabaseFile, sTableName, False)crDatabaseFieldDefinition = crReportDocument.Database.Tables( "tmpTable").Fields("Last_Name")' Note I have no sort fields in reports. Need to add sort fields ! crReportDocument.DataDefinition.SortFields.Item(0).Field = crDatabaseFieldDefinition 'Invalid index error ?
crSortFields = crReportDocument.DataDefinition.SortFields crReportDocument.DataDefinition.SortFields(0).SortDirection = CrystalDecisions.Shared.SortDirection.AscendingOrder CrystalReportViewer1.ReportSource = crReportDocument P.S. anyone know of a good book that has this kind of sample code in it. That can help me manipulate reports at runtime. |