PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 2024 → Checkbox in report of webdev 25 not alligned properly
Checkbox in report of webdev 25 not alligned properly
Débuté par Henk DIJKSTRA, 04 juin 2020 18:06 - 1 réponse
Membre enregistré
5 messages
Posté le 04 juin 2020 - 18:06
When I include a checkbox in a report, the checkbox alignment depends on the contents of the next cell:
(the checkbox was configured to be aligned centered (both horizontal and vertical) if the next column "Date" contains
a value, the checkbox is properly centered, when the "Date" is empty, the checkbox is misaligned.)



Membre enregistré
5 messages
Posté le 29 juin 2020 - 15:07
I found a solution for this problem: it seems the alignment of checkboxes in reports depends on whether or not the field actually has a value, or not. If the value is not existing in the database the configured alignment is ignored resulting in the report shown above. So the solution is simple: if the value doesn't not exist replace it with a default value. (In my case '0' or false).
My original SQL query for that field was:
...
QRY_LastFinalBattery.result AS result,
...

I replaced it with:
...
ISNULL(QRY_LastFinalBattery.result,0) AS result,
...


Henk