Error - Group Specified on non-recurring field.

building reports crystal reports
1

Hi,

I created a variable as follows.

"global numbervar pagebreak;
If ({CRY_.PRDCT}=“S” and previous({CRY_.PRDCT})=“S”) then
pagebreak := pagebreak
else
pagebreak := pagebreak + 1;
"

This working fine. And I created a group based on above variable.

While viewing the report, its throwing an error “Error - Group Specified on non-recurring field.”

Any one please help me in this?

Thank you,
Regards,

Gowtham Sen

GowthamSen :india: (BOB member since 2006-08-31)

2

Im failing to see how or why youd want to create a group on such a formula…

ABILtd :uk: (BOB member since 2006-02-08)

3

Thanks Andy.

In my report, I need to check the current column value and the previous value of the same column. Based on that I am defining a group.

GowthamSen :india: (BOB member since 2006-08-31)

4

I am not sure that is possible. You are creating a situation where you have to know the order of the records in order to determine the order of the records. How is that supposed to work?

BDeLong (BOB member since 2008-01-15)

5

Thanks BDeLong. I am not sure.

But can we apply a grouping on a particular column and sort it on different column?

Generally if we apply a group, it does sorting by default. Can we change this and apply sorting on different column?

GowthamSen :india: (BOB member since 2006-08-31)