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
Edited by: pravish on May 4, 2012 7:35 PM
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?
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:
SET field1 = NULL
where id = :P1_ID
I really hope this helps you.
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.