Creating reports and dashboards | Stimulsoft community forum

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

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.