Checkbox On An Actuate Report

[RV76]

I have a boolean value (Y or N) that I would like to show in the actuate report as a checkbox rather than as a text field. For example, the check box will be checked if the boolean value in the database is Y and unchecked if the boolean value in the database is N. Please advise...

Thanks in advance...

 

[DaveInIowa]

Add a string variable to your DataRow (i.e. strMyBool).
Place this field on your report and set its Font to Wingdings (and you'll probably want to increase the Font Size over the other field sizes).
Then override the OnRead Method of the DataRow:

Sub OnRead( )
    Super::OnRead( )
    If ([i]blnFromRow[/i]) Then
        strMyBool = "þ"
    Else
        strMyBool = "o"
    End If
End Sub

The strange characters being assigned to strMyBool can be copied and pasted from the Character Map utility to assign either a unchecked box or a checked box character to your output.