This content has been marked as final. Show 5 replies
first part :
Use a query like this to have them checked:
Use a query like this to have them UNchecked:
select apex_item.checkbox(1,A.ID,'CHECKED') CHECKBOX, A.*, rownum from <<table_name>> A;
By default it is not possible to exclude rows from the standard export in a report.
select apex_item.checkbox(1,A.ID,'UNCHECKED') CHECKBOX, A.*, rownum from <<table_name>> A;
You can always create a manual export but this takes some work, assuming you are using a standard report this is fairly easy, if you are using an interactive report this takes more effort ( but is also possible ).
I would start of to see if you can find a way to use the standard export, otherwise if this is not possible and you need more info on the export let me know.
Edited by: Bas de Klerk on 22-jan-2013 9:08
I tried using the suggested query, however, something isn't right. I get all the columns I need plus a column named 'CHECKBOX' that has
in it for each row. Not sure whats going on.
<input type="checkbox" name="f01" value="8" CHECKED />
As for the second part, I may be able to produce a desired pdf export with a conditional clause via to only give the rows that are checked
I have tried going into my application and editing the report attributes. Under one of my report columns, for the column attributes, I changed the "Display As" field to 'Simple Checkbox. This gives me a checkbox, but now I am not sure where to set those boxes to be checked. Not sure where to set the value = 'True' at.
make sure the checkbox column is of type "Standard report column", then you get the checkbox derived from the query.
I have made sure. I have also found another solution in how to generate a checkbox within the query.
making the first column name as a checkbox type will generate a checkbox that is already checked.
select 'Y' AS <column name>, A.this, A.that from <table name> where <condition>
also generates the check boxes but as unchecked
select 'N' AS <column name>