Microsoft Dynamics AX (Archived)

To Hide the Data of the Fields which displays zero's in the quantities

(0) Share

Report

Posted on by Community Member

I had a Report in which it is displaying the data of some fields as zero.

Example:

I am having a Report which is to be displayed as

S.No Items Description Bags Quantity No of Packet Total

1 GSR Nothing 10 5 10 25

2 GLR Nothing 5 5 5 15

3 G Nothing 0 0 5 5

4 D Nothing 2 0 0 2

5 R Nothing 0 0 0 0

My requirement is not to display the data of S.No 5 totally.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (0)

Report

You can add a range in your form's data source's Query for fieldValue> 0, or whatever field you want to use to determine whether to hide a record, when value is zero, or when all of them are. It will then not display any records with zero quantity. Assuming that is what you need, since all values are zero for the row you mentioned?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

by using this range i am facing an issue that two more fields are not displaying which are greater than 0

Was this reply helpful? Yes No
Suggested answer

axk 925 on at

Like (0)

Report

Hey Danda,

What if you set your query ranges for all fields to have value different from 0? As I understood, you want to hide records, which all values are 0.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

You wanted to hide records for which adding a range is a correct answer, but in your next reply now you are talking about hiding fields, which is not the same. If you indeed want to hide records but you are hiding more, then your query range must be incorrect.

You could verify it easily by doing Control+G to show the filters above your grid, apply the filters manually to have the desired results. Then right click on a field>Personalize>Query tab, verify what ranges do you have for your datasource and do a screen capture.

Then modify the code of the form to apply the query range in the init() of your form datasource table, run the form, and again see what ranges do you have in the query.

If they are not the same of what you are expecting, again, your applied range is wrong.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ya i completed it but it raised another issue of not showing two records which are greater than zero

Was this reply helpful? Yes No
Zain Bokhari 3,208 Moderator on at

Like (0)

Report

What I understand is that you want to filter out the records which show a total count(all columns) of zero.

Can you show us what you did and where? Screen shots maybe?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

But put the range as <0,>0 for not displaying the values that are having Zero.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Why don't you use this?

SysQuery::valueNot(0)

msdn.microsoft.com/.../sysquery.valuenot.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Now The issue had already solved.

Before solving the issue you have send Mr. Vilmos

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

I fully understand that you think it is solved, however, I wanted to point out that it is better to rely on helper classes like SysQuery, and should familiarize yourself with those tools for your own sake to improve your code quality. In this case you are hardcoding values for the range which would fail during code review that are used by larger implementation teams, thus I suggested to use a better alternative.

Was this reply helpful? Yes No