This discussion is archived
3 Replies Latest reply: Dec 31, 2012 12:18 AM by fac586 RSS

How to Align Query output in vertical grids in Classic Reports

869013 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

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