web
You’re offline. This is a read only version of the page.
close
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 AX (Archived) / Field not showing in r...
Microsoft Dynamics AX (Archived)

Field not showing in report even though the field is in the design

(0) ShareShare
ReportReport
Posted on by Lionel07 495

Hello Everyone,

Am creating a query report in AOT but one of my field is not showing. The attached screen shot is the report layout in visual studio.... the settleAmountReporting is not coming out.... everything else comes out when i run the report but that field does not comes out. Can anyone tell me whats causing this?

4848.Capture11.PNG

The image below shows the query design. Any help would be greatly appreciated.

3301.Capture111.PNG

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    I don't see a valid reason why it should not after you have not used any group by etc.

    Did you tried restart of SSRS service and AOS service..? (in case if you feel this as cache issue)

    As you said everything else is coming so i can see TransDate from same table in the design. I cannot see a reason why the amount field should not.

  • Lionel07 Profile Picture
    Lionel07 495 on at

    Sohaib, That's what i thought. I have spent nights trying to understand why but am still unable to see why am not getting the values. I will continue trying.

    Yes, i did restart the service/server but still nothing.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Lionel07,

    1. Please check the table having data for settleAmountReporting or not.

    2. Check in design whether you assigned settleAmountReporting filed in report design.

    3. If still data is not showing after restarting the reporting services, then try delete the report in report server and redeploy your report.

  • Lionel07 Profile Picture
    Lionel07 495 on at

    Hello again, this has resurfaced on my radar, I have decided to try it using the SRSReportDataProviderBase. I am following a tutorial but I am stuck at the method- ProcessReport.

    This query works fine in SQL but how do I put it in X++

    Query:

    SELECT

       INVOICEID

      ,INVOICEACCOUNT

      ,INVOICINGNAME

      ,CUSTSETTLEMENT.DUEDATE

      ,CUSTSETTLEMENT.CREATEDDATETIME

      ,CUSTSETTLEMENT.TRANSDATE

      ,CustSettlement.SETTLEAMOUNTREPORTING  

      ,INVOICEAMOUNT

      ,PAYMENT      

      ,INVOICEAMOUNTMST

     FROM CUSTINVOICEJOUR join CUSTTRANS ON CUSTTRANS.INVOICE=CUSTINVOICEJOUR.INVOICEID AND  CUSTTRANS.AccountNum = CUSTINVOICEJOUR.InvoiceAccount

    and CUSTTRANS.TransDate = CUSTINVOICEJOUR.InvoiceDate

    and CUSTTRANS.Voucher = CUSTINVOICEJOUR.LedgerVoucher

    join CUSTSETTLEMENT

    on CUSTSETTLEMENT.TransCompany = CUSTTRANS.dataAreaId

    and CUSTSETTLEMENT.TransRecId = CUSTTRANS.RecId

    and CUSTSETTLEMENT.AccountNum = CUSTTRANS.AccountNum

    WHERE CUSTSETTLEMENT.DUEDATE = CUSTINVOICEJOUR.DUEDATE

    AND CUSTSETTLEMENT.DUEDATE between'2018-09-01' AND '2019-08-31'

    AND CUSTSETTLEMENT.TRANSDATE <'2019-08-31 0:0:0'

    AND CUSTINVOICEJOUR.INVOICEID LIKE 'ACP%'

    AND CUSTINVOICEJOUR.INVOICEACCOUNT='XXXXXX'

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans