Hello
I see a design issue using JsonDataSource and possible nested objects/arrays and providing data in runtime.
Setting up a "root" JsonDataSource is no problem. Also the way setting the json trough parameters.
The issue begins when I want to use a nested array AND the root object.
Example Json{
"InvoiceDate" : "2024-01-01",
"InvoiceNo":"IN2024-001",
"Positions" : [
{
"Product":"Product 1",
"Price" : 5.25
},
{
"Product":"Product 2",
"Price" : 10.5
}
]
}
The approach using JsonPath for accessing the "Positions" is ok but I have to set up another JsonDataSource with the same json and so that I can access the nested array.
And now I don't now how to set the Source of the second JsonDataSource in runtime. Setting it using parameters is only possible with one DataSource.
A nice approach would be binding the Source of the second JsonDataSource to the first JsonDataSource with a JsonPath. So we could avoid duplication of data.
Or let us bind to a nested object in a table.
My scenario is that I am exporting a report to Excel, and I need to format one of my columns that display numerical data with a specific culture.
I can achieve this with the FormatWithCulture text function but then Excel does not treat the values in that column as numbers which is why I have to use the Format property of the item, and return a number in the Value of the textbox.
Unfortunately, the Format property does not allow specifying a culture that will be used for the formatting so the culture on the server is always used. I need to change that dynamically with a report parameter.
I would like to request an option on bar charts or column chart where the bars can be separated or pushed apart. The default in Telerik is to place all bar series next to each other, which is visually terrible. Attached is a sample image below.
I simple spacing option would be great!
My PostgreSQL query contains an Integer parameter. In the Standalone Designer, it executes successfully both in design and in preview.
In the Web Designer, the same report is also previewed successfully. When I try to configure the SqlDataSource though, if I run the Execute Query in the final step, the database returns an error stating '...operator does not exist: integer = text...'
If the parameter is String, the query runs fine in design time of the Web Designer as well.
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)
When the input data of a pie chart is such that some of the series are insignificant enough not to be drawn on the surface area, a DocumentRenderException with the message "The operation was canceled" is thrown by the Reporting engine.
Enlarging the pie chart or hiding/removing its data point labels clears the error.
The Preview button of the HTML5 Report Viewer is not styled appropriately when using Kendo SASS themes:
HTML5 Report Viewer installation resources contain an old version of the Kendo blueopal theme - C:\Program Files (x86)\Progress\Telerik Reporting 2024 Q1\Html5\ReportViewer\styles.
Please update the kendo stylesheets to the Kendo version the report viewer currently uses.
Hi Team,
I would like to put in a request for PPT export option for Telerik reports. Our end users want the ppt file to be editable. One of your team members suggested that there is an existing ppt export format, but it is not editable at the moment. Having an editable option is preferable.
Thanks
Samyutha Ravindran
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:
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 would like to have truly bitwise operators for my expressions. Here is my scenario.
I have a bitwise flag in my dataset which defines the status of a value. It can have up to 15 possible values set as true in one field. The issue is, that there doesn't appear to be any way that I can perform a check in my expression.
I don't want to add 15 additional columns to my dataset that explicitly set these as true as that's total overkill.
The Logical/Bitwise operators article details that there are "bitwise" operators, but these are logic only. This forum post confirms this.
Hi Team,
I would like to request that the rotate CSS attribute be added to the HtmlTextBox.
Thank you!
Hello,
We would like to know if/and when Query Designer will be implemented in web report designer?