Data Tree Reversed?
Hello,
I am working on a report with a simple Parent-Child query. The master table
is Positions. The Child table is Employees. They are linked by Positions.ID
= Employees.Position_ID. The link looks correct, with a "1" by Positions.ID
and an infinity symbol by the Employees.Position_ID. In the main report, I
have created a group based on Positions.ID. The child report is supposed to
be pulling the employee name for each employee within the group, and I've
added Employees.Position_ID as an invisible field, just to be sure the link
is established. The data pipeline for the main report is Positions. The data
pipeline for the subreport is set to Employees. I cannot find anywhere else
in the Report Builder where I need to specify a link, yet each group
subreport is returning a list of all employees. It isn't being limited by
the group.
The only thing I see which looks odd is in the Data Tree. Employees is
showing as the top level, with Positions indented below it. I can't find any
way to fix that, and don't understand why it is showing that way if the link
is correct. I also cannot find a way to delete Employees from the Data
completely so I can try adding it again.
Thanks,
Steve
I am working on a report with a simple Parent-Child query. The master table
is Positions. The Child table is Employees. They are linked by Positions.ID
= Employees.Position_ID. The link looks correct, with a "1" by Positions.ID
and an infinity symbol by the Employees.Position_ID. In the main report, I
have created a group based on Positions.ID. The child report is supposed to
be pulling the employee name for each employee within the group, and I've
added Employees.Position_ID as an invisible field, just to be sure the link
is established. The data pipeline for the main report is Positions. The data
pipeline for the subreport is set to Employees. I cannot find anywhere else
in the Report Builder where I need to specify a link, yet each group
subreport is returning a list of all employees. It isn't being limited by
the group.
The only thing I see which looks odd is in the Data Tree. Employees is
showing as the top level, with Positions indented below it. I can't find any
way to fix that, and don't understand why it is showing that way if the link
is correct. I also cannot find a way to delete Employees from the Data
completely so I can try adding it again.
Thanks,
Steve
This discussion has been closed.
Comments
previous shot.
can sent to support@.
To delete a DataView, press the right mouse button while positioned over the
DataView and then select the Delete option from the context menu.
There are no known issues with the master/detail linking or the Data tree
not displaying properly. If you can provide steps for recreating this,
please let us know and we can try it here.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
forums where they generally want to see screenshots, code, etc.
Deleting the Data View and recreating it solved the problem. I still don't
know why it maintained the incorrect Parent-Child relationship once the link
between the Data Views was corrected.
Steve