Last post Jan 19, 2011 05:21 AM by You-Hu Fu
Jan 12, 2011 02:27 AM|padmanaban1888|LINK
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.
Jan 12, 2011 03:12 AM|er.tushar|LINK
Create a View in the database and use it in your rdlc.
Jan 12, 2011 03:49 AM|padmanaban1888|LINK
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.
Jan 17, 2011 07:50 AM|You-Hu Fu|LINK
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.
Jan 17, 2011 08:34 AM|padmanaban1888|LINK
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...
Jan 19, 2011 05:21 AM|You-Hu Fu|LINK
Refer to this similar thread