I noticed that using the Standalone Report Designer for .NET, I can't open the "ReportSource" dialog for a SubReport. The property cannot be edited from the Properties tab either.
Instead, when using the Standalone Report Designer for .NET Framework everything works fine.
When developing a Telerik report template with the intention of exporting to Excel, I observed the % sign was not displaying for positive numbers in the exported Excel file. The format we were using was {0:N2}%. The results displayed on the HTML report viewer and the Word export document was correct:
However in the excel file result, the cells were formatted without the % for positive numbers, and with the % for negative numbers.
Upon further inspection, I noticed the excel cell formatting was translated as:
This format would not generate the % symbol for a positive number as the trailing % is missing before the semi-colon.
We are fixing this by using the below Format specification directly in the Report Designer:
{0:#,##0.00"%";-#,##0.00"%"}
which is directly retained in the excel custom format:
While I understand that N, C etc. C# number formats are supported according to the design considerations and this bug is also technically resolved by using UseExtendedFormatting (setting this to false translates {0:N2} to #,##0.00"%"), this seems like an unexpected result of translating the format codes that does not match the standard behavior of {0:N2}%. Reporting this behavior for review.
What's the long-term plan for supporting Linux and Telerik Reporting? The dotnet design team is looking to remove support for System.Drawing.Common on Linux platforms. They're recommending compiler warnings in .Net 6, and full PlatformNotSupportedExceptions in .Net7
Sources:
designs/system-drawing-win-only.md at main ยท dotnet/designs (github.com)
Breaking change: System.Drawing.Common only supported on Windows - .NET | Microsoft Docs
I have designed a report that includes an embedded SubReport. When I render it to PDF, it looks correct. When I render it to CSV, there are two issues that are probably related:
I understand that CSV Rendering is not recommend for hierarchical output as described in the CSV Design Considerations. However, I am using the Hide the SubReport if no Values to not display the SubReport when there is not data. The hidden SubReport implementation can be seen in the below binding expression.
<Bindings>
<Binding Expression="=Count(Fields.AP_OPN_CHK_VCH_NO_C)>0" Path="Parent.Parent.Parent.Visible"/>
</Bindings>
Using the above approach, the master report is missing a CRLF when the detail data is not visible. The record shows it appended to the previous record.
I started working with Support on this issue and have discovered that it might be a bug. As a result, I am also attaching their sample to help replicate the issue. For the pdf and csv output see the first attachment in the original ticket.
The JS file with the stringResources shipped with the installation at the following location:
C:\Program Files (x86)\Progress\Telerik Reporting <Release>\Html5\ReportViewer\js
is incorrect, it should be as shown in the Localization - Telerik Reporting article.
Basically, line 9 should be changed to:
; (function (trv, $) {
while lines 178 to 180 should be like this:
trv.sr = $.extend(trv.sr, sr);
}(window.telerikReportViewer = window.telerikReportViewer || {}, jQuery));
When HTML entities are used in an embedded expression of the HtmlTextBox, they are parsed.
The same does not happen when the "= ..." expression syntax is used.
For example:
This expression works.
= Replace(Fields.Column2, 'less than','<')
This one throws an error.
{Replace(Fields.Column2, 'less than','<')}
Here is a snippet from the file '/@progress/telerik-angular-report-viewer/dist/es/telerik-report-viewer.component.js' in Telerik Reporting NPM repository of the Angular Viewer that hard-codes the message:
TelerikReportViewerComponent.decorators = [
{ type: Component, args: [{
selector: 'tr-viewer',
template: '<div [ngStyle]="containerStyle" [attr.id]="reportViewerID" #container>Loading Report Viewer...</div>',
styleUrls: [],
encapsulation: ViewEncapsulation.None,
},] },
];
Currently, there is no easy way for localizing or removing this message in an Angular-wise approach.
The DocumentMapVisible/ParametersAreaVisible settings that I set in the initialization of the native Blazor Report Viewer are not respected.
I can hide/show these areas from the buttons in the report viewer's toolbar but am unable to have them hidden initially.
Currently, the only workaround is to have a JS function that clicks on the toolbar after initialization:
function reportViewerMapClick() {
$(".k-i-dictionary-add").click();
}
After reviewing other users questions/issue it appears this hasn't been addressed.
When creating a TABLE group (not a group header/footer) the TABLE group header has no option of displaying on each page when the group spans multiple pages. The advice to make ColumnHeaders = True doesn't help because when you add a group header that row is inserted below the table's header row and thus this doesn't apply to the group header row.
I'd like to suggust a setting in the table group properties menu to display the header on each page, ideally with an option to display a suffix such as "cont."
Item("MyProperty",Fields.MyDictionary)
Fields("MyProperty")
Currently, I am using XmlSerializer to deserialize .trdx file, and it returns Telerik.Reporting.Report type object.
Since, for a long time, I need to add my own functions to be available in the report's expressions, and this need becomes larger and larger, it would be great if I could use the Telerik.Reporting.XmlSerialization.ReportXmlSerializer class to deserialize the .trdx file in my derived class.
For example:
var report = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer().Deserialize<MyReportDerivedClass>(TemplateStream);
Currently, if the SkipBlankPages property is set to True and there is not any significant content in the report, the following message will be displayed in the designer and the viewer: The current data set presented in the report did not produce any significant content, so no pages were generated. If you need to see the whole report content, including blank pages, please contact the report author.
I am trying to add HtmlTextBox to my report. After double-clicking on the HtmlTextBox, instead of opening the HTML editor, an error message appears
And after that, it is not possible to delete any element of the report
We need our reports to have editable text fields where data can be entered into the pdf document and printed.
See also the Forum thread export pdf with editable text areas.
Enable retaining editable textboxes when Exporting to PDF.
For example a PDF Re-order form with editable textboxes for order Quantity so the user can enter order Quantities.
When the EnableAccessibility PDF device info setting is set to true in the RuntimeSettings of a report, the text set to an item in the AccessibleDescription report item property is not respected.
For example, a PictureBox with AccessibleDescription set to "Text1" will have the "Picture Box" alternate text set in the exported PDF instead of "the Text1" string.
Recursive sub-report with hierarchical data. When expanding/collapsing, all nodes get expanded or collapsed.
I would expect only the selected node to be expanded/collapsed.
For reference, the report from the How to represent hierarchical nested data in report recursively - Telerik Reporting KB article was used as a base
Using a Toggle Visibility action to expand/collapse recursive SubReport results in the "Node should be found among parent nodes" error. The recursive SubReport renders fine without the action.
The report from the How to represent hierarchical flat data in report recursively - Telerik Reporting KB article was used as a base.