Error:The summary/ running total field could not be created. 1

[namas]

Environment: Crystal 8.5


Main report has subreport. It is linked by Year, Period and GL account.
Period is a numeric parameter field which accepts range values.

In the sub-report Select expert, I want to modify the
criteria for period to accept minimum value of Period passed from the main report.
It throws the following error:

The summary/ running total field could not be created.



{gl_balance.GL Year} = {?Pm-gl_balance.gl_year} and
{gl_balance.Gl Period} < minimum({?Pm-gl_balance.gl_period}) and
{gl_balance.GL Account (short)} = {?Pm-gl_balance.gl_acct}

How to fix it? Thanks.

 

[synapsevampire]

Sounds like it isn't recognizing it as a range.

Try:


{gl_balance.Gl Period} < {?Pm-gl_balance.gl_period}

That may work the same way.

Or try:

datevar LowerDate := minimum({?Pm-gl_balance.gl_period});
{gl_balance.GL Year} = {?Pm-gl_balance.gl_year} and
{gl_balance.Gl Period} < minimum({?Pm-gl_balance.gl_period}) and
{gl_balance.GL Account (short)} = {?Pm-gl_balance.gl_acct}

-k