suggest me the right approach

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ravindarjobs
    New Member
    • May 2007
    • 86
    #1

    suggest me the right approach

    i have a table say ABC.
    This table has columns

    SECTOR....ITEM YEAR VALUE
    _______... ____ _____ ______
    CV.......... COL.......1995. .....1
    CV...........CO L.......1996... ...4
    CV...........CO L.......1997... ...3
    CV...........EL E.......1995... ...2
    CV......... .ELE.......1996 ......2
    CV...........EL E.......1997... ...4
    CV...........DU E.......1995... ...2
    CV...........DU E.......1996... ...4
    CV...........DU E.......1997... ...5
    AL...........CO L........1995.. ....2
    AL...........CO L........1996.. ....3
    AL...........CO L........1997.. ....2
    AL...........EL E........1995.. ....4
    AL...........EL E........1996.. ....4
    AL...........EL E........1997.. ....1
    AL...........DU E........1995.. ....3
    AL...........DU E........1996.. ....2
    AL...........DU E........1997.. ....3
    ZN...........CO L........1995.. ....2
    ZN...........CO L........1996.. ....2
    ZN...........CO L........1997.. ....1
    ZN...........EL E........1995.. ....4
    ZN...........EL E........1996.. ....3
    ZN...........EL E........1997.. ....2
    ZN...........DU E....... 1995......4
    ZN...........DU E........1996.. ...4
    ZN...........DU E........1997.. ....4

    i want to display the output to the user on the form as below(i just used dots to make the format well, so dont consider dots).

    per each sector(CV,AL,ZN ), there will be 3 Items(COL,ELE,D UE).
    i want to display the output per year and per sector as below




    YEAR............... .......CV............... ............AL............... ........... ZN.............
    ............... ....COL.... ELE... DUE......COL...ELE....DUE.......COL...ELE...DUE

    1995........... 1...........2.. .......2....... ...2..........4 ............3.. ..........2.... ....4.......4.. .
    1996........... 4...........2.. .......4....... ...3..........4 ............2.. ..........2.... ....3.......4.. .
    1997........... 3...........4.. .......5....... ...2..........1 ............3.. ..........1.... ....2.......4.. .



    please suggest me the best approach.
    which controls should i use in the form?
    Tags: None
    • fplesco
      New Member
      • Jul 2007
      • 82
      #2
      Originally posted by ravindarjobs
      i have a table say ABC.
      This table has columns

      SECTOR....ITEM YEAR VALUE
      _______... ____ _____ ______
      CV.......... COL.......1995. .....1
      CV...........CO L.......1996... ...4
      CV...........CO L.......1997... ...3
      CV...........EL E.......1995... ...2
      CV......... .ELE.......1996 ......2
      CV...........EL E.......1997... ...4
      CV...........DU E.......1995... ...2
      CV...........DU E.......1996... ...4
      CV...........DU E.......1997... ...5
      AL...........CO L........1995.. ....2
      AL...........CO L........1996.. ....3
      AL...........CO L........1997.. ....2
      AL...........EL E........1995.. ....4
      AL...........EL E........1996.. ....4
      AL...........EL E........1997.. ....1
      AL...........DU E........1995.. ....3
      AL...........DU E........1996.. ....2
      AL...........DU E........1997.. ....3
      ZN...........CO L........1995.. ....2
      ZN...........CO L........1996.. ....2
      ZN...........CO L........1997.. ....1
      ZN...........EL E........1995.. ....4
      ZN...........EL E........1996.. ....3
      ZN...........EL E........1997.. ....2
      ZN...........DU E....... 1995......4
      ZN...........DU E........1996.. ...4
      ZN...........DU E........1997.. ....4

      i want to display the output to the user on the form as below(i just used dots to make the format well, so dont consider dots).

      per each sector(CV,AL,ZN ), there will be 3 Items(COL,ELE,D UE).
      i want to display the output per year and per sector as below




      YEAR............... .......CV............... ............AL............... ........... ZN.............
      ............... ....COL.... ELE... DUE......COL...ELE....DUE.......COL...ELE...DUE

      1995........... 1...........2.. .......2....... ...2..........4 ............3.. ..........2.... ....4.......4.. .
      1996........... 4...........2.. .......4....... ...3..........4 ............2.. ..........2.... ....3.......4.. .
      1997........... 3...........4.. .......5....... ...2..........1 ............3.. ..........1.... ....2.......4.. .



      please suggest me the best approach.
      which controls should i use in the form?

      I think you have to try VSFlexGrid V7.00. It has a lot of capabilities and code is available on its demo.

        Comment

        • hariharanmca
          Top Contributor
          • Dec 2006
          • 1977
          #3
          Originally posted by ravindarjobs
          i have a table say ABC.
          This table has columns
          <Sample>


          i want to display the output to the user on the form as below(i just used dots to make the format well, so dont consider dots).

          per each sector(CV,AL,ZN ), there will be 3 Items(COL,ELE,D UE).
          i want to display the output per year and per sector as below

          <Sample>

          please suggest me the best approach.
          which controls should i use in the form?

          You can use msflexgrid or mshflexgrid and use

          [CODE=vb]grdName.MergRow (<Row Id>)[/CODE]

            Comment

            Previous template Next
            Working...