I have created report which brings daily transaction , but when i select the date filter its skipping the date which is not having transaction ,
e.g if i am selecting date from 1/3/2023 to 31/3/2023 its getting only transaction of 31/3/2023 but i need to show remaining transaction also like
1/3/2023
2/3/2023
3/3/2023
4/3/2023
5/3/2023....and so on.
so how can i get this done my code is below. can anybody have suggestion on this so i can increment the value by date till todate . plz guide me on this.
qbdsGenalAcEntry = qbdsMainAccount.addDataSource(tableNum(GeneralJournalAccountEntry)); qbdsGenalAcEntry.joinMode(JoinMode::InnerJoin); qbdsGenalAcEntry.addLink(fieldNum(MainAccount, RecId), fieldNum(GeneralJournalAccountEntry, MainAccount)); qbdsGeneralJourEntry = qbdsGenalAcEntry.addDataSource(tableNum(GeneralJournalEntry)); qbdsGeneralJourEntry.joinMode(JoinMode::InnerJoin); qbdsGeneralJourEntry.addLink(fieldNum(GeneralJournalAccountEntry, GeneralJournalEntry),fieldNum(GeneralJournalEntry, RecId)); qbdsGeneralJourEntry.addRange(fieldNum(GeneralJournalEntry, AccountingDate)).value(queryRange(fromDate,toDate)); QueryRun qr = new QueryRun(query); while (qr.next()) { MainAccount mainAccount = qr.get(tableNum(MainAccount)); GeneralJournalAccountEntry genJourAcEntry = qr.get(tableNum(GeneralJournalAccountEntry)); GeneralJournalEntry genJourEntry = qr.get(tableNum(GeneralJournalEntry)); cashBalTmp.clear(); cashBalTmp.DTDataAreaID = _dataAreaId; cashBalTmp.MainAccountId = mainAccount.MainAccountId; cashBalTmp.Name = mainAccount.Name; cashBalTmp.AccountingDate = genJourEntry.AccountingDate; cashBalTmp.TransactionCurrencyAmount = genJourAcEntry.TransactionCurrencyAmount; cashBalTmp.insert(); }
I see you have to date variables: fromDate and toDate. If you are entering Date from: 01-03 and Date to 31-03
Looking at your code, then it would seem that the fromDate is also set to 31-03 somehow. So the resulting query would be from date: 31-03 and to date 31-03. That could be the reason why you are seeing results from 31-03 only.
As Girish said, you will have to debug it to find out what's goin on.
Hi Dinesh,
Have you debugged the code?
Print the query in the info log and see how the query is built in.
Thanks,
Girish S.
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156