Finance | Project Operations, Human Resources, ...

Field is showing some value and not showing some value in a report

(0) Share

Report

Posted on by Shabir Ahmad

3,090

Hi Experts,

Please check the above images, same report showing value for one field and for some value are not showing in that field. As example is city the city is entered in the form but not showing on the report but for some it shows. One thing more these report are not AOT reports these are RDL files i uploaded to Report server site and set it to reference to classes.So there is no deply just set its reference to class that is custom class.

Best Regards,

Shabir Ahmad

All responses (2)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Field is showing some value and not showing some value in a report

Hi Shabir,

Since this is a custom report and not within AX, I am not sure if we can help you with this as we can't check the logic used to fetch the value for City. The AX form looks customized as well.

Please check the following -

1. How is the City being displayed on the form? Is it a display method or a data field? You can find the underlying query for fetching this field value.

2. How is the SSRS report fetching the values? The query being used should be the same as that used on the form.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Field is showing some value and not showing some value in a report

Hi Shabir,

The characters exceed my knowledge and probably of many other community members.

Is there a chance that you generate the report in en-us language?

Best regards,

Ludwig