Questions on Reporting Forum

3 answers

689 views

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

364 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

157 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

244 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

788 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.6K+ 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

652 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

640 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

answered on 11 Oct 2019

3 answers

202 views

How to activate toolbox in VS2017

Hello,

I want to edit my report in design modus, but I can't get any items from the toolbox.

All the entries are disabled.

How can I solve this problem?

Best regards

Simon

General Discussions

answered on 11 Oct 2019

1 answer

1.2K+ views

Table columns - fit content and page width

Hi,

We have a table with static column widths for all columns but one. We calculate the width for the Description column so that the table width is 100% of the containing page. We are using the following binding for the Description column:

Width =WidthForDescriptionColumn(Fields.BillableSection)

where WidthForDescriptionColumn simply subtracts predefined column widths from the page width based on their visibility.

One of our customers complained that they use large numbers (like 8 digits + 2 decimal) and they get wrapped in the column. We decided to implement dynamic column widths for some columns using an approach mentioned at https://www.telerik.com/forums/auto-size-for-textbox#6rdYCe6DPUygy_EmqRM5sg . It did work, however since WidthForDescriptionColumn still returned a static value, the rightmost column got pushed beyond page edge.

The question is, is there a simpler way of achieving the following scenario:

1. Some table columns should have static width.

2. Some table columns should have dynamic width based on its content (actually something like min-width).

3. One of table columns should have dynamic width which is calculated so that the table width would be 100% of the containing page.

Thanks.

General Discussions

answered on 11 Oct 2019