Some Pentaho reports not displaying

[francisguchie]

This issue comes because of MySQL version comes with some preset conditions like https://issues.apache.org/jira/browse/FINERACT-1054

Work Around

Step 1: Check if strict mode is enabled sudo mysql -u root -p

SHOW VARIABLES LIKE 'sql_mode';

U should see +---------------+------------------------------------------------------------------------------------+ | sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +---------------+-------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)

Exit and go to step 2

Step 2: Create a new configuration file under the /etc/mysql/conf.d/ directory. The new configuration file will override the default MySQL configuration file.

Use the command below:

$ sudo nano /etc/mysql/conf.d/disable_strict_mode.cnf Then, enter the text below on the text editor:

[mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Press CTRL +X and Y to save the changes.

Step 3: Restart MySQL When you make any change to any MySQL configuration directory, you should restart MySQL service for the changes to take effect using the command below:

$ sudo service mysql restart

[hantviet]

Dear Mr.francisguchie, please help me, why is the pentaho report not showing in excel format? Is this function not available yet?

[francisguchie]

Dear Hantviet,

There must be a challenge somewhere, I think we need to interface so i can tell exactly why it is not showing. As for me all options work just fine. Kindly reach out to me via skype or whatsapp. My current time zone is +002 GMT (Pretoria) time

My Kind Regards

Francis Guchie Kirago Skype: francisguchie Telegram: 232 79 19 44 07 Whatsapp: 232 79 19 44 07 LINKEDIN: https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ twitter: @FrancisGuchie

On Sun, Dec 12, 2021 at 7:54 AM hantviet @.***> wrote:

Dear Mr.francisguchie, please help me, why is the pentaho report not showing in excel format? Is this function not available yet?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/openMF/fineract-pentaho/issues/55#issuecomment-991839718, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFNCABXS7FX2N5OPFNF37S3UQQ2KRANCNFSM5J3FB36Q . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[hantviet]

NOTE Log Mifos 21_Pentaho Report.txt

[hantviet]

Ok, Done. I think that something, what this plugin needs is missing from 4.1.2 version. Pentaho reporting output plugin doesn't produce Excel-reports in PDI 4.1.2.

• For Pentaho V3.9.1-GA: You need poi-3.6.jar, poi-ooxml-3.6.jar and poi-ooxml-schemas-3.6.jar
• For Pentaho V7.0.0.0-25: You need poi-3.12.jar, poi-ooxml-3.12.jar and poi-ooxml-schemas-3.12.jar : https://mvnrepository.com/artifact/pentaho-kettle/kettle-engine/7.0.0.0-25

[francisguchie]

Dear Mr.francisguchie, please help me, why is the pentaho report not showing in excel format? Is this function not available yet?

@hantviet please see issue

[francisguchie]

Closing this issue because we have a work around