[Solved] Referencing control on report

[Nocton]

I have a report for which I want to print a message according to whether one number exceeds another.
So I have made a label field with a Conditional Print expression.
One number is a field [GroupLimit] in the associated report table, but the other is a field on the report - I have named it 'GroupCount'. My problem is how to reference GroupCount in my Conditional Print expression. I have tried:
"GroupCount" >= [GroupLimit]

But that does not work. The Conditional Print expression does work if "GroupCount" is replaced with an actual number, e.g.
20 >= [GroupLimit]

I am using OOo 3.2.1

Regards, Nocton

[r4zoli]

The conditional print expression only for hide or print labels/fields.
You needs to use functions if you want to calculate values in report.

[Nocton]

I think you have misunderstood. I am printing a label. I just need to get the correct format for the expression.

[Nocton]

Further to this, as I have had no reply giving a solution, I explain again what I am trying to do.

I have a field - GroupLimit - in my table. The table is grouped by 'GroupName'. I am printing out several records showing members of each group in the detail of each GroupName. I can count the records printed and at present that is shown as a calculated field in the GroupName footer using Data Field Type 'Counter'. I want to print out a label/message when the no. of records printed exceeds GroupLimit. The way I was hoping to do it is as given in my first post, but if that cannot be done then maybe there is a better way to achieve what I want.

Regards, Nocton

[r4zoli]

Not clear to me your situation.
You use "old" type of reporting wizard within odb file, or use SRB/ORB, or .odt file created through mail-merge wizard, or writer document inserted fields.

[Nocton]

Using ORB 1.2.1. Report in Base. All I want is a warning message on the report when the no. of records printed exceeds a limit set in the table.

[Nocton]

Since I have had no solution to my problem, I have got round it by using a couple of queries to generate the no. of records to be printed in each group with the rest of the data to be printed. I can then reference the no. of records field within my conditional statement and all works as I want. Rather a long way round. But it works!

Regards. Nocton