Hi,

I have a Report Book with multiple Reports and each of them with multiple subreports.

Each Main-Report (the reports directly in the Report Book) has a BookmarkId set.

If I click on one of the bookmarks in the Document Map (or later in a PDF, it's the same behaviour), it jumps not the the beginning of the first page of the report but a bit scrolled down.

It seems to where the Detailsection begins.

So my question:

Is it possible to jump to the Pageheader instead somehow?

Greetings
Benedikt

This is using c sharp and wpf. Without using the report designer I need to change the suggested file name that comes up once you choose a file format to export as and it opens the file dialog. Currently my report displays userReport1 as the name. I want to input two strings values of id numbers as the file name instead.

Alternatively if I was to use parameters in the designer to change the name how would I go about that?

Good Evening Telerik,

I ran the same report out of Crystal and Telerik. Crystal shows the correct average time. and, Telerik (sometimes?) shows the correct average time. it randomly marks some of them a negative number. (see below) The SQL query is the same between Telerik and Crystal. so maybe I am formatting something wrong in Telerik?

Here is an example of the same exam ran out of both applications. diff results on the average Comp to Prov and Comp to Final

I have a bunch of reports that were created in .net framework 4.7.2 using the Visual Studio report designer (created as .cs files).  I'm upgrading the solution to .net 6.

I've updated to the correct nuget packages for Telerik winforms and Telerik Reporting, and from what I've read, I need to convert all those reports to a format that will work in the standalone report designer.

I moved all the reports to their own class library, built the solution, an then tried to open that library's .dll file in the standalone designer as described here:

https://docs.telerik.com/reporting/designing-reports/report-designer-tools/desktop-designers/standalone-report-designer/how-to-import-reports-created-with-the-vs-report-designer

Every time, I get an error:

System.Reflection.TargetInvocationException... System.IO.FileNotFoundException: Could not load file or assembly 'System.ComponentModel.TypeConverter, Version=6.0.0.0... The system cannot find the file specified.

I cannot find any reference to that in the report files, and I can't find any verion 6.0.0.0 for .net 6 out there to even install.  I did try adding a package reference to a .net std verion, but it's 4.x from 2016.

How can I get past this error so the report can be imported?

Hello.

Currently I am designing a report on which I have date and datetime data types.

I have prepared the data-base table with data that goes into the report (attachment data-model.png)

I prepared report template in telerik web report designer (attachment report_template.png)
I set format according to Standard DateTime Format Strings
Field with date data has format {0:d}

On preview (at Web Report Designer) the date seems to be ok (attachment preview.png)

Unfortunately, after exporting the report to excel (xlsx), the date type is not a date in excel (attachment invalid_format.png)

My appsetting.json file contains

"telerikReporting": {
  "extensions": [
    {
      "name": "XLSX",
      "parameters": [
        {
          "name": "UseExtendedFormatting",
          "value": "False"
        }
      ]
    }
  ]
}

What should I have to set/do in order to have date format in excel for cells that contain date and date-time data?
I would like to achieve result like below: for cell that contain date data in report I need date format in excel

I would like to emphasize that Standard Numeric Format Strings work:

• C or c (Currency) works fine
• N or n (Number) works fine
• G or g (General) works fine
• P or p (Percent) works fine

Environment:

• Visual Studio 2022
• .NET 6
• Web report designer written in Razor pages
• Packages (I know it's not the latest version, but it works the same badly on the latest version)
  • Telerik.Reporting v. 16.2.22.1109 (v2022.3.1109)
  • Telerik.Reporting.OpenXmlRendering v. 16.2.22.1109 (v2022.3.1109)
  • Telerik.WebReportDesigner.Services v. 16.2.22.1109 (v2022.3.1109)
• jQuery v. 3.6.0
• Windows culture pl-PL
• I run my project on IIS
  • IIS version 10
  • culture pl-PL
• project culture pl-PL
• I set kendo.culture("pl-PL");
  • culture file https://kendo.cdn.telerik.com/2022.3.1109/js/cultures/kendo.culture.pl-PL.min.js

regards

Dear supporting team,

First of all, I apologize for the typo in the title. I can't fix it

I used Telerik reporting to design the report. 

But I was facing a problem. I can not or don't know how to get the session value or cookie value in the ASP.NET Core Web App project.

The way I do it is:

• Create a new report by Report Designer
• Create an HTML page, and add the following code

    <script type="text/javascript">
        $(document).ready(function () {
            var au = document.cookie.split('=');
            var uname = au[1];

            var urlParams = new URLSearchParams(window.location.search);
            var rp = urlParams.get('r');
            $("#reportViewer1")
            
                .telerik_ReportViewer({
                    
		    serviceUrl: "/api/reports",
                    reportSource: {
                        report: "INV_ADJUSTMENT_DETAIL.trdx",
                        parameters: { user_name: uname, report: rp }
                    },
                    viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
                    scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
                    scale: 1.0,
                    enableAccessibility: false,
                    sendEmail: { enabled: false },
                    ready: function () {
                    },
                });
        });
    </script>

And in the Program.cs

.....
builder.Services.TryAddSingleton<IReportServiceConfiguration>(sp => new ReportServiceConfiguration
{
	ReportingEngineConfiguration = sp.GetService<IConfiguration>(),
	HostAppId = "Html5ReportViewerDemo",
    Storage = new FileStorage(),
	ReportSourceResolver = new CustomReportSourceResolver()
});

builder.Services.AddSingleton<IHttpContextAccessor, HttpContextAccessor>();
builder.Services.AddHttpContextAccessor();
builder.Services.AddDistributedMemoryCache();
builder.Services.AddSession(session =>
{
	session.IdleTimeout = TimeSpan.FromMinutes(60);
	session.Cookie.HttpOnly = true;
	session.Cookie.IsEssential = true;
});
.....

In the report designer, how can I use the value in reportSource -> parameters?

Is there a possible solution for this? please help advise.

Visual Studio version: Microsoft Visual Studio Professional 2022

Framework: .Net 6.0

Telerik packages:

• Telerik.Reporting v.17.0.23.315; 
• Telerik.Reporting.OpenXmlRendering v.17.0.23.315;
• Telerik.Reporting.Services.AspNetCore 17.0.23.315

Many thanks,

Dinh Phong

Hello

First of all, I apologize for the wrong title. I can't fix it
It's about print preview, not html5viewer.

I was going to edit it, but the title isn't working. I'm sorry.

I'm currently using Kendo Report for my company internal project.
It consists of ASPNET CORE MVC, and if requested by the user, it is displayed in html5 viewer.
I installed the font on the server where the Report Server is located and saw it as an html5 viewer because I had to change the font in a specific project, but the font was not recognized normally.
It's actually a font called HY GunGothic, and it's automatically changed to MalgunGothic.
I installed the HY GyunGothic font on the computer on the corresponding Report Server and even rebooted it, but the result was the same.

In the second way, I thought that using private fonts can apply the font regardless of whether the font is on the Host Machine or not,
I modified the web.config file of the project as follows.

[web.config]

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <Telerik.Reporting>
    <privateFonts>
      <add fontFamily="NanumSquareRoundEB" path="~/Fonts/NanumSquareRoundEB.ttf" fontStyle="Regular"/>
    </privateFonts>
  </Telerik.Reporting>
  <system.webServer>
    <handlers>
      <add name="aspNetCore" path="*" verb="*" modules="AspNetCoreModuleV2" resourceType="Unspecified" />
    </handlers>
    <aspNetCore processPath="%LAUNCHER_PATH%" arguments="%LAUNCHER_ARGS%" stdoutLogEnabled="false" stdoutLogFile=".\logs\stdout" forwardWindowsAuthToken="false" hostingModel="InProcess" />
  </system.webServer>
</configuration>

and create the StyleSheet.css file at the root of the project
I did the following.

[StyleSheet.css]

body {
}

@font-face {
    font-family: 'NanumSquareRoundEB';
    src: url('Fonts/NanumSquareRoundEB.ttf');
}

Also, the cshtml file in Views is as follows.

[Print.cshtml]

@{
    ViewData["Title"] = "POP PRINT";
}
<style>
    #reportViewerLayout {
        position: fixed;
        left: 0px;
        right: 0px;
        top: 0px;
        bottom: 0px;
        overflow: hidden;
        font-family: 'Arial';
    }
</style>
<link href="~/StyleSheet.css" rel="stylesheet" />
<div id="reportViewerLoading">
    Loading...        
</div>
<script type="text/javascript">
    $(document).ready(function () {
        $("#reportViewerLayout")
            .telerik_ReportViewer({

...

However, the result is that the font is broken as follows.
It came out normally in ReportDesigner, but strangely, it comes out like that in Html5Viewer.

[In ReportDesigner]

I thought it was a broken phenomenon (in my case, it's Korean) in a specific language, so I changed it to English and did it again, but the font is not applied anymore.

[Report Preview in Html5Viewer]

[Print Preview in Html5Viewer]

So here's the summary.

1. ReportServer installed and booted a font file on a computer distributed with IIS, but the font was applied by replacing it with Malgun Gothic, the default Korean font for Windows, instead of the Nanum Square RoundEB font for .trdp
2. The font file was inserted into the project by applying private fonts, but in English, the font is applied by changing to Malgun Gothic, the basic Korean font in Windows, and the letters are broken when used in Korean
3. And for now, it looks normal on html5viewer, but I don't know why print preview is different.
I saved it as a pdf file just in case, but the letters are saved in the same broken form.

I bought a license and am using it now, is there any additional part I need to buy to use the font?
I'm taking a lot of time to solve that part.

If there is a sample project that customizes the font of the Telerik Report among the ASP NET CORE projects, please let me know.

I have a chart with a bar series and a line series, where I would like the line series to form a cumulative % of the total.

My data set is a list of records with an "Injury Type" field, and the bar series counts the instances of each injury type

The line series is a calculation of the count of instances of that type divided by the total count of the graph.

What I would like instead, is to have a cumulative % of the line so that at the end it would = 100% like a Paredo chart would

Screenshot attached

I just migrated from building with react-scripts to vite, as it seems react-scripts is deprecated. After the change, the react report viewer is not functioning correctly. Browser console shows:

Instantiation of Kendo TreeView as Document Map threw an exception TypeError: $kendoHtmlEncode is not a function

Uncaught (in promise) TypeError: $kendoHtmlEncode is not a function

I did some investigating and it seems that window.kendo has no properties/functions defined like it did before. Is there a possible work around for this?

EDIT: using version 19.23.718

EDIT2: For now, I've shifted to using the Html5 report viewer as described here: https://github.com/telerik/reporting-docs/blob/master/knowledge-base/how-to-use-html5-viewer-in-react-js.md