This is a migrated thread and some comments may be shown as answers.

new data source lost fields

1 Answer 175 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Matthew Hile
Top achievements
Rank 1
Matthew Hile asked on 30 Mar 2009, 01:31 PM
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 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 01 Apr 2009, 03:07 PM
Hello Matthew,

Please elaborate in details preferably with step by step on how you update the underlying datasource and where do you do this. You're talking about adding new fields, which means that the schema is changed and our report has no way of knowing for this change. The same goes for changes you make to the SQL server database.
As you probably know Telerik Reporting does not provide its own data layer but depends on the existing .NET objects (DataSet, Data Table, DataView, ADO.NET, lists etc. so it is not aware of the datasource nor does it matter to it (as long as it is supported).
We would recommend doing this with a standard asp.net control such as asp:DataGrid and if your approach works with it, but you're having problems with the report, we would gladly review it and advise you accordingly.

Best wishes,
Steve
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.
Tags
General Discussions
Asked by
Matthew Hile
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or