GRID/FORM layout EXCEL

Scriptcase 9 General
#1

i want to know if it is possible to make a GRID with the classic EXCEl layout. So in the left colum a name, toprow has the date and in between the data.

[TABLE=“border: 0, cellpadding: 0, cellspacing: 0, width: 455”]
[TR]
[TD=“class: xl63, width: 65”]name/date[/TD]
[TD=“class: xl64, width: 65, align: right”]1/01/17[/TD]
[TD=“class: xl64, width: 65, align: right”]2/01/17[/TD]
[TD=“class: xl64, width: 65, align: right”]3/01/17[/TD]
[TD=“class: xl64, width: 65, align: right”]4/01/17[/TD]
[TD=“class: xl64, width: 65, align: right”]5/01/17[/TD]
[TD=“class: xl64, width: 65, align: right”]6/01/17[/TD]
[/TR]
[TR]
[TD=“class: xl65”]mike[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]2[/TD]
[TD=“align: right”]3[/TD]
[TD=“align: right”]4[/TD]
[TD=“align: right”]5[/TD]
[TD=“align: right”]6[/TD]
[/TR]
[TR]
[TD=“class: xl65”]kurt[/TD]
[TD=“align: right”]6[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]2[/TD]
[TD=“align: right”]3[/TD]
[TD=“align: right”]4[/TD]
[TD=“align: right”]5[/TD]
[/TR]
[TR]
[TD=“class: xl65”]guido[/TD]
[TD=“align: right”]5[/TD]
[TD=“align: right”]6[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]2[/TD]
[TD=“align: right”]3[/TD]
[TD=“align: right”]4[/TD]
[/TR]
[TR]
[TD=“class: xl65”]rudy[/TD]
[TD=“align: right”]4[/TD]
[TD=“align: right”]5[/TD]
[TD=“align: right”]6[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]2[/TD]
[TD=“align: right”]3[/TD]
[/TR]
[TR]
[TD=“class: xl65”]john[/TD]
[TD=“align: right”]3[/TD]
[TD=“align: right”]4[/TD]
[TD=“align: right”]5[/TD]
[TD=“align: right”]6[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]2[/TD]
[/TR]
[/TABLE]

I have a table with the data in it. Can i make a grid with this format using the table data?

[TABLE=“border: 0, cellpadding: 0, cellspacing: 0, width: 195”]
[TR]
[TD=“class: xl64, width: 65”]NAME[/TD]
[TD=“class: xl64, width: 65”]DATE[/TD]
[TD=“class: xl64, width: 65”]VALUE[/TD]
[/TR]
[TR]
[TD]MIKE[/TD]
[TD=“class: xl63, align: right”]1/01/17[/TD]
[TD=“align: right”]1[/TD]
[/TR]
[TR]
[TD]MIKE[/TD]
[TD=“class: xl63, align: right”]2/01/17[/TD]
[TD=“align: right”]2[/TD]
[/TR]
[TR]
[TD]MIKE[/TD]
[TD=“class: xl63, align: right”]3/01/17[/TD]
[TD=“align: right”]3[/TD]
[/TR]
[TR]
[TD]MIKE[/TD]
[TD=“class: xl63, align: right”]4/01/17[/TD]
[TD=“align: right”]4[/TD]
[/TR]
[TR]
[TD]MIKE[/TD]
[TD=“class: xl63, align: right”]5/01/17[/TD]
[TD=“align: right”]5[/TD]
[/TR]
[TR]
[TD]MIKE[/TD]
[TD=“class: xl63, align: right”]6/01/17[/TD]
[TD=“align: right”]6[/TD]
[/TR]
[TR]
[TD]KURT[/TD]
[TD=“class: xl63, align: right”]1/01/17[/TD]
[TD=“align: right”]6[/TD]
[/TR]
[TR]
[TD]KURT[/TD]
[TD=“class: xl63, align: right”]2/01/17[/TD]
[TD=“align: right”]1[/TD]
[/TR]
[TR]
[TD]KURT[/TD]
[TD=“class: xl63, align: right”]3/01/17[/TD]
[TD=“align: right”]2[/TD]
[/TR]
[TR]
[TD]KURT[/TD]
[TD=“class: xl63, align: right”]4/01/17[/TD]
[TD=“align: right”]3[/TD]
[/TR]
[TR]
[TD]KURT[/TD]
[TD=“class: xl63, align: right”]5/01/17[/TD]
[TD=“align: right”]4[/TD]
[/TR]
[TR]
[TD]KURT[/TD]
[TD=“class: xl63, align: right”]6/01/17[/TD]
[TD=“align: right”]5[/TD]
[/TR]
[TR]
[TD]GUIDO[/TD]
[TD=“class: xl63, align: right”]1/01/17[/TD]
[TD=“align: right”]5[/TD]
[/TR]
[TR]
[TD]GUIDO[/TD]
[TD=“class: xl63, align: right”]2/01/17[/TD]
[TD=“align: right”]6[/TD]
[/TR]
[TR]
[TD]GUIDO[/TD]
[TD=“class: xl63, align: right”]3/01/17[/TD]
[TD=“align: right”]1[/TD]
[/TR]
[TR]
[TD]GUIDO[/TD]
[TD=“class: xl63, align: right”]4/01/17[/TD]
[TD=“align: right”]2[/TD]
[/TR]
[TR]
[TD]GUIDO[/TD]
[TD=“class: xl63, align: right”]5/01/17[/TD]
[TD=“align: right”]3[/TD]
[/TR]
[TR]
[TD]GUIDO[/TD]
[TD=“class: xl63, align: right”]6/01/17[/TD]
[TD=“align: right”]4[/TD]
[/TR]
[TR]
[TD]RUDY[/TD]
[TD=“class: xl63, align: right”]1/01/17[/TD]
[TD=“align: right”]4[/TD]
[/TR]
[TR]
[TD]RUDY[/TD]
[TD=“class: xl63, align: right”]2/01/17[/TD]
[TD=“align: right”]5[/TD]
[/TR]
[TR]
[TD]RUDY[/TD]
[TD=“class: xl63, align: right”]3/01/17[/TD]
[TD=“align: right”]6[/TD]
[/TR]
[TR]
[TD]RUDY[/TD]
[TD=“class: xl63, align: right”]4/01/17[/TD]
[TD=“align: right”]1[/TD]
[/TR]
[TR]
[TD]RUDY[/TD]
[TD=“class: xl63, align: right”]5/01/17[/TD]
[TD=“align: right”]2[/TD]
[/TR]
[TR]
[TD]RUDY[/TD]
[TD=“class: xl63, align: right”]6/01/17[/TD]
[TD=“align: right”]3[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD=“class: xl63, align: right”]1/01/17[/TD]
[TD=“align: right”]3[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD=“class: xl63, align: right”]2/01/17[/TD]
[TD=“align: right”]4[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD=“class: xl63, align: right”]3/01/17[/TD]
[TD=“align: right”]5[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD=“class: xl63, align: right”]4/01/17[/TD]
[TD=“align: right”]6[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD=“class: xl63, align: right”]5/01/17[/TD]
[TD=“align: right”]1[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD=“class: xl63, align: right”]6/01/17[/TD]
[TD=“align: right”]2[/TD]
[/TR]
[/TABLE]

#2

It’s possible do it. This report must be group by. and In Grid Modules -> Initial module: Summary.

#3

[ATTACH=CONFIG]n80625[/ATTACH]
May you need set some parameter in Summary section.

sc_rep_broupby.JPG