This discussion is archived
6 Replies Latest reply: Jul 25, 2013 12:51 PM by DaveWill RSS

Dynamic Checkboxes on Interactive Report

905077 Newbie
Currently Being Moderated
I have an interactive report that currently lists a row of values:


Field1
-----------------
Val1
Val2
Val3


I would like to place a text-field at the top of this interactive report with a submit button:


[textbox] [submit button]

Field 1
--------------------
Val1
Val2
Va3


Then I would like to have checkboxes [] appear in each row:


[textbox] [submit button]

Field1 | Checkbox
------------------------------
Val1 | []
Val2 | []
Val3 | []



Then I would like to make it so that the user enters some text into the textbox and selects any number of the row checkboxes. Upon hitting submit, a procedure will run that accepts each Field1 value and inserts a record into a table containing 2 fields: the Field1 value and the textbox text.

So the following user input:

[Test text in the textbox.] [submit button]

Field1 | Checkbox
------------------------------
Val1 | []
Val2 | [x]
Va3 | [x]

After hitting the submit button, a procedure would be called that would insert 2 records into a table:


Field1 | Field2
------------------------------------------------------
Val2 | Test text in the textbox.
Val3 | Test text in the textbox.



Note that there is no entry for Val1 because its checkbox was not checked when the user pressed submit.


What can I do to make this happen? I appreciate any help you can offer.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points