Report Builder Bug on Relationships RRS feed

  • Question

  • Somebody can help me with this problem that I have.

    The problem is every time I created a new report I create the Datasource and is ok.

    Next the window Design a Query is open. I choose the tables that I need and until here everything is ok.

    But I don't understand why when I create the relationships manually( Not with Auto Detect) the program let me do it, but if I want to make a change (for example go an unclik one column on any of my tables) the relationships that I created disappear.

    What could it be? How can I fix this problem? Any suggestion ? 

    Monday, December 5, 2011 1:19 PM


  • Hi Maria CJ,

    I was a little confused by the description “create the relationships manually”. Did you mean to add the Relationship in Report Builder Query Designer pane as following?

    As I have tested in Report Builder 3.0, it works fine with all column adding or removing behavior. However, I suggest you to use Auto Detect function, which will help you avoiding many unpredictable issues.

    For further assistance, please elaborate your issue with some screen shot to help reproduce your scenario exactly.


    TechNet Subscriber Support in forum
    If you have any feedback on our support, please contact

    Please remember to mark the replies as answers if they help.
    Tuesday, December 6, 2011 2:38 AM