Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Data Tree Reversed?

edited February 2010 in Subreports
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

Comments

  • edited February 2010
    Attached is a screenshot of the Data view.


  • edited February 2010
    Corrected screenshot. I was testing another link option when I took the
    previous shot.



  • edited February 2010
    Please do not post screenshots or attachments to the newsgroups. Attachments
    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
  • edited February 2010
    Sorry, I didn't know posting screenshots was a no-no. I'm used to posting on
    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

This discussion has been closed.