Filtering using an expression

bjmullan · Post by **bjmullan** » Wed Nov 30, 2011 6:39 am

I am current struggling with getting Filtering of a report to work with an expression.

My expression is {Count(DataBand,Fields.NAMEBRIGD) * Count(DataBand,Fields.NAMEBRIGD) * Sum(DataBand,Fields.TOTAL_DAYS)} and I would like the report only to show record above a specific value. When I add any of the following expression into the dialogue I get errors;

{Count(DataBand,Fields.NAMEBRIGD) * Count(DataBand,Fields.NAMEBRIGD) * Sum(DataBand,Fields.TOTAL_DAYS)} < 100

{(Count(DataBand,Fields.NAMEBRIGD) * Count(DataBand,Fields.NAMEBRIGD) * Sum(DataBand,Fields.TOTAL_DAYS)) < 100 }

What is the syntax I should use? And sorry for the stupid question

Post by **HighAley** » Thu Dec 01, 2011 2:27 am

Hello.

bjmullan wrote:I am current struggling with getting Filtering of a report to work with an expression.

My expression is {Count(DataBand,Fields.NAMEBRIGD) * Count(DataBand,Fields.NAMEBRIGD) * Sum(DataBand,Fields.TOTAL_DAYS)} and I would like the report only to show record above a specific value. When I add any of the following expression into the dialogue I get errors;

{Count(DataBand,Fields.NAMEBRIGD) * Count(DataBand,Fields.NAMEBRIGD) * Sum(DataBand,Fields.TOTAL_DAYS)} < 100

{(Count(DataBand,Fields.NAMEBRIGD) * Count(DataBand,Fields.NAMEBRIGD) * Sum(DataBand,Fields.TOTAL_DAYS)) < 100 }

What is the syntax I should use? And sorry for the stupid question

Where a your trying to add this filter?
Please, send us your report template.

Thank you.