Table alias in Report Data Definition

Yahoo Archive
1

Greg -


Did you ever find an answer to this questions?



DJ DeMoulin

IT Manager

Value Added Companies

2
Does anyone know of a way to add a table "alias" to a Report Data Definition. I am trying to modify the JobTrav RDD. This RDD contains the JobAsmbl table and an existing "alias" of the JobAsmbl table called "SubAsmbl". My problem is that, for an assembly job, when a Job Traveler is printed filtered down to a single sub-assembly, then the "Parent Assembly" section does not print out because the "SubAsmbl" table of the XML dataset is empty. The "SubAsmbl" alias links "down" to any sub-assemblies (from JobAsmbl.AssemblySeq to SubAsmbl.Parent). I would like to add a "ParentAsmbl" alias for the JobAsmbl table that is linked "up" from the JobAsmbl.Parent field to the ParentAsmbl.AssemblySeq field. But if I try to add a second copy/alias of the JobAsmbl table it gives a critical error saying "Column 'RptDefID, RptTableID, ZDataTableID' is constrained to be unique. Value 'JobTrav_Auto_KC, JobAsmbl, JobAsmbl' is already present." We are on Epicor 9.05.701.

Thanks,
Greg Bakker
Kooima Company