Active Loan Summary per Branch

[bowenjnr]

I get a blank page when I run Active Loan Summary per Branch pentaho report

[francisguchie]

@bowenjnr , A few reports have broken SQL code due to challenges of grouping (Mysql 5.5 and before was not following the strict -full group by talked about here ONLY_FULL_GROUP_BY , you might want to start off by disabling it as illustrated here. Because i am sure a few more reports will have a similar problem.

if you can share the logs here too (just an excerpt) then we can have this solved faster. Nevertheless, I will put aside some extra time for this issue and push a PR for it if necessary

[bowenjnr]

When I run Balance Sheet I get this error on the web console even after removing ONLY_FULL_GROUP_BY from the database.

[francisguchie]

@bowenjnr did you manage to solve this?

[bowenjnr]

Yes, It solved the problem of blank reports.

On Sat, 10 Dec 2022, 14:02 Guchie, @.***> wrote:

@bowenjnr https://github.com/bowenjnr did you manage to solve this?

— Reply to this email directly, view it on GitHub https://github.com/openMF/fineract-pentaho/issues/72#issuecomment-1345239224, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALB2LLC5UIHCMPA2QCWRKATWMRPMBANCNFSM6AAAAAAREKC6R4 . You are receiving this because you were mentioned.Message ID: @.***>

[francisguchie]

@bowenjnr am curious to know how this was solved. It would be nice to share here for the next person ( just in case). Kindly if you can please share. then we can close this issue

thank you very much

[bowenjnr]

Active Loan Summary per Branch couldn't work, my apologies for not giving more clarity to this detail. Most of the reports especially accounting worked just fine. Others could not.

[francisguchie]

@bowenjnr - I will take this up and may be make a PR

[IOhacker]

Please pull latest version of the prpt and test. Please let us know.