Currently, the MsSqlServerStorage CommandTimeout is with the default value that is 30 s. In some scenarios, like when the Search functionality is enabled and the report is very big, the generated ClientSearchItemsResource may be too big, and when attempting to save it in the storage the latter may throw the exception 'System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.'
The error may be avoided if the CommandTimeout can be increased.
Currently, you may aggregate values from a certain scope for a particular page with the Page function PageExec. It would be great to be able to display also the carryover aggregates up to the current page.
For example:Page 1: Page1 Sum = 10; Total Sum at the end of the page1 = 10
The property DataSources is internal in the Report class. When manipulating the datasources of a report it's easier to have access to this collection than to go through all the elements en report parameters to check for datasources
In the secure and session based environment, it may take a while to design a report. Meanwhile, the session may expire. Or even anything could happen e.g. internet loss, power loss. In that case, all of the designs that the user has made after spending a lot of hard work and time; are lost.
There should be an auto-save feature in Report Web Designer. It would be great if this is API based. e.g. AutoSave(true/false), AutoSaveInterval(seconds), etc.
Sometime the design of the report is too complex (the graphic design) and using a table for suppressing repeating values is not possible.
It would be really nice to have the Suppress if duplicated property in the textboxes so as to be able to use it in the detail band, also it should repeat it only on the first detail of a new page.
For conditional sorting I use a formula like this:
=IIF(Parameters.SortBy.Value = 1, Fields.id, IIF(Parameters.SortBy.Value = 2, Fields.name, Fields.value))
This works perfect.
Now I would like to do the same with the sortings direction! Something like:
=IIF(Parameters.SortOrder.Value = NULL, ASC, IIF(Parameters.SortOrder.Value >= 0, ASC, DESC))
Sadly, the Direction-Field/Dropdown does not support formulas.
Hi Telerik Team,
We are having report parameters up to 30. For better UX we need to group parameters into sections. Please add this feature.
Attached is an example of what we want to achieve.