Click here to Skip to main content
15,905,563 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)
    Product4  (child of P3)
Product8        (Parent of parents)

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
Updated 2-May-11 19:12pm

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