NeoDBPro, REport Designer and MySQL - Forum

Forum Navigation
You need to log in to create posts and topics.

NeoDBPro, REport Designer and MySQL

So, I have a relly strange problem:

I'm using NeoDBPro with MariaDB/MySQL without problems, working with tables, grids, export etc...everything working fine.

But....!

When I try to create a report using Report Designer, there is no data on the report although the SQL Query was executed correctly and displayed correctly as a result in the table (correct record number, all data matches)

With SQLite and other databases no problem at all, only with MariaDB/MySQL.
Now my question is - what could be the problem?

Does the connection string have an impact on the report?

Because with the existing connection string everything works OK, all SQL Queries, even very complex ones, searching, sorting, exporting - everything except the report..
Is it maybe a problem with MariaDB/MySQL or something else?

Also, please note I'm using XAMPP 8.0.30 as local Server and MariaDB/MySQL from same installation:

  • Server-Version: 10.4.32-MariaDB - mariadb.org binary distribution
  • Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
  • Datenbank-Client Version: libmysql - mysqlnd 8.2.12
  • phpMyAdmin 5.2.2 and XAMPP Control Panel 3.3.0

Maybe is problem with MariaDB ?

Has anyone had a similar problem or maybe has a suggestion?

 

Thanks in advance!

 

Cheers!

good

Please share the .dbr report file and the names of the database, tables, and related fields so we can see if there are any errors.