Telerik Forums
Reporting Forum
11 answers
600 views

Hi,

I'm having a heck of a time.  I have a trdp created with the stand alone designer.

I am NOT using the UI for parameters from the trdp(i.e. When you open the report in the report designer, all the report params are set visable = false.

The report works great when it initially loads. After the first rendering, I, though my own ui above the report, can change parameters and hit a button to refresh the report. However, none of the new parameter values are being reflect in the report.  I've tried in vane to catch the NeedDataSource event. 

There must be some secret sauce I am not pouring on my code. 

Bottom line, I would surely like an example that shows how to pass single parameters was well as and perhaps more importantly multivalue parms.

There's a lot of stuff on the net talking about passing parms,  but very little that are Blazor centric.

Please let me know if I need to explain anything further.

In the meantime, I'll go back to pulling my hair out

I've attached the razor, razor.cs and trdp files.

I working on a Blazer Server environment.

Thanks … Ed

.

 

Neli
Telerik team
 answered on 03 Dec 2020
4 answers
500 views

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

Sia
Telerik team
 answered on 02 Dec 2020
15 answers
1.3K+ views

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

Neli
Telerik team
 answered on 02 Dec 2020
8 answers
246 views
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.
Dimitar
Telerik team
 answered on 30 Nov 2020
6 answers
245 views

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

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 27 Nov 2020
2 answers
562 views

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

Mads
Telerik team
 answered on 26 Nov 2020
1 answer
138 views

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

Thanks … Ed

 

Neli
Telerik team
 answered on 24 Nov 2020
6 answers
1.6K+ views

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.

 

Ezra
Top achievements
Rank 1
 answered on 20 Nov 2020
2 answers
297 views

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

prisma
Top achievements
Rank 1
 answered on 19 Nov 2020
1 answer
285 views

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 ") 


Mads
Telerik team
 answered on 19 Nov 2020
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?