change layout of grid

I have 2 mysql tables I’m working with.

Table 1 has employee information columns :

employee_number
date_of_birth
name
address
etc.

Table 2 has pay information columns :
employee_number (foreign key)
date
bonus

My boss has requested a screen to show the data like, with dates listed horizontally across the top and employee listed vertically :

                 1/1/2000     1/1/2001     1/1/2002     1/1/2003

Bill $500 $600 $700 $900

Ferdie $300 $500 $800 $434

Tony $450 $234 $432 $343

Can I do something like this through the scriptcase interface?
I’m sure I could do it through SC as a custom app, but is there an easier way?

Thanks

I meant to say “blank” app in my post, not “custom” app.

For sure you can do this with dynamic group by feature. Just define the 2 fields in the group by config and when you run, place one in the horizontal. I would imagine you can achieve with static group by too but never tried.

Using blank app, you would need to echo your own HTML/CSS.

I think you can do it by Grid and pivot

www.LiviApps.com (Scriptcase International)
www.OwenSolution.com (Scriptcase Indonesia)

Thanks…I used a group_concat to get the output I wanted.