Refresh button on Data Explorer no showing new fields on the table/view

[Alexandre]

Hello,

I am trying to refresh the dataset at the Data Explorer window of the Report Designer so that it reflects the changes made to the database on the tables and views used as the data source for the report.

But it does not work. I can only see the new fields if I create a new data connection for the same tables/views.

What should be the rigth way to reflect the changes in the database to the report?

Regards,

Alexandre

[Neli]

Hi Alexandre,

If I understood correctly, you have an ObjectDataSource and when you make a change in the project with the datasource, you would expect this change to be reflected in the Standalone desgner. Note that this behavior is expected. You will need to replace the DLL in the folder of the Standalone designer.

[Alexandre]

Hello Neli,

Wich DLL should I replace and where do I find the update one?

[Neli]

Hi Alexandre,

In general, when you use the ObjectDataSource in the Standalone designer, you copy the DLL to the folder of the designer and register it in the configuration file. All steps are explained in theConnecting the ObjectDataSource component to a Data Source article. If you make changes to the datasource, then you need to copy the DLL again.

 

[Alexandre]

Hello Neli,

Maybe I did not express myself correctly. I am not using Visual Studio at this time. I am using just the Telerik Report Designer 2022, creating an stand alone report, with an embedded SQL Server conection string.

I am connecting the report to a View in SQL Server, and after establishing the connection I see the fields in the Data Explorer of the Report Designer.

But, If I remove or add a field to my View in SQL Server, that change is not replicated in the report data source. I can not see the new ou subtracted field in the data explorer.

How do I make the changes in the view replicate in the data source of the Report Designer?

Regards,

Alexandre

[Neli]

Hi Alexandre,

Thank you for the additional details.

We are dependent on the ADO.NET provider and for that reason, I am afraid that such functionality cannot be implemented. Once you reopen the designer, the datasource will be reloaded. Note that if for example you delete a column from the database, then reopen the report, you will get an exception in the group explorer indicating that this column cannot be found.

[Alexandre]

Hello Neli,

I found a workaround the problem by modifying the Select Command in the datasource.

Regards,

Alexandre