Port Crystal VB6 Code to .NET Crystal API
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=21559
Printed Date: 23 Apr 2024 at 12:40am
Topic: Port Crystal VB6 Code to .NET Crystal API
Posted By: keithf1138
Subject: Port Crystal VB6 Code to .NET Crystal API
Date Posted: 22 Jun 2015 at 8:24am
So I am moving some Crystal Report logic from VB6 to .NET. For some of the more complex reports the code sets the value for grouping. I figured out how to set the 1st item in the SortFields array. What I cant find is how to set the first item in the GroupSortFields array because well GroupSortFields doesnt exist in the .NET API. I have a number of reports that uses this syntax and need to get the code that invokes them converted. Amazes me that this isnt simply documented, but I havent found anything.
Here is a simplified version of the VB6 code
CR1.ReportFileName = fullPathAndFileNameToRpt
CR1.Connect = dataConnectionString
CR1.ParameterFields(0) = "SortField;" & rptParameter & ";TRUE"
CR1.SelectionFormula = ""{Manager_Category1.List}"="SomeValue""
CR1.GroupSortFields(0) = "Sum({@ABSWeightedValue},{Manager_Category1.Category1})"
CR1.SortFields(0) = "{@ABSWeightedValue}"
CR1.PrinterStartPage = 1
CR1.PrinterStopPage = 1
Also can you tell me what GroupSortFields and SortFields map into the report?
|
Replies:
Posted By: keithf1138
Date Posted: 26 Jun 2015 at 5:03am
|
Wow is this such a hack that no one knows how to accomplish the same thing with .NET code. I am just asking not being critical. I inherited this code base and never did a great deal of Crystal Reports work so just looking for some help to get these final few reports executing properly.
|
|