Last post Aug 02, 2011 01:15 AM by Bryan Strader
Oct 06, 2010 02:34 PM|schavez19|LINK
Is it impossible to add tables to an existing dataset and then display new fields on the report? SSRS seems to "see" and let me "add" the new table just fine. However, when I try
to add any of the new data I get scope errors.
I could re-write the Store Procedure to include the data I need. But adding a table and relationship to my existing table adapter datasource seems so much more efficient.
Thank you in advance for any helpful suggestions.
Aug 02, 2011 01:15 AM|Bryan Strader|LINK
I would suggest that rewriting the stored procedure to include the other table via a join would be more efficient. SQL stored procedures get their execution plan stored by SQL Server, which means execution time is optimized.