Microsoft Dynamics CRM (Archived)

how to write the expression to count the no of fields in SSRS.

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I am trying to write a expression that calculate the no of record in a form.

I have a two different fields named car park 1 and car park 2 as given bellow.

In my ssrs report, i need to count the no of the records from fields .

my condition is, if only car park 1 contains data then count should be 1 and if car park 1 & 2 both contains data then the count should be 2 otherwise 0 .

i am finding trouble to write the expression .

please help me to solve this error.

Thank You in advance.

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Kishor Kumar 3,702 on at

Like (0)

Report

RE: how to write the expression to count the no of fields in SSRS.

www.experts-exchange.com/.../SSRS-and-evaluating-if-a-Dataset-Field-contains-a-certain-value.html

ashwaniashwin.wordpress.com/.../count-the-no-of-fields-containing-values-in-ssrs
Community Member Microsoft Employee on at

Like (0)

Report

RE: how to write the expression to count the no of fields in SSRS.

how i write a expression for if field contains data ?
Suggested answer

Kishor Kumar 3,702 on at

Like (0)

Report

RE: how to write the expression to count the no of fields in SSRS.

Hi Check this,

stackoverflow.com/.../count-expression-ssrs-report
Sindre Wetting on at

Like (0)

Report

RE: how to write the expression to count the no of fields in SSRS.

You can use a nested if for this, e.g IIF(condition;true;IIF(condition;true;false)), but considering your scenario it should look something like this:

IIF (CarPark1.Value != '', IIF(CarPark2.Value != '', 2, 1), 0)