<div>
I don't think you can do this. You can create 2 subreports with crosstabs - 1 grouped by date and another one by month and hide the wrong subreport based on a parameter
</div>


I don't think you can do this. You can create 2 subreports with crosstabs - 1 grouped by date and another one by month and hide the wrong subreport based on a parameter

<div>
Thanks. &nbsp;I was afraid that was the case. &nbsp;I like your suppress idea. &nbsp;Thanks.
</div>


Thanks.  I was afraid that was the case.  I like your suppress idea.  Thanks.

<div>
Why the need for subreports?<br />
<br />
You can use 2 cross tabs on the report and suppress one of them<br />
<br />
Another idea<br />
Add a parameter to select the monthly or quarterly<br />
<br />
Add a formula to the report<br />
Duration<br />

<pre><code id="code-20-39328589-1">Local StringVar x;

If {?Duration} = &quot;Quarter&quot; then
(
If Month({tblHoursWorked2012.Started}) &lt;= 3 then
   x := &quot;1&quot;
Else If Month({tblHoursWorked2012.Started}) &lt;= 6 then
   x := &quot;2&quot;
Else If Month({tblHoursWorked2012.Started}) &lt;= 9 then
   x := &quot;3&quot;
Else If Month({tblHoursWorked2012.Started}) &lt;= 12 then
   x := &quot;4&quot;;
)
Else
   x := CStr({tblHoursWorked2012.Started},&quot;MM&quot;);

CStr({tblHoursWorked2012.Started},&quot;yyyy&quot;) &amp; &quot;-&quot; &amp; x</code></pre>
<br />
Use the formula duration to cntrol the crosstab<br />
<br />
mlmcc
</div>


Why the need for subreports?

You can use 2 cross tabs on the report and suppress one of them

Another idea
Add a parameter to select the monthly or quarterly

Add a formula to the report
Duration


Local StringVar x;

If {?Duration} = "Quarter" then
(
If Month({tblHoursWorked2012.Started}) <= 3 then
   x := "1"
Else If Month({tblHoursWorked2012.Started}) <= 6 then
   x := "2"
Else If Month({tblHoursWorked2012.Started}) <= 9 then
   x := "3"
Else If Month({tblHoursWorked2012.Started}) <= 12 then
   x := "4";
)
Else
   x := CStr({tblHoursWorked2012.Started},"MM");

CStr({tblHoursWorked2012.Started},"yyyy") & "-" & x


Use the formula duration to cntrol the crosstab

mlmcc

<div>
<div class="content wysiwyg-content">
How can I change a cross tab column (a date) from grouping monthly to quarterly at runtime?
</div>
</div>


How can I change a cross tab column (a date) from grouping monthly to quarterly at runtime?

change crosstab group option from monthly to quarterly during runtime

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.