Hi,

I have found what appears to be a minor error in the columns formatting. Let me explain, so you can look into the issue.

I have a simple table that counts data from a mySQL database. The SELECT and FROM for the query is as follows,

SELECT
'Total', SUM(T.Cnt)
FROM (SELECT
COUNT(DISTINCT uSimID) AS Cnt
FROM Simulators

The table simply shows 2 columns, one with the word Total and the second with the total count, Cnt. In the columns settings I have Total set to Align = Centered and it is centered correctly. The Cnt column has an ID set to Cnt and Align = Centered but it is showing LEFT.

Any ideas?

Ken

Hello,

Could you send a link to a page where the problem occurs?

Regards,
ARI Soft

Hi, please go to this page on my test site,

sim-x.net/test/index.php/inventoryreport-search.html

Select "Air Canada Flight Training", or any of the organizations listed, and hit the SEARCH button. This will generate a Summary Report. The TOTAL row on the right shows LEFT justified, yet the Column Setting is set to CENTERED.

Maybe the Column ID is not correct, but I cannot imagine what else this column can be referred to as, based on the SQL statement used.

Ken

Add the following code to "CSS Styles" parameter in module settings:

{$id} TD {text-align:center;}

Regards,
ARI Soft

Thank you, that fixed the issue. So I know for future, is this a bug in ARI DataTables or simply a limitation? What is "TD" referring to? It is not the ID of the column of data defined in my SQL statement.

It is not a bug, but it seems an incorrect value is used for "Columns settings -> ID" parameter. We just provided another solution how to achieve what you need.

"CSS Styles" parameter accepts custom CSS rules.

Regards,
ARI Soft