Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

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

Posted on by 2,988

CitiesReport1.pngCitiesReport2.pngCitiesReport3.png

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

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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

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... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans