Questions on Reporting Forum

0 answers

171 views

i can get the document map on my local machine but when deployed on the server it is not applied please help me to resolve it thanks

.NET Core

.NET Framework

Conditional Formatting

DataSource SQL

Grouping

Report Parameters

Report Viewer - Angular

Report Viewer - HTML5

asked on 26 Sep 2022

0 answers

598 views

Error {"message":"An error has occurred.","exceptionMessage":"Type: Telerik.Reporting.ReportSerialization.V4_0.ReportSerializable`1[Telerik.Reporting.Report]","exceptionType":null,"stackTrace":null}

Hello EveryBody,

I have an mvc aplication in .netcore6 where i´m implementing a telerik reporting 2022 reportviewer´s, but when testing it on a linux machine the report generates this error:

{"message":"An error has occurred.","exceptionMessage":"Type: Telerik.Reporting.ReportSerialization.V4_0.ReportSerializable`1[Telerik.Reporting.Report]","exceptionType":null,"stackTrace":null}

It is the response when the reportviewer consult the parameters of the report.

this error does not occur in windows machine

This error occurs when add several mvc controllers to my project,

Help me!

.NET Core

Report Viewer - HTML5

Rest Service

asked on 23 Sep 2022

4 answers

1.3K+ views

ConnectionString Report Parameter and Binding

I need to dynamically provide a ConnectionString to a .trdp at runtime.
I've tried to use a parameter and a binding as stated here: https://docs.telerik.com/reporting/knowledge-base/how-to-pass-connectionstring-to-report-dynamically-through-report-parameter
but I can't get it to work. Without the parameter and binding, the existing dataSource works fine in preview. I'm using Standalone Report Designer 13.2.19.1213. When I add the parameter and binding, and put the connection string value in the parameter input box during preview, I get an error. See the attached picture that shows all settings.

General Discussions

answered on 22 Sep 2022

1 answer

488 views

[Solved] Web Report Designer works locally but not on the live server

We're facing an issue that we can't quite solve. We have integrated the Web Report Designer into our ASP.NET Framework 4.8 project and it's work a treat when running it on my machine under IIS. We tried to publish it onto our live server, but we get an error code 500.

The ASPX page:

<%@ Page Language="c#" CodeBehind="TelerikReportDesigner.aspx.cs" AutoEventWireup="True" Inherits="Traxs.ASPX.TelerikReportDesigner" %>
<!DOCTYPE html>
<html>
    <head>
        <title>Report Designer</title>

        <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />

        <link href="https://fonts.googleapis.com/css?family=Roboto:400,500&display=swap" rel="stylesheet">

        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
        <script src="https://kendo.cdn.telerik.com/2022.3.913/js/kendo.all.min.js"></script>
        <script src="../api/reportdesigner/resources/js/telerikReportViewer"></script>
        <script src="../api/reportdesigner/designerresources/js/webReportDesigner"></script>
    </head>
    <body>
	<div id="webReportDesigner">Loading...</div>

	<script type="text/javascript">
            $(function () {
                $("#webReportDesigner").telerik_WebReportDesigner({
                    persistSession: false,
                    toolboxArea: {
                        layout: "list"
                    },
                    serviceUrl: "../api/reportdesigner"
                });
            });
    </script>
    </body>
</html>

The controller:

[Route("api/reportdesigner")]
public class ReportDesignerController : ReportDesignerControllerBase
{
    static ReportServiceConfiguration _configurationInstance;
    static ReportDesignerServiceConfiguration _designerConfigurationInstance;

    static ReportDesignerController()
    {
        var path = Path.Combine(HttpContext.Current.Server.MapPath("~"), "TelerikReportDesigner/Reports");

        var resolver = new UriReportSourceResolver(path)
            .AddFallbackResolver(new TypeReportSourceResolver());

        _configurationInstance = new ReportServiceConfiguration
        {
            HostAppId = "Html5App",
            Storage = new FileStorage(),
            ReportSourceResolver = resolver,
            ReportSharingTimeout = 0,
            ClientSessionTimeout = 20
        };

        string sessionId = HttpContext.Current.Request["ASP.NET_SessionId"];

        _designerConfigurationInstance = new ReportDesignerServiceConfiguration
        {
            DefinitionStorage = new DatabaseDefinitionStorage(path, sessionId),
            ResourceStorage = new DatabaseResourceStorage(),
            SettingsStorage = new DatabaseSettingsStorage()
        };
    }

    public ReportDesignerController()
    {
        this.ReportServiceConfiguration = _configurationInstance;
        this.ReportDesignerServiceConfiguration = _designerConfigurationInstance;
    }
}

The log generated by Fiddler Jam.

Thanks

.NET Framework

Report Designer - Web

answered on 19 Sep 2022

1 answer

201 views

[Solved] Range Bar with two ranges in one category not shown correctly

Hello,

I have a question about range bar charts. I use the latest release of reporting standalone designer. What I want to, is to have in the same category more than one range bar.

Here is what I get:

This is the data

What I expect is, that in category "Pause" a second range bar will be visible at the range from 1080 to 1439.

Is this not possible with report designer?

Regards

Karsten

Report Designer (standalone)

answered on 16 Sep 2022

1 answer

1.1K+ views

[Solved] System.OperationCanceledException: The operation was canceled. when rendering a report on Mac

I have a pretty simple report that shows a couple of fields and a cross tab with some child data. It's just for demo purposes for now. It runs against an object data source, a .NET 6 class and I'm setting the data source at runtime like so:

var reportProcessor = new ReportProcessor();
var reportSourcePath = Path.Combine(_config["reportTemplatePath"], "Test.trdp");
Telerik.Reporting.Report report = null;

using (var sourceStream = File.OpenRead(reportSourcePath)) {
    var reportPackager = new ReportPackager();
    report = (Telerik.Reporting.Report) reportPackager.UnpackageDocument(sourceStream);
}
report.DataSource = GetDataSource(customerId);  // Returns a .NET 6 object instance

Rendering the report thusly:

var reportSource = new InstanceReportSource();
reportSource.ReportDocument = report;
var result = reportProcessor.RenderReport("PDF", reportSource, new System.Collections.Hashtable());

This all works on Windows but fails on Mac at the RenderReport line with the following stack trace that I can't quite parse:

System.OperationCanceledException: The operation was canceled.
   at System.Threading.CancellationToken.ThrowOperationCanceledException()
   at System.Threading.ManualResetEventSlim.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.SpinThenBlockingWait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.InternalWaitCore(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.Wait(CancellationToken cancellationToken)
   at Telerik.Reporting.Paging.PageCompositionBase.SeparateThreadOutputBehavior.Finish()
   at Telerik.Reporting.Paging.PageCompositionBase.CreatePages()
   at Telerik.Reporting.Paging.PagerBase.Telerik.Reporting.Paging.IPager.CreatePages(IPageHandler handler, LayoutElement root)
   at Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(LayoutElement root, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback, PageSettings pageSettings)
   at Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
   at Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.<>c__DisplayClass46_0.<RenderReport>b__0(SingleStreamManager sm)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReportSafe(Func`2 renderCallback, String format, IRenderingContext renderingContext)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo, CancellationToken cancellationToken)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo)

I had an earlier error that I solved by installing the libgdiplus library but I can't figure out what's causing this. It seems to be related to the paging but to my knowledge, there is no paging in the report. Or at least no obvious paging; I modified it from the Speakers Report sample so maybe there's some lingering there? Either way, I don't know why it's failing on Mac but not Windows.

Rendering

answered on 16 Sep 2022

1 answer

480 views

[Solved] Plot DateTime axis with milliseconds

Hi,

I have a set of data with a timestamp that changes with the order of milliseconds. I would like to add in my report a Line chart (or similar) showing the data as a function of the timestime. Unfortunately it appears that the LineChart allows you to lower the base unit only to seconds and not milliseconds.

Is there any way to force the millisecond time?

As a workaround I tried two things:

First, to plot the data adding as cathegories the milliseconds, seconds, minutes, and h of the data. It works, but to be honest is not very pretty (see Img0.png)

Alternatively, I also tried to generate a Calculated field where I substract the Timestamp of the data with the First Timestamp, in order to have a time that starts from 0. From this Field, I wanted to manually calculate the milliseconds (adding also seconds, minutes, etc) in order to make a Scatter graph. However the obtained field has some issues. In the dataSource it appears as date, showing it has Minute, Second, etc, but if I try to refer to these subfields it gives me errors. I attached two pictures, one with the error shown if I just make a preview of the two data calculated, the other showing the Calculated Field (note that for the second one I'm simply collecting the Millisecond field).

Could you please help me with this, maybe with an example? thank you in advance!

Keep in mind that I would prefer to resolve it within Telerik, without the need to use outside code/calculations.

Converters

DataSources

Graph

answered on 13 Sep 2022

0 answers

153 views

Template Build Failed - When Creating Template

When I attempt to follow the instructions to create a Report Template, the wizard returns [Template Build Failure] message, How can I determine what is the cause of this failure?

Report Designer (standalone)

asked on 12 Sep 2022

0 answers

185 views

winforms reporting - bind datatable

I will send the data table to the local report file and print it out in the form of a table.
I tried to send only Parameters using UriReportSource, but I don't know how to send dataTable.
And I don't know how to show it in the form of a table in the trdp file.
You must send data to a report file in a specific folder and print it out, not through the server.

Report Viewer - WinForms

asked on 12 Sep 2022

1 answer

164 views

Set starting Label position?

I found some postings about this, but they're all more than 10 years old. I'm hoping something has been added to address this since then.

On a label report, how can I tell the report to skip the first N labels so I start at a certain row and column?

Surely a hack to insert null rows at the top of the result set isn't the only option? Is there some event I can use or anything to cause the engine to skip labels until I say continue?

Thank you!

.NET Framework

Conditional Formatting

answered on 12 Sep 2022