PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WEBDEV 2024 → Checkbox in report of webdev 25 not alligned properly
Checkbox in report of webdev 25 not alligned properly
Started by Henk DIJKSTRA, Jun., 04 2020 6:06 PM - 1 reply
Registered member
5 messages
Posted on June, 04 2020 - 6:06 PM
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.)



Registered member
5 messages
Posted on June, 29 2020 - 3:07 PM
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