We're trying to create a report which is similar to a canned crystal report in our mrp package. The canned report is a top down report of Work Order dependencies. It uses Hierarchical Grouping with Instance ID Workorder.number field and Parent ID field Workorder.parentnumber. That works well in the canned report for a top down report (highest level WO to lowest level for that product structure). I need to develop a similar report that goes from the bottom up (displays lowest level WO first and on up). The report is a subreport and WO is in GH1 section - Crystal XI.
I've looked at using HierarchyLevel (GroupingLevel ({Workorder.number})), and I am able to display the level number on the report in an ascending manner. I'd just like to be able to sort on this in a descending manner, but can't seem to do it... Hope the above made some sense... Any thoughts?
I've looked at using HierarchyLevel (GroupingLevel ({Workorder.number})), and I am able to display the level number on the report in an ascending manner. I'd just like to be able to sort on this in a descending manner, but can't seem to do it... Hope the above made some sense... Any thoughts?