Questions on Reporting Forum

0 answers

100 views

Telerik Reporting vs. Telerik Angular grid with export buttons

What are some strong arguments for using Telerik Reporting over just using the Telerik Grid + PDF/Excel export ? I am trying out both but it seems if the reporting is simple then I can just bind the data to a telerik grid ?

Report Viewer - Angular

asked on 04 Oct 2022

0 answers

124 views

Possible to ignore case for JSON formatted web service data source results?

Is it possible to ignore case for JSON formatted web service data source results? So = Fields.Job_Title would pick up "job_Title": "General Labour"

DataSource JSON

DataSources

asked on 30 Sep 2022

1 answer

214 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

119 views

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

122 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

505 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.2K+ 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

361 views

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

157 views

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

969 views

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