Problem: When creating a DataSet in VS from stored proc, if the stored proc uses temp tables, the dataset see's no columns and gives error #tempTableName is an invalid object. Details: stored proc simple example does "select fname into #temp from customers ; Select fname from #temp; Right click App_code in VS and create new dataset. Point to stored proc, no DataColumns will appear. This means that the reportViewer control cant use the datasource, the end consumer for me. TIA Don
