ObjectDataSource in Web Report Designer

[Tamara]

Dear support team,

 

We have successfully configured the Telerik Report Server to use reports with custom functions by following the instructions on the link:

https://docs.telerik.com/report-server/knowledge-base/how-to-use-custom-function-in-report-server#environment

 

The reports work fine on the Telerik Report Server, but we cannot access the ObjectDataSource component via the Web Report Designer. We can do that only in Standalone Designer.

So, what is obvious is that the ObjectDataSource component is resolved at runtime, using the configuration of the running application, but in the ObjectDataSource wizard the object is not displayed. We get a message that no business object type have been found on the server.(Image attached)

 

Could you please help us with this issue?

[Dimitar]

Hello Tamara,

If I understand correctly, the problem is only with the Report Server's built-in Web Report Designer, is that correct?

For the Web Report Designer to be able to resolve the assembly with the ObjectDataSource, the assembly should also be registered in the Web.config file of the Report Server located at the following path:

C:\Program Files (x86)\Progress\Telerik Report Server\Telerik.ReportServer.Web

In order to use the assemblyReferences element in that configuration file, you need to also add the Telerik.Reporting section in configSections, for example:

<?xml version="1.0" encoding="utf-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
    <configSections>
        <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
        <section name="Telerik.Reporting" type="Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting" allowLocation="true" allowDefinition="Everywhere" />
    </configSections>
    ...
    <Telerik.Reporting>
        <assemblyReferences>
            <add name="MyAssembly" />
        </assemblyReferences>
    </Telerik.Reporting>
</configuration>

The assembly MyAssembly should be available in the bin directory of the Report Server because that is where it will be searched for at runtime.

C:\Program Files (x86)\Progress\Telerik Report Server\Telerik.ReportServer.Web\bin

Please test this approach and let me know how it goes.

Regards,
Dimitar
Progress Telerik