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

1 Answer 63 Views
Report Designer (standalone)
Alexandre
Top achievements
Rank 2
Iron
Iron
Alexandre asked on 13 May 2022, 05:47 PM

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
Telerik team
commented on 18 May 2022, 01:19 PM

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
Top achievements
Rank 2
Iron
Iron
commented on 19 May 2022, 10:30 AM

Hello Neli,

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

Neli
Telerik team
commented on 19 May 2022, 10:43 AM

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.

 

1 Answer, 1 is accepted

Sort by
0
Alexandre
Top achievements
Rank 2
Iron
Iron
answered on 21 May 2022, 12:02 PM

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
Telerik team
commented on 25 May 2022, 09:38 AM

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
Top achievements
Rank 2
Iron
Iron
commented on 26 May 2022, 10:40 AM

Hello Neli,

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

Regards,

Alexandre

Tags
Report Designer (standalone)
Asked by
Alexandre
Top achievements
Rank 2
Iron
Iron
Answers by
Alexandre
Top achievements
Rank 2
Iron
Iron
Share this question
or