How to combine two table in a database to create a single report in SSRS 2008 RRS feed

  • Question

  • User2108234275 posted

    Hi, How to combine two table in a database to create a single report. For example I am having two tables in a database linked each other by means of primary and foreign key I cant able to combine these two tables while designing in aspx window. I can able to combine in .rdl file that is normal ssrs, when coming here (.rdlc) I cant able to combine the two tables. I am using VS2008 and SQL2008. Please help me out by giving answer in detail.

    Wednesday, January 12, 2011 2:27 AM


All replies

  • User-49141863 posted

    Create a View in the database and use it in your rdlc. 

    Wednesday, January 12, 2011 3:12 AM
  • User2108234275 posted

    Thank you this is really helpfull. Please give solution for this issue also:

    I cant able to make any changes in the database tables. I am having only two tables and dont have the permission to change the query, but want to create single report using SSRS2008 in apsx file. Please suggest me.

    Wednesday, January 12, 2011 3:49 AM
  • User1471008070 posted


    You have to join these two tables together by means of primary and foreign key, then you could get all the datafields in these two tables. Then utilize these datfields on the report level.

    Challen Fu  

    Monday, January 17, 2011 7:50 AM
  • User2108234275 posted

    yea it can be done but the problem is in aspx reportviewer wizard we cant able to write any query over there. so I'm totally confused.. I'm using vs2008 and SQL 2008...

    Monday, January 17, 2011 8:34 AM
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 19, 2011 5:21 AM