hi there is a table in my database ,but when i created data source for the same database,and after creating data source view, i got to know that the table for which i am looking for is not there in my data source view.how do i add that particular table in to my data source view.and i also want to create a relation ship with other tables. Plz help me out

I wasn't sure if you are saying the you run the view wizard that your table doesn't show up there or after you previously created the view you forgot to include a table. If it's the 1st problem it would be based on the datasource permissions being used. For example if your datasource is using a sql user account then that sql user account should have permissions to this table. So in SQL Server Management Studio you want to check the permissions of a table that the data view sees and then go to that other table and see the permissions for it. It's probably the new table does not have select permissions for the sql account you are using in your model project data source. If the problem is the second issue, you can just double click the data source view in BIDS and then right click anywhere in the view and select add/remove tables. Your table should appear on the left and just select it to the right column. I believe you will have to rebuild your report model so that it will include your new table.

Hi SANDEEP_MCTS, Thanks for your question. Tim’s reply is logical and valuable, please follow the steps to check your scenario, For more information and detail steps about Defining a Data Source View, please refer to: http://msdn.microsoft.com/en-us/library/ms170023.aspx. Hope it helps you, if your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.