web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Expression for Amount ...

Microsoft Dynamics AX (Archived)

Expression for Amount in SSRS Report

(0) Share

Report

Report

Posted on by fajar

3,805

Hi,

Please help me.

i have output report like this :

5164.1.jpg

i want, if Amount = 0, the record not show in my report.

if i use expression for visibility, i get output like this :

3426.2.jpg

But, i want output report like below picture.

5582.3.jpg

Can i do it use expression in SSRS Report?

if i can, How?

Please explain to me.

Thanks u all, sorry for bad language.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report

You don't want to change visibility, you want to filter your data. If you want to remove these records from the whole form (and not just a particular section), don't deal with in in report design. Instead, modify the underlying query or RDP class.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

you can also think to set Row Visibility True/False based on expression such as below

=Iif(Fields!FieldName.Value = 0.0, False, True)

//that is outside AX and part of ssrs only.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#1

Martin Dráb 4 Most Valuable Professional

#3

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans