Announcement

Collapse
No announcement yet.

change layout of grid

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    I meant to say "blank" app in my post, not "custom" app.

    Comment


    • #3
      Originally posted by TheCoach View Post
      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.

      Comment


      • #4
        I think you can do it by Grid and pivot

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

        Comment


        • #5
          Thanks...I used a group_concat to get the output I wanted.

          Comment

          Working...
          X