Telerik Forums
Reporting Forum
1 answer
1.7K+ views
I have a textbox with the following content: 
=Sum(LossOfDaysMen)/(Sum(LossOfDaysNotSet)+Sum(LossOfDaysMen)+Sum(LossOfDaysWomen))*100 + "%"

This is giving me numbers with way too many decimals, like '66.44295155..', i want to to have just 1 decimal. How can i do this within the textbox? I tried String.Format, but that does not work. Setting the format property on the entire textbox does not work either, due the '+ "%" at the end. 

I assume there's some function i can run but im unsure about what syntax works within the textbox.

Any ideas how to solve this?
Dimitar
Telerik team
 answered on 10 Dec 2020
1 answer
504 views
Hi,
How to remove borders inside a table when page break? (look attach file)
Dimitar
Telerik team
 answered on 09 Dec 2020
1 answer
149 views

Hello everyone,

i have a question regarding the design view of the html box. I have a tabel which i get by an SQL statment. In the view of the designer the table is correctly shown but in the preview the table is not shown, only the content.

Has the design view of the html box more possibilities to view content as the designer itself?

 

Best Regards

 

Alex

Dimitar
Telerik team
 answered on 09 Dec 2020
2 answers
346 views

Hello everyone,

i have a question regarding the border of a table.

Basically have a table which has a filter implemented. The table (not the text box) has a border.

But even if there is no content there is still a tiny black mark on the printout (see att.)

Is this on purpose?or an technical issue?

(I know that this issue can be partially resolved by using the border of the nested Textbox but there are some configaurations - Tiltet table with more rows and Boxes with different filters and only the top and last row should have a border. Using a line element could be an option but the border on the table would be a"nicer" solution.)

Dimitar
Telerik team
 answered on 09 Dec 2020
12 answers
657 views
Hi,
 I am trying to create a report with crosstab.The Crosstab contains three row  groups.Third group is under the second group and  second group under the first.then I want to break the crosstab after each first group.How can I break the crosstab.

Thanks In Advance....

Rajisha
Neli
Telerik team
 answered on 07 Dec 2020
5 answers
886 views

Our Images are on Azure Blob Storage and it needs a special SAS token to access (https://docs.microsoft.com/en-us/azure/storage/common/storage-dotnet-shared-access-signature-part-1).

We generate the Url on runtime and return it to the report viewer with valid SAS (proper Url), and sometimes the images render and other times it just gives 403.

An error has occurred while processing PictureBox 'Images':
Invalid image data.
------------- InnerException -------------
The remote server returned an error: (403) Forbidden.

Even if the images render in the viewer, when we go try to generate a PDF, it always throws the above error.

Harsimrat

 

Christine
Top achievements
Rank 1
 answered on 03 Dec 2020
3 answers
177 views
When WPF Report Viewer inside other control (e.g. TabControl) all events (PrintBegin, PrintEnd, ExportBegin, ExportEnd etc.) fires twice, because Loaded event fires twice and you call AttachModelEventHandlers method also twice.
Neli
Telerik team
 answered on 03 Dec 2020
11 answers
590 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
476 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.2K+ 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
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?