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();
}
