Hierarchical view in group header
hiii
how to add Hierarchical view in group header band
for example i have two tables categories and Items
Fields in categories are : Category_ID, Parent_Category_ID, Category_Name
Fields in Items are : Item_ID, Category_Name, Price
i have created report in which i have kept grouping from Category_ID
its showing perfect grouped Items by Category_ID but i want that Hierarchical view in Group Header which is on Category_ID and in data it should show the Items
but there is no property of parentID and IDColumn in Group Header Band so how can i do that??
and if i keep the settings in Data Band then Category Name is displaying again and again as it is not header it is Details
with regards
k
how to add Hierarchical view in group header band
for example i have two tables categories and Items
Fields in categories are : Category_ID, Parent_Category_ID, Category_Name
Fields in Items are : Item_ID, Category_Name, Price
i have created report in which i have kept grouping from Category_ID
its showing perfect grouped Items by Category_ID but i want that Hierarchical view in Group Header which is on Category_ID and in data it should show the Items
but there is no property of parentID and IDColumn in Group Header Band so how can i do that??
and if i keep the settings in Data Band then Category Name is displaying again and again as it is not header it is Details
with regards
k
Comments
Group does not support hierarchy. You may try to make master-detail report, where the master data band will be hierarchical, and its detail band will display Items.
thanks alex i will do this but one more question is it possible to have hierarchy in outline is there any special things to do or it will automatically take once we define for that particular field ??
u mean in daily build or major version ??
The problem is fixed, you may check the current build.