This content has been marked as final. Show 8 replies
What do you mean by clear data in items?
Interactive report is derived from a database table(Sql query), if you want to remove the column values from the report, then you have to delete those values from the db table and refresh the report.
Please add your question with more detail.
Like i said, i have an interactive report form (2 pages) .
Page 1 REPORT: clicking on the edit icon will take me to the form page.
Page 2:Form: i have an item ,STATUS as select list.To this item i created dynamic action like if the STATUS has "Return" then "CLEAR" other item values like start date,end date... .. in the form.And it worked well.
But the report(page 1) still shows the values for start date and end date ....
My question is how do i make those item(start date,end date) values disappear in the report too..
Hope i am clear this time
How exactly do you "clear" items with dynamic action?
While creating the dynamic action.... instead of show,hide,enable.... options i chose CLEAR and then i selected which items i want it to be clear.
Ok thats client side dynamic action. Just so you understand what it means:
By executing that dynamic action you are simply clearing the fields on your form, you don't "clear" them from your database table. The interactive report is based on your database table. That's why there is no change in your interactive report when you clear the fields.
If you want those fields to disappear from interactive report, also you should make dynamic action that EXECUTES PLSQL CODE and that runs at the same time as your dynamic action. And you will do smth like this:
I really hope this helps you.
Update tableA SET field1 = NULL where id = :P1_ID
Edited by: Mimi on May 5, 2012 6:51 PM
Thanks a lot. It solved my issue.
I Have one more question
I have an interactive report form.On the report, clicking on edit icon will take the user to form.In the form user will change the status(select list) to CLOSE. Then i want to popup an window where i can capture fields and data from one of my another pages and click submit button. Any suggestions would be helpful. Thanks
Hmm, i suppose that u can do something like this:
After that step i really didn't understand you correctly. You want to take a value from another page? Where is that page, i suppose its based on some database table.
Mb the easiest solution would be to create dynamic action (since you are familiar with them) on popup page, that fires on "page load" which will set all item values.
I would really need to see your example to help you further.
Thanks for the suggestion Mimi.I will try and will let you know.Thanks