Okay
To get you started...
Create a new report template with named rows.
In row 1 template put this
["#1#","#2#","#3#","#4#","#5#","#6#","#7#","#8#"]
Assuming you have 8 rows say... and make it conditional based on a PL/SQL Expression like this
#ROWNUM# = 1
Then row 2 template like this
,["#1#","#2#","#3#","#4#","#5#","#6#","#7#","#8#"]
Conditional on
#ROWNUM# > 1
Then in before row put this
<script type="text/javascript">
Ext.onReady(function(){
var munkyData = [
And after rows something like this (based on the emp table)
];
var store = new Ext.data.SimpleStore({
fields: [
{name: 'empno', mapping: '0'},
{name: 'ename', mapping: '1'},
{name: 'job', mapping: '2'},
{name: 'mgr', mapping: '3'},
{name: 'hiredate', mapping: '4'},
{name: 'sal', mapping: '5'},
{name: 'comm', mapping: '6'},
{name: 'deptno', mapping: '7'}
]
});
store.loadData(myData);
var grid = new Ext.grid.GridPanel({
store: store,
columns: [
{id:'empno',header: "Employee",sortable:true, width:100,dataIndex:'empno'},
{header: "Name", sortable:true,width:75, dataIndex:'ename'},
{header: "Job", sortable:true, dataIndex:'job'},
{header: "Manager", sortable:true,width:75, dataIndex:'mgr'},
{header: "Hire Date", sortable:true,dataIndex:'hiredate'},
{header: "Salary", sortable:true,width:50,dataIndex:'sal'},
{header: "Commission", sortable:true,dataIndex:'comm'},
{header: "Department", dataIndex:'deptno'}
],
stripeRows: true,
width:700,
autoHeight:true,
title:'Array Grid',
renderTo: 'munkyDiv'
});
});
</script>
Then create a region to hold it with a source of
<div id="munkyDiv>
</div>
This is pretty basic but it should get you going...
Cheers
Ben
http://www.munkyben.wordpress.com
Don't forget to mark replies helpful or correct 