Click here to Skip to main content
15,949,686 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hi buddies
there is a Database table Named "Product" which stores Product Specifications and attributes. each Product has 0,1 or many child product . if it has no child product, the product is child product and should be displayed at the bottom of the parent row in a tree-like Crystal report ( by tree-like report I mean, some indentations for child products). if you ask how child and parent products are distinguished, I would answer, by a special column named id_index_product which for every product shows its parent ( parent id) and if the column would be Null, that is the Parent of parents Product which has to be shown at the top of the report.
What I have in mind is something like this :


Product1        (Parent of parents)
  Product2 (child of P1)
  Product3
    Product4  (child of P3)
  Product5
    Product6
      Product7
Product8        (Parent of parents)
 Product9
 Product10


I've used grouping and Hierarchical grouping but I think I used them incorrectly. so no success is achieved.

I wonder if you guide me how to get it done.
I use VS 2008 (C#)- and Crystal Reports Basic for VS 2008
Posted
Updated 2-May-11 19:12pm
v2

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900