Hi, Actually there is no error message. It just that the Calculated field in Coldfusion report builder
cannot COUNT the records if you put the calculated field in the GROUP header band of the design.
But if I put the calculated COUNT field in the footer it worked fine. Thats why I'm confused coz in the crystal report either way the calculated count field worked okay.
Thanks for the reply.