Questions on Reporting Forum

1 answer

261 views

Can someone share an example of user functions in blazor

Hi,

I desperately need some guidance. I have a trdx that is working perfectly. However, we are porting over to use Azure.

I need to be able to set a picturebox's image at runtime. I used to do this via itemdatabinding event, but I believe that has been deprecated in favor of user functions. If I have a PictureBox on my report and I want to set the value to an Image (not a path), what code do I need to do this? How do I get access to PictureBox1 so I can set it's value?

Any guidance would be great as I am dead in the water.

Thanks ... Ed

PictureBox

Report Designer (standalone)

Report Parameters

Report Viewer - Blazor

answered on 28 Sep 2022

2 answers

148 views

[Solved] Reverse order of X Axis When Using DateTime Scale?

Created a line graph in stand-alone designer that is working great. It uses the DateTime scale on the x-axis to display mmm.yy. The axis is sorting/displaying in chronological order. All of the data being displayed is correct, so it appears to be setup correctly. Is there a way to reverse the sort order to display reverse chronological order on the X-axis?

I am new here and have attempted many different ideas

Found the 'Reversed' setting in Coordinate Systems->Xaxis->Scale, but that setting moves the Y axis from the left to the right side of the chart producing a reverse image. I am just trying to sort the X-Axis, without moving the Y-Axis. So close here.

Have tried descending sorting on the field that is feeding the X axis via DateTime scale. The correct data is displaying which tells me the DateTime scale is working. Changing the sorting does not affect the order displayed on the chart though.

Have been changing many settings and reviewing other threads. In general, when using the DateTime scale on an X-Axis, is there a way to reverse the sort order to make it reverse chronological order?

Thank You,

John

Graph

Report Designer (standalone)

Sorting

answered on 26 Sep 2022

0 answers

162 views

Document map Not applied on server

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

575 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

453 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

185 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

455 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

140 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