3 Replies Latest reply: Dec 31, 2012 2:18 AM by fac586 RSS

    How to Align Query output in vertical grids in Classic Reports

    869013
      HI all,

      I have a requirement to display query output in a vertical grid.

      For example, If my query output is :

      SQL, PL/SQL, Forms,Reports, XMLP, APEX etc then output should be displayed in following format:

      1. SQL 2. PL/SQL 3. Forms
      4. Reports 5. XMLP 6. APEX

      Thanks in Advance!!

      Regards,
      Vamsi
        • 1. Re: How to Align Query output in vertical grids in Classic Reports
          AndyPol
          Hi

          It's depend on, do you need 3 items per line or fixed ?

          Paste your query.

          Regards
          • 2. Re: How to Align Query output in vertical grids in Classic Reports
            869013
            Hi Ansypol,

            Thanks for the response!!

            SQL: select * from emp
            where 1=1
            and emp = 1 ;

            We want to display emp details from the above query in the following format:

            EMP No : 1 Ename: XXX Manager_Id: 2
            Job: Consultant Sal: 1000 Commission: 5

            We want a break after three columns.

            Regards,
            Vamsi
            • 3. Re: How to Align Query output in vertical grids in Classic Reports
              fac586
              866010 wrote:

              Thanks for the response!!

              SQL: select * from emp
              where 1=1
              and emp = 1 ;

              We want to display emp details from the above query in the following format:

              EMP No : 1 Ename: XXX Manager_Id: 2
              Job: Consultant Sal: 1000 Commission: 5

              We want a break after three columns.
              Create a custom named column template and base the tabular form report on this: {message:id=10399762}

              -----

              Please read the FAQ and forum sticky threads (if you haven't done so already), and update your forum profile with a real handle instead of "866010".

              When you have a problem you'll get a faster, more effective response by including as much relevant information as possible upfront. This should include:

              <li>Full APEX version
              <li>Full DB/version/edition/host OS
              <li>Web server architecture (EPG, OHS or APEX listener/host OS)
              <li>Browser(s) and version(s) used
              <li>Theme
              <li>Template(s)
              <li>Region/item type(s) (making particular distinction as to whether a "report" is a standard report, an interactive report, or in fact an "updateable report" (i.e. a tabular form)

              With APEX we're also fortunate to have a great resource in apex.oracle.com where we can reproduce and share problems. Reproducing things there is the best way to troubleshoot most issues, especially those relating to layout and visual formatting. If you expect a detailed answer then it's appropriate for you to take on a significant part of the effort by getting as far as possible with an example of the problem on apex.oracle.com before asking for assistance with specific issues, which we can then see at first hand.