Hi,

I’m using VB.Net to do a simple reporting module.
I have a report set up with a cross-tab.
The column I am trying to change dynamically is a DateTime column.
The group option for this column has been set to monthly.
How can I change the group options (to 6 monthly, quarterly, yearly, etc) programmatically?

TIA

Lines

PS I have done this for a 'group column' using the
following code - but now I need to do the same thing to a table column


Dim cReport As CrystalReports.Engine.ReportDocument
cReport = New RPT_MY_REPORT
Dim grpGroupOptions As CrystalReports.Engine.GroupOptions
grpOptions = cReport.DataDefinition.Groups.Item(0).GroupOptions
grpOptions.Condtion = rptType


' rptType
' 4 = Monthly
' 5 = Quarterly
' 6 = Six Monthly
' 7 = Yearly