Questions on Reporting Forum

1 answer

346 views

Can you post the steps to achieve localization for reports using Standalone Designer?

I have designed report template using standalone designer report(trdp extension).

I consumed that report template in my application and pass data to that report template to deliver complete report.

Everything works fine , but now i need to achieve localisation for those standalone report .

Please tell me the steps how I can add localisation for the culture "zh-HK" in the standalone report.

General Discussions

answered on 17 Oct 2019

3 answers

745 views

Report Totals/Sum with Nested Tables

I have a nested table in a textbox of a table and I am having trouble getting the summary of all the records in the nested table.

I can get the summary of each group in the nested table. However, I cannot get the summary for all the records together.

I have posted the data structure with sample data below.

The data source of the parent table is "= ReportItem.DataObject.TicketReportsDC"
I have added a row "Outside Group - Below" and I have tried "=Sum(Fields.TicketDataContract.TicketJob.TicketDetails.OrderAmount)". This gives me an error :'OrderAmount' is not defined in the current context.

The data source of the nested table is "= ReportItem.DataObject.TicketDataContract.TicketJob.TicketDetails"
I have added a row "Outside Group - Below" and put "=Sum(Fields.OrderAmount)" in the appropriate textbox. This gives me the Summary for the individual ticket. ($1650.00, $1200.00, and $625.00 for the below sample data)

I have tried other possibilities and am not haveing any luck getting this. I believe it is due to the fact that the "TicketDetails" is a list within a list (TicketReportsDC) in the Data Structure.

Can anyone give me any ideas for referencing the "OrderAmount" at the top level? With the sample data below I would expect a total of $3475.00.

Thanks

James

-----------------Data Structure with Data ------------------
{
"TicketReportsDC": [
    {
      "TicketID": 1212
      "TicketDataContract": {
        "TicketJob": {
          "TicketDetails": [
            {
              "Item#": 123
              "Quantity": 3
              "OrderAmount": 1500
            }
            {
              "Item#": 124
              "Quantity": 1
              "OrderAmount": 100
            }
            {
              "Item#": 125
              "Quantity": 2
              "OrderAmount": 50
            }
          ]
      }
      }
    }
    {
      "TicketID": 1240
      "TicketDataContract": {
        "TicketJob": {
          "TicketDetails": [
            {
              "Item#": 123
              "Quantity": 2
              "OrderAmount": 1000
            }
            {
              "Item#": 124
              "Quantity": 2
              "OrderAmount": 200
            }
          ]
      }
      }
    }
    {
      "TicketID": 1245
      "TicketDataContract": {
        "TicketJob": {
          "TicketDetails": [
            {
              "Item#": 123
              "Quantity": 1
              "OrderAmount": 500
            }
            {
              "Item#": 124
              "Quantity": 1
              "OrderAmount": 100
            }
            {
              "Item#": 125
              "Quantity": 1
              "OrderAmount": 25
            }
          ]
        }
      }
    }
]
}

General Discussions

answered on 17 Oct 2019

1 answer

401 views

Can't import report library into standalone designer

Whatever I try, the standalone Report Designer always displays "No reports available" in the "Select Reports to Import" dialog.

I tried to keep it as simple as possible:

Create a new project in Visual Studio (Telerik Report Library)
Add a blank report
Add a couple of TextBoxes
Visual Studio report preview looks fine
Try to import DLL in Standalone Designer
"No reports available"

Screenshots attached

Report Designer (standalone)

answered on 15 Oct 2019

1 answer

186 views

How to get time interval value from report data in group

hi,

I would like to display the datetime interval value from data field.
I am using the standalone report designer and my report has chart and summary data by group. I have tried out the aggregate function but my function will display the interval for inner group only. Kindly help to advise how to get this?

The report data structure would be like the following
Name,QtyName,DateTime
DV10002,Current Phase B,2016-09-05 00:15:00
DV10002,Current Phase B,2016-09-05 00:30:00
DV10002,Current Phase B,2016-09-05 00:45:00
DV10002,Current Phase B,2016-09-05 01:00:00
DV10003,Current Phase B,2016-09-05 01:00:00
DV10003,Current Phase B,2016-09-05 01:30:00
DV10003,Current Phase A,2016-09-05 01:00:00
DV10003,Current Phase A,2016-09-05 01:30:00

e.g DV10002
Current Phase B
Interval : 15 mins
DV10002 Summary

DV10003
Current Phase B
Current Phase A
Interval : 30 mins
DV10003 Summary

I have also attached the sample report.
Thank you

Report Designer (standalone)

answered on 14 Oct 2019

3 answers

269 views

MVC Reports not loading

We recently experienced an issue with R3 2019 (13.2.19.918) where a user would go to our report screen and the report wouldn't load. That user was then unable to navigate or use any other part of our web application without closing their browser. We were unable to reproduce the issue, and it happened intermittently in production. I noticed in the release notes of today's internal build (R3 2019 SP1 13.2.19.1004), that an issue has been fixed with WebAPI and the note says "Service stops responding in specific cases". We want to know if this is the issue we were experiencing before deploying this version.

General Discussions

answered on 14 Oct 2019

2 answers

859 views

HTML 5 Reporting not working in .Net Core 3.0

Error:

Method not found: 'Void System.Threading.Semaphore..ctor(Int32, Int32, System.String, Boolean ByRef, System.Security.AccessControl.SemaphoreSecurity)'.

Version:

.Net Core 3.0

Telerik Reporting R3 2019

Note:

The constructor Threading.Semaphore..ctor(Int32, Int32, System.String, Boolean ByRef, System.Security.AccessControl.SemaphoreSecurity) only available in .Net Framework 4.8

Nuget Packages:

Assembly References:

Telerik.Reporting.dll

Telerik.Reporting.Service.dll

Telerik.Reporting.Services.AspNetCore.dll

General Discussions

answered on 14 Oct 2019

4 answers

1.7K+ views

Set The Size of TextBox Dynamically in Telerik Report

Hi,

Is there any way to set the size of a textbox dynamically based on length of its text in Telerik Reports?

Thanks.

General Discussions

answered on 14 Oct 2019

1 answer

685 views

Report not showing Font

I am using Telerik reporting to produce price labels for products within our stores.

I have a VB project which produces the labels when a feed is recieved from our central servers. The XML input contains pricing and various other characteristics which then populate various fields on the label.

I need this to be rendered in Helvetica, and then the report gets pushed to a label printer. The label printing software runs on approximately 160 Win 7 machines and runs under the Local System user.

I have installed Helvetica.ttf on our UAT machine, and whilst printing from Dev on my own machine renders the Helvetica font perfectly, I cannot get it to work on the UAT machine.

app.config

<?xml version="1.0" encoding="utf-8"?>

<configuration>

<configSections>

<section name="Telerik.Reporting" type=

"Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting, Version=12.2.18.1129, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"

allowLocation="true" allowDefinition="Everywhere" />

</configSections>

<Telerik.Reporting>

<privateFonts>

<add fontFamily="Helvetica" path="C:/Windows/Fonts/Helvetica.ttf" />

</privateFonts>

</Telerik.Reporting>

label.vb

Public Sub New()

Dim Functions As New GenericFunctions

Dim ExceptionFunctions As New ExceptionFunctions

Dim EXC As New CollatedException

Try

InitializeComponent()

Dim dblXOffset As Double = CDbl(PrinterVariables.LabelPrinterSettings.Xoffset)

Dim dblYOffset As Double = CDbl(PrinterVariables.LabelPrinterSettings.Yoffset)

Dim xOffset As New Unit

Dim yOffset As New Unit

Me.Style.Font.Name = "Helvetica"

xOffset = Unit.Mm(dblXOffset)

yOffset = Unit.Mm(dblYOffset)

General Discussions

answered on 11 Oct 2019

1 answer

685 views

Error running in a .Net Core class library

Hello,

I'm trying to get the ReportProcessor to work in a .Net Core class library (running as an Azure function) and attempting to load in a .trdp file (soon, it'll be multiple .trdp files) as the report source. Upon hitting the endpoint, it almost immediately crashes with:

Telerik.Reporting: The type initializer for 'Telerik.Reporting.Processing.Common.FontContainer' threw an exception. System.Drawing.Common: System.Drawing is not supported on this platform.

I've tried installing the windows compatibility pack and system.drawing.common in futile attempts to get this working, but have not yet been able to. Is this a limitation of Telerik reporting?

General Discussions