Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SSRS Hide/Show TextBox...
Microsoft Dynamics CRM (Archived)

SSRS Hide/Show TextBox in report

(0) ShareShare
ReportReport
Posted on by Shane Brown 190

 Hi

I am creating a report and have a text box which should only be visible if the option set field 'paymenttype' = 'Cash'.

What should i use for the expression?

62727.Capture.PNG

Thanks

*This post is locked for comments

  • Shane Brown Profile Picture
    Shane Brown 190 on at
    RE: SSRS Hide/Show TextBox in report

    Hi Andreas that doesnt really help unfortunately, any other ideas?

  • Andreas Cieslik Profile Picture
    Andreas Cieslik 9,267 on at
    RE: SSRS Hide/Show TextBox in report

    This could answer your last question:

    stackoverflow.com/.../how-can-i-specify-a-dataset-aggregate-in-this-ssrs-expression

  • Shane Brown Profile Picture
    Shane Brown 190 on at
    RE: SSRS Hide/Show TextBox in report

    Hi Andreas in my report I have 3 datasets and when i try to run as you saud above i get the following error.

    "The Hidden expression for the text bix 'TextBox35' refers directly to the field 'paymenttype' without specifying a dataset Aggregate. When the report contains multiple datasets, field references outside of a data region must be contained within aggregate function which specify a dataset scope."

    The Dataset i am using is Dataset1

  • Suggested answer
    Andreas Cieslik Profile Picture
    Andreas Cieslik 9,267 on at
    RE: SSRS Hide/Show TextBox in report

    =IIf(Fields!paymenttype.Value="Cash" OR Fields!paymenttype.Value="Credit" OR Fields!paymenttype.Value="Debit", true, false)

  • Shane Brown Profile Picture
    Shane Brown 190 on at
    RE: SSRS Hide/Show TextBox in report

    What if I want it only be visible for 'Cash' , 'Credit' & 'Debit'.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS Hide/Show TextBox in report

    =IIf(Fields!paymenttype.Value="Cash", true, false)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,309 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans