I have an interactive report form with 2 pages. I applied dynamic action on form,page, and CLEAR data in few items successfully. However the data still shows up in the report page. I am trying to CLEAR the data of those similar attributes in report column but no luck.........Any tips would be helpful. Thanks
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..
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 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
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.