Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

RDL reporting expression for multiple Boolean

Posted on by 5

Hello ,

I want expression for below scenario in RDL(SSRS) reporting Expressions.

Columns Australia, Austria, Brazil, Canada and China are Boolean

I want to show "Australia, China" when both columns are true

Current the formula as below:

=Left(
  IIf(Fields!crms_australia.Value,"Australia, ", "") &
  IIf(Fields!crms_austria.Value,"Austria, ", "") &
  IIf(Fields!crms_brazil.Value,"Brazil, ", "") &
  IIf(Fields!crms_canada.Value,"Canada, ", "") &
  IIf(Fields!crms_china.Value,"China, ", ""),
  Len(
    IIf(Fields!crms_australia.Value,"Australia, ", "") &
    IIf(Fields!crms_austria.Value,"Austria, ", "") &
    IIf(Fields!crms_brazil.Value,"Brazil, ", "") &
    IIf(Fields!crms_canada.Value,"Canada, ", "") &
    IIf(Fields!crms_china.Value,"China, ", "")) - 2)
I used left function to get trim last 2 character ", " and if scope is repeated twice for the text and getting the length.

Would I know is that any better idea to get the countries from field?

Categories:

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans