Creating reports with temp tables
Hi,
I have created a new datasource that runs a stored procedure. The stored procedure uses a temp table and returns the contents of the temp table.
When I add the stored procedure to the datasources window it cannot figure out the column names of the temp table. I can preview the data from VS2005 and it works fine.
However when designing the local report I have no fields to drag on to the form.
I choose Report - Report DataSources and pointed to the dataset of the stored procedure. I dropped a text box on the report and manually added Fields!DepartmentName.Value which I know is one of the column names, but that produces the error "The Value expression for the textbox ‘textbox1’ refers to the field ‘departmentName’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."
How do I get around the problem of not having any column names in my dataset?
THanks in advance!
