I am working on a report in the .NET Report Designer that takes time parameters.  I am looking for a way to replace the DatePicker that is used in the Report Designer parameters section with the DateTimePicker, but I've been told by support that there is no way to do that.

At a minimum, I need a way to specify which picker (Date, Time or DateTime) that the Designer should use.  Being able to specify a format would be helpful also.  Ideally the stand alone designer would provide a way to customize and view a custom template that is developed for the HTML5 Report Viewer.

I'm stilling trying to figure out what I have to do, but it appears every time a modify the report I'm not going to be able to view it in the Designer and instead I'm going to have to view it in the Report Viewer in the main application, which will be a much slower and more cumbersome process.

I understand that the ReportViewer has a very different paradigm from, say, the RadGridView.  However, I believe they should and could be much more similar.  With some fairly minor tweaks ReportViewer could be made to be a proper member of the C#/XAML/MVVM environment.  Particularly what is needed is a binding to the data source, just like RadGridView's "ItemsSource".

I've begun a discussion in the forum about this topic at https://www.telerik.com/forums/reporting-and-mvvm.  With Momchil's help I was able to create a workable solution for my scenario, but it required code that, in my opinion, I shouldn't have to write.

I'd be more that willing to chat about this further and provide more thoughts and details, but since we've made it all the way to 2024 without this being raised, I tend to assume the needs I've expressed may not be as universal as I'd assumed they would be.

Thanks!

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. 

{
"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.

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

Using the November 2023 Report Designer, when a resize a Panel and then press Ctrl-Z to undo the resize, all objects within the Panel are lost.

I was able to confirm this by saving as a second copy and then comparing the XML between them.

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:

• Being able to specify the max concurrent connections in the designer
• Make the usage of the DataSource more efficient by only loading the data once (like in the report viewer)
• Being able to turn off the chart preview in the Designer (By configuration, not with a user settable option)

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

Hello

I have a problem with report generating. We use HTML5 report viewer and basic implementation of ReportsControllerBase on server.
I've noticed that we have the CPU/memory recourse consumption after immediately pressing Stop Rendering button. The time of consumption recourses is the same as time without cancelling(about 18-20 second in my example)
There is log with calls of report generating. Last one with cancelling, previous without. 
(see
*** ReportProcessor.ProcessReport DONE in 00:00:16.1918150 ***
and
*** ReportProcessor.ProcessReport DONE in 00:00:16.8522950 ***)

I've investigated how cancelation is working.
The Stop Rendering button send DELETE request to ReportsControllerBase.DeleteReport endpoint. It does something and set IsDeleted flag for document.
Then DocumentCancellationController.ThrowIfCancellationRequested() is called in some specific places in app. You can see that method in log.txt, so it was called after pushing the button.

I've profiled the hot path of generation of report. See hotpath.png.
The most CPU intensive work happens in ReportProcessor.ProcessRepourtSource()...
Pay attention to rendering calls.png - the first red dot here - ReportProcessor.ProcessRepourtSource() call.
The second - where the exception and actual cancelation happens.
I'm expecting it should happen much earlier and cancellation of generation of document(and resources consumption) will finish ASAP.

By the way, I see some cancelation checks in ReportProcessor.ProcessRepourtSource() as well - see throwIfCancellation.png
But cancelation request came after these check and most intensive CPU works already started.


Is it possible to fix that?

I display the WPF Report Viewer control in a closable tab. To free the resources I invoke DisposeViewerResources on tab close as described here: https://docs.telerik.com/reporting/embedding-reports/display-reports-in-applications/wpf-application/disposing-the-report-viewer-resources

However, I see the following dialog every time. There is no way to capture this error or suppress the dialog.

I am currently investigating including the Telerik Reports in our products but when I load the Web Report Designer it loads a theme which is overwriting our custom theme. 

Is there any way to prevent this so that we keep our custom theme?

Hi,

It would be necessary to have a way to export a sub-report to a trdx file with the designer. Also, the same tool could be used to import a sub-report into an XML source. Currently, it takes a lot of acrobatics to be able to do this work.

Thank you for your help!

Please add DropDownTree and/or TreeView as single- and multi-value parameter editors to accommodate Hierarchical data. It would be nice to have them out-of-the-box when available values come from a hierarchical/self-referencing table(s), but I would be happy if they could be integrated as Custom Parameter Editors. I was able to render and populate the dropdowntree with checkboxes, pass the correct selected values, but the 'Preview' button would never enable upon selection. Also, the dropdowntree's AutoClose(false) was not recognized. I know this can be achieved outside of the report viewer, but sometimes that method disrupts the layout and flow of the reporting view.

I am using the stand alone report designer, connected to a report server.
In the report I am designing, I have several cross tabs. We now want to create the same crosstabs, with additional filtering for the data.

- I copy the existing crosstab, then paste it.

Both cross tabs now reference the SAME row groups. Because of this, when I edit the filters, it just doesn't work. Looks like there are reference issues when the copy / paste is done, not all the objects within the cross tab are getting a new copy.

Original crosstab - it has a row group called "groupName1" :

Copied crosstab - same "groupName1" row group - it shouldn't be the same row group object.

I would like to be able to access the report template layout using the ref so that I can save the report template outside of the designer.  Similar to this:

<button type="button"class="btn btn-light btn-sm" @onclick="Save">Save</button>
<WebReportDesigner @ref="designer1"
                   DesignerId="wrd1"
                   ServiceUrl="/api/reportdesigner"
                   Report="Dashboard.trdp"
                   ToolboxArea="new ToolboxAreaOptions() { Layout = ToolboxAreaLayout.Grid }"
                   PropertiesArea="new PropertiesAreaOptions() { Layout = PropertiesAreaLayout.Categorized }" />

@code {
    WebReportDesigner designer1;
 

    void Test()
    {
        var layout = (byte)designer1.Report.Layout;

    }
}
 

Hello

I have problem with visual studio auto close when I'm working in reporting designer.

When I'm working in reporting designer and do about 5 changes, Visual studio freezes and after few monents is restarted and I loose all my work.

It is really frequented problem and I can hardly work with reporting designer.

In Windows Event Viewer I everytime find this exception that referes to problem in GetAggregateFunctions().

Application: devenv.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.NullReferenceException

Server stack trace: 
   at Telerik.Reporting.Processing.AggregateFunctionHelper.GetAggregateFunctions(IServiceProvider provider)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.CategoryAdapter.<GetAggregates>d__1b.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.CategoryAdapter.FillAggregates(Category funcCategory, IServiceProvider provider)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.CategoryAdapter.CreateHierarchy(IServiceProvider provider, Boolean isFieldsTreeVisible)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.ExpressionBuilderDialog.LoadCategories(IServiceProvider provider)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
   at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(System.Runtime.Remoting.Messaging.Message, Boolean)
   at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(System.Object, System.Runtime.Remoting.Proxies.MessageData ByRef)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.ExpressionBuilderDialog+LoadCategoriesDelegate.EndInvoke(System.IAsyncResult)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.ExpressionBuilderDialog.OnLoadCategoriesComplete(System.IAsyncResult)
   at System.Runtime.Remoting.Messaging.AsyncResult.SyncProcessMessage(System.Runtime.Remoting.Messaging.IMessage)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessageSink)
   at System.Runtime.Remoting.Proxies.AgileAsyncWorkerItem.DoAsyncCall()
   at System.Runtime.Remoting.Proxies.AgileAsyncWorkerItem.ThreadPoolCallBack(System.Object)
   at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(System.Object)
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
   at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()

Hi Telerik Team,

I am using telerik reporting watermark to put some "design" in our report template for all the pages, but a small image with a size of 50kb as watermark generates additional 200-300MB of memory usage during the rendering of the report.

Please reduce the memory consumption since this behavior limits the number of user that can access the report simultaneously

Thanks