configure standalone report designer for postgresql data source

4 posts, 0 answers
  1. John
    John avatar
    3 posts
    Member since:
    Feb 2019

    Posted 07 Nov Link to this post

    i'm evaluating Telerik Reporting and would like to configure the Standalone Report Designer to use Postgresql as a Data Source.

    the attached config files dont seem to work, but i'm not sure what's wrong with what i've done. using MY config files, the StandAlone report Designer does not show up.  using the config file(s) that came with the product, the designer comes up but of course it's not possible to pick Postgresql as a data source

     i'm using Postgresql 12 with Npgsql 4.1.1 as the driver in a 64bit Windows 10 Pro desktop machine.

     

    i followed the instructions in:

    https://www.telerik.com/support/kb/reporting/accessing-and-managing-data/details/how-to-register-sqldatasource-data-providers-without-driver-installation
    to modify the default config file (Telerik.ReportDesigner.exe.config  as well as Telerik.ReportDesigner.x86.exe.config)

    i've done:

    nuget install Npgsql -Version 4.1.1

    and put all the required dlls in same folder as Telerik.ReportDesigner.exe in C:\Progress\Telerik Reporting R3 2019\Report Designer

    and my config file(s) is as follow (the x86 is same as the 64bit file)

     

    <?xml version ="1.0"?>
    <configuration>
    <configSections>
    <section
    name="Telerik.Reporting"
    type="Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting"
    allowLocation="true"
    allowDefinition="Everywhere"/>

        <section
            name="Telerik.ReportDesigner"
            type="Telerik.ReportDesigner.Configuration.ReportDesignerConfigurationSection, Telerik.ReportDesigner.Configuration"
            allowLocation="true"
            allowDefinition="Everywhere"/>    
    </configSections>

    <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
    </startup>

      <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
          <!--
          <probing privatePath="path-to-the-assemblies"/>
          -->
          <dependentAssembly>
            <!-- Required for interoperability with older versions of Telerik Reporting -->
            <assemblyIdentity name="Telerik.Reporting" culture="neutral" publicKeyToken="a9d7983dfcc261be"/>
            <bindingRedirect oldVersion="0.0.0.0-13.2.19.1030" newVersion="13.2.19.1030"/>
          </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="Npgsql" culture="neutral"publicKeyToken="5d8b90d52f46fda7"/>
            <codeBase version="4.1.1.0" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\Npgsql.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="System.Buffers" culture="neutral"publicKeyToken="cc7b13ffcd2ddd51"/>
            <codeBase version="4.0.3.0" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\System.Buffers.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="Microsoft.Bcl.AsyncInterfaces" culture="neutral"publicKeyToken="cc7b13ffcd2ddd51"/>
            <codeBase version="1.0.0.0" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\Microsoft.Bcl.AsyncInterfaces.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="System.Memory" culture="neutral"publicKeyToken="cc7b13ffcd2ddd51"/>
            <codeBase version="4.0.1.1" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\System.Memory.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="System.Numerics.Vectors" culture="neutral"publicKeyToken="b03f5f7f11d50a3a"/>
            <codeBase version="4.1.4.0" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\System.Numerics.Vectors.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="System.Runtime.CompilerServices.Unsafe" culture="neutral"publicKeyToken="b03f5f7f11d50a3a"/>
            <codeBase version="4.0.5.0" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\System.Runtime.CompilerServices.Unsafe.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="System.Text.Encodings.Web" culture="neutral"publicKeyToken="cc7b13ffcd2ddd51"/>
            <codeBase version="4.0.4.0" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\System.Text.Encodings.Web.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="System.Text.Json" culture="neutral"publicKeyToken="cc7b13ffcd2ddd51"/>
            <codeBase version="4.0.0.0" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\System.Text.Json.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="System.Threading.Tasks.Extensions" culture="neutral"publicKeyToken="cc7b13ffcd2ddd51"/>
            <codeBase version="4.2.0.1" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\System.Threading.Tasks.Extensions.dll"/>
      </dependentAssembly>
      
      <dependentAssembly>
            <assemblyIdentity name="System.ValueTuple" culture="neutral"publicKeyToken="cc7b13ffcd2ddd51"/>
            <codeBase version="4.0.0.0" href="FILE://C:\Progress\Telerik Reporting R3 2019\Report Designer\System.ValueTuple.dll"/>
      </dependentAssembly>
      
        </assemblyBinding>
      </runtime>

      <connectionStrings>
        <add name="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"
            connectionString="TELERIK_CONNECTION_STRING"
            providerName="System.Data.SqlClient" />
      </connectionStrings>
      
      <Telerik.ReportDesigner DefaultWorkingDir="Examples">
      </Telerik.ReportDesigner>

      <system.data>
    <DbProviderFactories>
      <add name="Npgsql Data Provider"
       invariant="Npgsql"
       description=".Net Framework Data Provider for Postgresql Server"
       type="Npgsql.NpgsqlFactory, Npgsql, Version=4.1.1.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
    </DbProviderFactories>
      </system.data>
    <!-- Add assembly references -->
    <!--
    <Telerik.Reporting>
    <AssemblyReferences>
    <add name="MyFunctions" version="1.0.0.0" />
    </AssemblyReferences>
    </Telerik.Reporting>
    -->

    <!--  
    <system.diagnostics>
    <trace autoflush="true" indentsize="4">
    <listeners>
    <add name="myListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="C:\Temp\Telerik.ReportDesigner.log" />
    <remove name="Default" />
    </listeners>
    </trace>
    </system.diagnostics>
    -->
    </configuration>

    Back to Top

  2. Eric R | Technical Support Engineer
    Admin
    Eric R | Technical Support Engineer avatar
    230 posts

    Posted 11 Nov Link to this post

    Hi John,

    This appears to be because of the naming of the href value located in the codeBase element for dependent assemblies. The codeBase href is expecting an absolute path instead of a relative path. Generally, applications using .NET will look in the current directory for assemblies. Although sometimes they need to be told where to look. See the attached config samples that should work with your scenario. Note that the config file names should be changed to Telerik.ReportDesigner.exe.config.

    If the issue persists, let me know and I will convert this to a support ticket so we can investigate more thoroughly.

    Please try out the attached configs and let me know the results. Thank you for evaluating Reporting and I look forward to your reply.

    Regards,


    Eric R | Technical Support Engineer
    Progress Telerik

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. John
    John avatar
    3 posts
    Member since:
    Feb 2019

    Posted 12 Nov in reply to Eric R | Technical Support Engineer Link to this post

    Thanks for the files, Eric, but none of them worked. (i did rename them to 

    Telerik.ReportDesigner.exe.config and Telerik.ReportDesigner.x86.exe.config).

     

    Are there log files I could look at?

     

    I'm bothered that the Report Designer just doesnt show up without report messages to the user.

     

    also, the supported runtime for the Report Designer is .Net Framework 4.0.

    the dlls that i downloaded sometimes are in folders labeled net461, netstandard1.1, netstandard2.0, netstandard2.1,

    netcoreapp2.0, and / or netcoreapp3.0. as much as possible, which ones should i choose ?

     

    Does Report Designer support .Net Core versions since .Net Core is our preferred runtime?

  4. Eric R | Technical Support Engineer
    Admin
    Eric R | Technical Support Engineer avatar
    230 posts

    Posted 13 Nov Link to this post

    Hi John,

    Telerik Reporting can be used with .NET Core Applications when embedding the Reporting Engine or using the HTML5 Report Viewer. At this time however, the Stand Alone Report Designer is delivered with the default Telerik Reporting installation and targets .NET 4.0 as previously noted. Additionally, I am not certain providing log files will resolve the issue. 

    With that said, if I understand the scenario correctly. It should work with the PostgreSQL assemblies in the default Report Designer installation folder and one of the previous configurations. See the below screenshot for a visual reference. 

    I recommend zipping up your default installation folder and attaching it to this thread. If you are unable to attach the folder to a public thread, I can still convert this to a Support Ticket so that all communication is then handled privately. Let me know if you would like to pursue this option.

    In the meantime, let me know if you need any additional information. Thank you and I look forward to your reply.

    Regards,


    Eric R | Technical Support Engineer
    Progress Telerik

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top