Display Project Ancestor on project report.
Posted: 22 Oct 2013, 14:07
Hi,
I am having some trouble with designing a report where I need to be able to raise a report based on a project (which is a descendant of another project in hierarchy), however I need for the report to display something along the lines of, "the parent project for this record is: xxxxxxxx"
I know (think) I can do the opposite whereby I generate a report based on the parent project and get it to show me all of the descendant projects by using the DECENDENT_PROJECT.NAME field, but the only field that seems to be available relating to the parent/ancestor project is ANCESTOR_ID which just displays the project number (not the reference or description).
I hope I have been clear in what I'm trying to do, any help would be very much appreciated. Using Sage 50 Accounts Pro 2013, Report designer v1.4.2013.27.
Thanks,
Steve.
I am having some trouble with designing a report where I need to be able to raise a report based on a project (which is a descendant of another project in hierarchy), however I need for the report to display something along the lines of, "the parent project for this record is: xxxxxxxx"
I know (think) I can do the opposite whereby I generate a report based on the parent project and get it to show me all of the descendant projects by using the DECENDENT_PROJECT.NAME field, but the only field that seems to be available relating to the parent/ancestor project is ANCESTOR_ID which just displays the project number (not the reference or description).
I hope I have been clear in what I'm trying to do, any help would be very much appreciated. Using Sage 50 Accounts Pro 2013, Report designer v1.4.2013.27.
Thanks,
Steve.