Reporting checkboxes?

Ignition
1

Hi all,
I am designing some pdf reports? Is there anyway I can add check boxes on them??

Thanks,

Khashey

2

You could use unicode char 2611, ‘BALLOT BOX WITH CHECK’:

:ballot_box_with_check:
Will require a font that supports unicode characters, but most modern stuff should.

2 Likes
3

Hi PGriifth,

Thanks, And How would I link this to data?

Thanks,

Khashey

4

You can use a keychain expression. For example, to get a checked box when a number is even and an empty box when it’s odd, I can use the keychain expression @Number % 2 == 0 ? "☑": "☐" @ , assuming my table has a key called Number.checkboxes.proj (6.4 KB)

4 Likes
5

Thanks alot work like wonders Kathy

1 Like
6

sorry I had one more question do you know anyway where we can display null value in report as empty rather than <N/A> or N/A

7

I’m assuming it’s a table you are working with… If so, select the cell that you want to behave this way. In the property inspector, there should be a Null Value entry. Change that to something else. I had to put a space character there for my reports, if I remember correctly.

1 Like
8

You can also change the ‘String for Null’ property for the entire report:
https://docs.inductiveautomation.com/display/DOC79/Report+Component+-+Report+Object

2 Likes
9

Hi All,

Sorry to bother again.I have another report coming up here is my question: I am using a querry currently to populate a table on window.My question is how can we call dataset in report.For example my querry returns hourly downtime in 8 h .How can i do that on report.

Thanks Again

10

Your query will be a datasource, and you’ll use that datasource in your report

Here’s the Inductive University video on data in reporting: report data

and the video on designing reports: report designer

11

I like this method but question - how would I bring this out from my datasource? Tried SELECT IF(someCondition, 'U+2611', '') but just appears as U+2611 on the report now.

12

Depends on your DB flavor. E.G. SQLite has a CHAR builtin: SELECT CHAR(9745).

13

Using MySQL. Just tried SELECT CHAR(2611) But that comes through as a blob in my workbench which the report then seems to interpret as a NULL value.

14

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_char

CHAR(X'2611' using utf8) perhaps?

15

report
Hi @KathyApplebaum,

Can explain in more detail? I have tried to display the checkbox in the report but I'm not able to display it properly. every time shows an empty checkbox.