This discussion is archived
2 Replies Latest reply: Mar 6, 2013 10:16 AM by do*417019*tt RSS

Single row report?

do*417019*tt Newbie
Currently Being Moderated
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?
  • 1. Re: Single row report?
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    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


    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.apress.com/9781430235125
    http://apex.oracle.com/pls/apex/f?p=31517:1
    http://www.amazon.de/Oracle-APEX-XE-Praxis/dp/3826655494
    -------------------------------------------------------------------
  • 2. Re: Single row report?
    do*417019*tt Newbie
    Currently Being Moderated
    Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points