Checkbox displaying value from SQL?

WorkerDerrick · 2015-09-30T11:42:21+00:00

Hello I am new in using BIRT. Not sure is this possible. As I am working on an application which generate report showing the data from the SQL database. I got a problem is that the report need to show the SQL data value by checkbox which the data is string "T" …

WorkerDerrick

Hello I am new in using BIRT.
 
Not sure is this possible. As I am working on an application which generate report showing the data from the SQL database.
 
I got a problem is that the report need to show the SQL data value by checkbox which the data is string "T"
 
I know that checkboxes can be make by using HTML code, but I have no idea how to code the checkboxes to show the value from SQL database.
 
Also is it possible to use if statement to control the checkbox? like this (I am using c# trying to show what I want to code as I don't know how to code correctly on BIRT)
 
if (sqldatavalue == T){
 checkbox.checked = true;
}
else{
checkbox.checked = false;
}
 
many thanks,

Find more posts tagged with

Comments

JFreeman

What version of BIRT are you using?
 
It should be possible to achieve but I am not clear on exactly what you are needing.
Can you provide additional details?
Can you provide a sample screenshot of what you trying to accomplish?

WorkerDerrick

Hello Freeman
 
I think I had solved the problem by myself, thanks.
 
First In SQL I had use the case statement to turn the string letter "T" to "checked", then I use <value-of> to apply the dataset row to the text item using HTML.
 
like this:
 
<input type="checkbox" <value-of>datasetrow.somekindofSQLdata</value-of></input>
(may not correct as I don't have the original code in my current PC)
 
The checkbox will change to "checked" when the SQL database has a "T" value

JFreeman

Thanks for the update.
I'm glad to hear you got it figured out.
 
Let us know if you have additional questions.