My company is using APEX 4.1 but I'm an APEX newbie (I have a Oracle Forms background). My user wants an APEX app that displays a couple of fields to enter search criteria and then display a single record report based on the search criteria. The query would return a bunch of columns so they would like to see them in a page format rather than on a single row. This would be read only data. Does anyone know if there are any examples of doing something like this?
There is a vertical report template for the most of the clasic reports. As far as I know there is no such template for Interactive Report. However, you can use Interactive Report for the purpose you described. Interactive Report can use "Link to Single Row View" and it will display all the columns included in the query below each other - just like a form does it. Look under Report Attributes > Link Column