485
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?
The image below shows the query design. Any help would be greatly appreciated.
*This post is locked for comments
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'
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.
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.
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.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
