Currently the Webdesigner makes up to 6(?) and the Standalone Designer as much as it needs without(?) limit.
Especially the latter case can quickly lead to a lot of connections, saturating the max allowed connections of a sql server, which also leads to other services depending on a sql server connection to fail.
As far as I've seen, this only happens with Charts in Design mode.
So there are multiple ways to handle this:
See the attached report for a simple example:
It contains a single Datasource, which is a postgres query which simply waits 10s before returning the result.
After updating the DataSource to something which works for you and saving, simply reopen the report and see how many connections are opened in parallel.
With kind regards
Dominik Rothert
The Preview button of the HTML5 Report Viewer is not styled appropriately when using Kendo SASS themes:
It would be great if the expressions were validated before leaving the expression editor rather than only finding out I missed a bracket ')' when running the report.
The Upgrade Wizard for Visual Studio backs up all files, including those in the '.vs' folder. In Visual Studio 2017 this may cause errors when upgrading due to the locked file 'db.lock':
System.IO.IOException: The process cannot access the file 'C:\Users\reportingagentuser\Desktop\reportlibrary1\ReportLibrary1\.vs\ReportLibrary1\v15\Server\sqlite3\db.lock' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost)
at System.IO.File.Copy(String sourceFileName, String destFileName, Boolean overwrite)
at Telerik.Reporting.UpgradeWizard.Engine.Services.BackupService.BackupDirectory(String directoryName)
at Telerik.Reporting.UpgradeWizard.Engine.Services.BackupService.BackupDirectory(String directoryName)
at Telerik.Reporting.UpgradeWizard.Engine.Services.BackupService.BackupDirectory(String directoryName)
at Telerik.Reporting.UpgradeWizard.Engine.Services.BackupService.BackupDirectory(String directoryName)
at Telerik.Reporting.UpgradeWizard.Engine.Services.BackupService.BackupDirectory(String directoryName)
at Telerik.Reporting.UpgradeWizard.Engine.Services.BackupService.BackupDirectory(String directoryName)
at Telerik.Reporting.UpgradeWizard.Engine.ProjectItem.BackupInternal()
at Telerik.Reporting.UpgradeWizard.Engine.UpgradeItem.Backup()</event>
To preview/export localized reports in different languages, I change the thread's current culture in the report viewer's ExportBegin/RenderingBegin events and reset it back to the original culture in the ExportEnd/RenderingEnd events.
This approach works well in .NET Framework projects but in .NET Core projects, the culture is not reset properly.
Changing the culture in the events of the desktop report viewers should work both in .NET Framework and .NET Core projects.
I have denied the permission to use the Asset Manager in the configuration of the service of the Web Report Designer. This is generally respected and I do not see the option to open the asset manager from the main menu but when I try to set an image to a PictureBox item, I still see the option to add it from the assets and the button is also clickable.
With that being said, the permission is respected on the server and I get an error about not having permission to use the Asset Manager when I click on the button. Still, it will be better if the button is removed from the UI altogether when I have disabled the assets.
Adding the "Telerik.ReportViewer.WinUI.Themes/Themes/Generic.xaml" theme to a WinUI project causes existing AppBarButtons to grow in size because it overrides the AppBarButtonContentHeight setting.
The report viewer theme should not override the styles of the default WinUI controls.
The WebServiceDataSource wizard in the Web Designer doesn't let you construct Expressions for the Parameter values. The same functionality is present in the Standalone Report Designer.
The SqlDataSource Wizard of the Web Designer also allows the creation of Expressions for the Parameter values.
It would be convenient if the report creators were allowed to create the Expressions for WebServiceDataSource parameter values directly in the wizard. Currently, you need to type or paste the Expression manually.
The HTML5-based report viewers use the following navigation icons.
This is unintuitive and inconsistent with the desktop and native report viewers.
The navigation icons should instead be:
When testing integer values outside the range of System.Int32 (-2147483648 to 2147483647) for a multi-value integer parameter, I started to get the error:
An error has occurred while processing Report '___': Cannot perform '=' operation on System.Int32 and System.Int64.
I narrowed this down to the "In" and "Between" operators. For example, the expression evaluating a literal integer value against the multi-value parameter:
= 0 In Parameters.IntegerMultiVal.Value
It appears that the literal integer is being converted, internally, to Int32 and compared against the contents of the multi-value parameter as Int64 - though the error only occurs when a value outside the Int32 range is present.
Direct comparison to a single parameter value outside the Int32 range appears to work fine:= Parameters.IntegerSingleVal.Value = 0
= Parameters.ZeroVal.Value In Parameters.IntegerMultiVal.Value
This was tested and reproduced in the HTML5 report viewer and the standalone report editor.
Clicking on the Value property of a Report Parameter from the Report Explorer in the .NET Standalone Report Designer throws the following error:
The issue is not present in the Standalone Report Designer for .NET Framework.
The WPF Report Viewer should support rounded corners.
Currently, I am not allowed to do the following:
<telerikReport:ReportViewer Grid.Row="1"
Grid.Column="1"
Name="reportViewer1"
ReportSource="{Binding ReportSource}">
<telerikReport:ReportViewer.Resources>
<Style TargetType="telerikReport:ReportViewer" BasedOn="{StaticResource {x:Type telerikReport:ReportViewer}}">
<Setter Property="BorderBrush" Value="{telerik:Windows11Resource ResourceKey=PrimaryBorderBrush}"/>
<Setter Property="BorderThickness" Value="1"/>
<Setter Property="Margin" Value="5"/>
<Setter Property="CornerRadius" Value="4"/>
</Style>
</telerikReport:ReportViewer.Resources>
</telerikReport:ReportViewer>
The getReportParameters method of the HTML5 Report Viewer omits parameters with unset values that have their AllowNull property set to False.
The reportSource method of the HTML5 Report Viewer can be used as an alternative.
Since version 21.24.305 of the Native Angular Report Viewer, its DateTime parameter editors do not work if the user's machine does not use the en-US culture.
The following error message is displayed in the browser console when a DateTime parameter is present.
Error: The 'value' should be a valid JavaScript Date instance.
at DateInput2.verifyValue (dateinput.js:1057:19)
at DateInput2.writeValue (dateinput.js:1051:14)
at DateInputComponent.ngOnChanges (progress-kendo-angular-dateinputs.mjs:10036:22)
at DateInputComponent.rememberChangeHistoryAndInvokeOnChangesHook (core.mjs:4101:14)
at callHookInternal (core.mjs:5136:14)
at callHook (core.mjs:5167:9)
at callHooks (core.mjs:5118:17)
at executeCheckHooks (core.mjs:5049:5)
at selectIndexInternal (core.mjs:11023:17)
at ɵɵadvance (core.mjs:11012:5)
The following screenshot demonstrates what the ToC looks like when rendered with Skia on Linux.
Below is the expected result. Rendered with GDI on Windows.
The Uri user function can be selected from the functions list in the expression editor of the designer but when the report is previewed the following error message is shown.
The expression contains undefined function call Uri()
When I drag a data field from a DataSource component to the Report details section in the Standalone Report Designer, the Report > DataSource property is set automatically to the corresponding DataSource component.
In the Web Report Designer, when I drag a data field, the Report > DataSource property remains empty, and the Preview shows an empty report. It would be very helpful the same functionality to be introduced also in the Web Designer.
Reports designed in Blazor Web Designer may have multiple shared data sources, only one of which can be used to bind details section data. That I understand.
A use of a secondary data source can be to provide data to which Report Parameters can be bound, such as providing dynamic localized values for any language and/or region. This I expect to do in every report of mine.
Right now, unless I've overlooked some existing mechanism, in each and every report for each field in such a secondary data source I have to manually create a new Report Parameter, bind it to the desired data source, and at least set the ValueMember to that data source field. This can be very time consuming, especially if there are a large number to be created.
It would seem possible for you to add a data source feature such that use of that data source in a report automatically does this for me for each selected field in the Select Query. That would save me a tremendous amount of design time!
Also, if you reply to this, perhaps you could tell me what constitutes a report's "Inline Data Source"? I have been unable to locate any discussion in your documentation nor any means to actually create one if that were useful to me.
I am using the ObjectDataSource component and within my class, I use EF Core and initialize the DbContext with a connection string to pull data.
This works as expected in my application, however, when I try to use the assembly in the .NET Standalone Report Designer, it throws exceptions that one or more of the dependencies of the EF Core package cannot be loaded:
FileLoadException: Could not load file or assembly 'Microsoft.Extensions.Configuration
Steps to reproduce:
1. Add two lists at the same level:
2. Select list1 and click Ctrl+X
3. Select panel2 nested in list2 and press Ctrl+V:
4. Preview the report: