All geek questions in one place

The expression for texttrun 'Textbox86.Paragraphs [0]. TextRuns [0]' contains an error: [BC30451] The name "IFF" was not declared

I am new and designing SSRS. The row groups used (district name, file_name, Employee_Name) and column groups (MetricsOrder, MetricsName, Year, Month).

Finally, it prints 2 general values.

First he prints the Total district, and the other - the total. I need to check some condition, and the value may differ by condition.

Here is my expression. Checking the weather - current month. If so, multiply the SUM values ​​with RR (Parameter). If not, just type SUM

IFF((MONTH(TODAY())=Fields!Month.Value),Sum(Fields!MetricValue.Value)*Parameters!RR.Value,Sum(Fields!MetricValue.Value)

When I ran the im report, getting the following error.

An error occurred while processing the local report. The definition of report '/ Report11TRIAL2 is invalid'. The expression for the texttrun expression 'Textbox86.Paragraphs [0] .TextRuns [0]' contains an error: [BC30451] The name "IFF" was not declared.

Can someone help me fix this error.

+4
source share
1 answer

I believe the expression should be:

IIF((MONTH(TODAY())=Fields!Month.Value),Sum(Fields!MetricValue.Value)*Parameters!RR.Value,Sum(Fields!MetricValue.Value)

IIF, not IFF.

+4
source

Source: https://habr.com/ru/post/1532243/

More articles:


All Articles