How do u print the data horizantally by using XML report?
EX:Suppose there is one table names as SAMPLE in that we
have only two columns say empno,ename.I want the output
like this,At run time user may enter 3 colums(i.e to data
print horizantally).
empno ename empno ename empno ename
100 aaa 101 bbb 102 ccc
103 ddd 104 eee 105 fff
- 1 Answers
- 2357 Views
- Intelligroup, TTPL, I also Faced
- E-Mail Answers
Answer / Prabhat Kumar Tripathi
To print data horizontally in an XML report, you would typically use a tabular structure to organize your data. In Oracle Forms Reports, this can be achieved by creating a table-like layout with columns and rows. For each record (row) in your dataset, you can then output the values of each field (column) separated by appropriate delimiters (such as spaces or commas). Here's an example for the data you provided:
<table>
<tr>
<th>empno</th>
<th>ename</th>
</tr>
<?xml version="1.0" encoding="UTF-8"?>
<?oracle-report-options report_title="Horizontal Data Printing Example"?>
<?oracle-data-source ds1 binds=("ds1:DS1">
<query name="select_sample">
SELECT * FROM SAMPLE
</query>
<?
<?loop ds1.cursor?>
<tr>
<td><?=ds1.empno ?></td>
<td><?=ds1.ename ?></td>
</tr>
<?endloop?>
</table>
| Is This Answer Correct ? | 0 Yes | 0 No |
List the editors availables in forms 4.0?
all steps of bitmap report?
what r the various types of reports
Can you truncate a table in a procedure in Oracle Forms?
how to pass 2 variables from one form to other form
What is user exit.?
2 Answers IBM, Synergy, Zensar,
What are the different styles of actvation of ole Objects?
How can you execute the user defined triggers in forms 3.0 ?
What are the Built-ins used for sending Parameters to forms?
What are different types of modules available in oracle form?
What is a window?
What is the difference between BPA AND Contract What are documents and test cases u followed
Oracle General 
