This content has been marked as final. Show 6 replies
I've created an example on http://apex.oracle.com/pls/apex/f?p=27034:1
What you can see here is one tabular form and one report. If you look at the name of the items in the report than you'll see that these are exactly the same as the name of the items in the tabluar form. And you can see that the tabular form is not working anymore
If I use the 'normal' report columns then it's hihgly impossible to get the totals straight under the corresponding day (as you can see on report 3).
I also tried to create page items (these items has a different name as the tabular form) and to put them in the right position with but this is a quick and dirty solution and it's not working in IE8.
Thanx for your help!
Edited by: Hamertje16 on May 7, 2012 11:41 AM
You have this problem because you created the lower (Totals) report as a report and then made the columns enterable (Text field).
As a consequence, the Tabular Form as well as Totals Report have columns with names f01, f02, etc. This is why the tabular form has failed.
What you should do is change the query of the Totals report as use APEX_ITEM API in it to create your fields. And while doing so use numbers beyond 12 in the APEX_ITEM parameter p_idx. That is because you are using upto f12 in the Tabular form.
Hi Prabodh ,
Thanx for your reply. That was the trick I missed :). The name of the items are now not corresponding anymore with the items of the tabular form.
Unfortenally, when I tried to submit he gaves me the answer Sorry!The page requested was not found. When I disabled the report than it works fine...
Any idea how I can fix this? Is there a possible way to exclude these items from processing the data?
As stated in my earlier post, use the APEX_ITEM.TEXT API as described here http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21676/apex_item.htm#CHDDCHAF.
Be sure that you use p_idx values greater than 12.
Once you do that the standard AppyMRU will not process the f13 onwards. You will have to process f13 onwards using your custom MRU, and in your MRU you use APEX_APPLICATION.G_F13 onwards.
FOR I IN 1..APEX_APPLICATION.G_F13.COUNT LOOP -- DO YOUR INSERTS/UPDATES HERE END LOOP;