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:14 PM


  • Hi Maria,

    Could you give us an example to illustrate the problem? So that we could repro the issue with that example. The workaround you can try is to directly write T-SQL script for the report dataset. If the issue persists, please also provide the version information of the report builder.



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

    Friday, December 16, 2011 9:34 AM