Dynamics Community Forum Thread Details

Report not getting transaction according to date

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

Quick Links