Hi,

I like to hide the built in toolbar of ReportViewer (WPF Core 3.1, Telerik Release 14.2.20.1021). First it does not fit in my UI design, second I do not need most of the buttons, they would only irritate my customer. What's the fastest way to do this?

Regards
Heiko

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

ReportModelViewer missing?

Up until this point I have been triggering the ReportViewer Commands (MoveToNextPageCommand, MoveToLastPageCommand, etc...) through the ReportViewerModel in an WPF application. I am using the commands this way because we have a customer menu from which we are triggering the commands and so simply editing the template for the ReportViewer will not serve the intended purpose.

I have just upgraded to Q3 2014 (latest) from Q2 2014 and I am now unable to get to the ReportViewerModel from WPF. Has an alternative access method for the commands been developed and I'm just missing it? I must have access to the commands for the application that I have here. I upgraded because in order to really get a nice UI I needed to be able to find out when the report rendering was complete so that I could get an accurate complete page count and set up some other things, but as of now it appears to have come at the cost of my custom toolbar failing.

Telerik Report in .net framework MVC show message 

Error requesting viewer with the service String was not recognized as a valid DateTime

randomly. sometime it occur and after refresh or enter it again the report can render

I open Console and developer tool in browser and get request from

/api/reports/clients (error 500)

after that I call the request with curl and it error happen randomly.

nothing change in application so I'm not sure it from library or not? thank you

Hello,

 

For my report I will have multiple records with the same date, but each with different times. I was hoping to be able to show an aggregate for the data for each date, with a drill down to show more info for the different times. So far I have been unable to actually get the dates to combine at all, and instead will show every record. How can I get the records to combine into a single row?

 

Currently showing:

 

Day     Sum(price)

1

Can anyone give me an example of how to do this. The docs are very thin.

Thanks … Ed

 

Hello,

    In a report that I am working on I have a string field coming in from a web service data source that has carriage returns and line feeds in it.

    I would like to remove those \r\n instances and have a single line for my string field.

 

Hello everybody, 

I'm triyng to define a custom DocumentName for my Report Book (trbp) from Javascript for TelerikViewer. Here my code example for your reference. 

First I initialize telerik Report Viewer:

 $scope.loadTelerikViewer = function () {
            $("#reportViewer").telerik_ReportViewer({
                serviceUrl: "/api/reports",

                reportSource: {
                    report: null,
                    parameters: {
                    }
                },

                // Specifies whether the viewer is in interactive or print preview mode.
                // PRINT_PREVIEW - Displays the paginated report as if it is printed on paper. Interactivity is not enabled.
                // INTERACTIVE - Displays the report in its original width and height without paging. Additionally interactivity is enabled.
                viewMode: telerikReportViewer.ViewModes.INTERACTIVE,

}

Than based on required report Id i change the report source as follow:

var viewer = $("#reportViewer").data("telerik_ReportViewer");
            if ($scope.reportId == 1) {
                viewer.reportSource({
                    report: $scope.fileReportName,
                    parameters: {
                        ReportTitle: $scope.reportTitle,
                        DownloadFileName: $scope.downloadFileName,
                        ConnectionString: $scope.dbStringConn,
                        Client: $scope.JobObject.Client,
                        ManufacturingPlant: $scope.JobObject.PlantClient + ' ' + $scope.JobObject.StateClient,
                        Plant: $scope.JobObject.JobDescription,
                        JobId: $scope.JobObject.JobId,
                        ShowAllDoc: $scope.allDocument
                    }
                });
            }

 

Is there a way to define a custom Document Name for my given TRBP file? 

Thanks

Bruno

HI All, 
I currently have a report where i have a crosstab table that list staff and their respective logon time and break report. I would like to have a summary section at the top of the report and outside the cross tab so that we can indicate the staff with the heights break and the name of the staff.The orange area in the attachment.

Currently, i have attempted to use IFF function but it has not been successful as the true and false parts of the IFF functions are not only staff that meet the expression. I am currently using the following expression. 

=IIF((Fields.BreakDuration) > 0 AND Exec('table2', (Fields.BreakDuration)) <= Exec('table2', Max(Fields.BreakDuration)),
"Highest Agent Break Time: " + Fields.AgentName + " - " + Format("{0:00}:{1:00}:{2:00}"
                   , Truncate((Max(Fields.BreakDuration)) / 1000 / 3600)
                   , Truncate(((Max(Fields.BreakDuration)) /1000/60) MOD 60)
                   , Truncate(((Max(Fields.BreakDuration)) / 1000) MOD 60)
 ),"No Break Time ") 

Hi, so glad to have found the web designer - thanks. I just used VS template to add it to a demo project and it worked well (apart from web.system import missing). On running the demo I tried to add a CSV Datasource and get this error:

    Could not save resource 'BOOKED.csv'.
    An error occurred while loading the data schema for "csvDataSource1": Invalid URI: The URI is empty.

Is there a quick config change needed in the project to allow uploads??

Also I tried to find documentation about the web designer and didn't find much beyond one page.  Do you have details on how to (programmatically/config) create an empty report and add 4-5 default datasources so the user has something to start with?

Thanks, Matt