Hierarchical Data Report?

• MufaddalSH

  Valued Member

  Points: 63

  More actions

  September 16, 2003 at 12:01 pm

  #82948

  How do I create a hierarchical data report that displays a product category and then all order items under that category and then other product categories and all items under that category?

  Mufaddal

  
  Mufaddal

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  September 16, 2003 at 4:54 pm

  #474525

  One way is to use a group by with cube, if you post DDL, can write an example.

  Ray Higdon MCSE, MCDBA, CCNA

  ------------
  
  Ray Higdon MCSE, MCDBA, CCNA

• philcart

  SSC-Forever

  Points: 47796

  More actions

  September 16, 2003 at 5:41 pm

  #474537

  What sort of tool/method are you using to produce your reports?

  You could possibly look at using ADO MD to create a hierarchical recordset using the SHAPE command.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface