I created an elaborate report using a SQL view as a data source. I updated the view in SQL and tried unsuccessfully
1. To get the new fields include in the report by redoing the datasource in VS. (When I updated the data source and tried to run the report I get red boxes saying that I have null values. However, running the datasource and viewing the returned records shows that those fields are not null.)
2. Create a new report with the new data set. Then replacing the dataset in the first report with this new data set and tableAdapter. When I try this I get red boxes with "object not set ot an instance of an object." Additionally, when I try to edit my expressions I get no Fields listings at all. Is seems from this that the old report has not recognized the data returned in the new data source.
I suspect that there is very simple answer. But how do I up date the data the report is looking at when I update the view in SQL server?
Thanks,
Matthew
1. To get the new fields include in the report by redoing the datasource in VS. (When I updated the data source and tried to run the report I get red boxes saying that I have null values. However, running the datasource and viewing the returned records shows that those fields are not null.)
2. Create a new report with the new data set. Then replacing the dataset in the first report with this new data set and tableAdapter. When I try this I get red boxes with "object not set ot an instance of an object." Additionally, when I try to edit my expressions I get no Fields listings at all. Is seems from this that the old report has not recognized the data returned in the new data source.
I suspect that there is very simple answer. But how do I up date the data the report is looking at when I update the view in SQL server?
Thanks,
Matthew