I have a following default code in a html file for a web designer.

$(document).ready(function () {
            $("#webReportDesigner").telerik_WebReportDesigner({
                persistSession: false,
                toolboxArea: {
                    layout: "list"
                },
                serviceUrl: "some url",
                report: "some_report_name",
            }).data("telerik_WebDesigner");
        });

I have also a custom report storage implemented from IDefinitionStorage, where I have a GetDefinition("some_report_name") method implemented in a custom way. In order to do that, I need to send additional parameters from a web designer (html code provided previously) but don't know how to do that. 

For example, I need to open SalesInvoice.trdx file and I do a following: report: "SalesInvoice.trdx". If i need to send additional parameter, let's say some kind of token, there is no good place to send it. As a work around, i am doing report: "SalesInvoice.trdx&token=123". The problem with this, it is appearing in a title of a web designer and I don't want that. In an attachments, there is a screenshot where it looks good with a simple name and the one which has a token in it.

So, the question is, can I send other parameters as well from a client side of web designer to the server like parameters or so?

In a HTML5 ReportViewer we can send report file name and parameters as a reportSource like this:

                    serviceUrl: serviceUrl,
                    reportSource: {
                        report: reportUrl,
                        parameters: reportParams,

Can we do the same? Or how can I do that?

Hello,

We use WebServiceDataSource with OData query in our reports. Sometimes OData can through an exception.

In our case, we have added Web Service DataSource and set this OData query for its Service Url:

https://services.odata.org/V3/Northwind/Northwind.svc/Products(1)?$select=ProductName1

If you see the query, it is selecting "ProductName1" property of "Product #1". But "ProductName1" property does not exist (correct property name is "ProductName"). When we use Postman for the OData query above, it shows an error which you can see from attached picture (ErrorWhenWeUsePostman.PNG, "Could not find a property named 'ProductName1' on type 'NorthwindModel.Product'"). From the second picture (TelerikReportingGeneralError.PNG, "An error has occurred... Response status code does not indicate success: 400 (Bad Request).") you can see the result of our test report (in html5 report viewer) that has the same OData query.

The question is when we preview our report (in html5 report viewer) how can we show the error message that OData sent instead of showing Telerik reporting general error?
Instead of this message:

An error has occurred while processing Report 'TestReportWithWebServiceDataSource': Response status code does not indicate success: 400 (Bad Request).

This OData error message should be handled and shown on browser (html5 report viewer) when previewing report:

Could not find a property named 'ProductName1' on type 'NorthwindModel.Product'

FYI: We are using Telerik Reporting version 15.0.21.224.

This is my post on Telerik forum related with this: How to get internal error message from Custom Report Resolver

Thank you,

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

We are using the external style sheet file (StyleSheet.xml) when designing our report from Web report designer. We want to see our style sheet applied on our report when we see the report from Web designer in design mode. In Preview mode it is working fine.  But the problem here, it is not working in Design mode.

See the attached pictures. You find our problem on the picture ExternalStyleInWebDesigner-DesignMode.PNG

Is there any solution or a feature request needs to be created?

FYI: External style sheet is working in Standalone report designer in both design and preview mode.

 

Thanks,

When a report is open and the user click on the "generate" button, a busy indicator is displayed and the user can continue to use the application during the generation of the report. The UI thread is not blocked.

But when opening a view with the ReportViewer, the UI freezes during the initial connection to the remote engine, until the report is ready to be generated. If the report has parameters requiring a database query to load the available values, it freezes for a few seconds.

Would it be possible to load the ReportViewer instantly, then display a busy indicator until the report is ready, without blocking the UI thread ? (exactly as for the generation of the report)

 

 

 

Hi,

I would like to know if it's possible to reconsider this request, or at least to leave it open for a longer period of time so people can vote. It would be really nice to be able to integrate existing SSRS reports. We have a lot, I really mean a lot, of SSRS reports. We believe using another third party would just make our "ecosystem" more heterogeneous.

I'm pretty sure we're not alone with tons of SSRs reports that are waiting for a seamless integration with Telerik UI for Blazor.

Thanks in advance

Stéphane Roy

 

 

The Angular Report Viewer uses the jQuery npm package, while the Web Report Designer uses jQuery.min.js directly from a CDN. If you try to use both Angular Viewer and JS Web Designer in the same application there will be a conflict while loading jQuery twice from the different sources. This is why the Angular Report Viewer cannot be loaded together with the JS Web Report Designer in the same application. The KB article Displaying the Web Report Designer in Angular application provides a Known Issues section at the bottom where this problem is explained:

"Telerik Web Report Designer could not be integrated into Angular application together with Angular Telerik Report Viewer. That is why this article shows how to use the Telerik Web Report Designer in angular application with jQuery-based HTML5 Telerik Report Viewer."

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

When using multiple Condition Formatting Rules, the only option is the AND. An OR option should also be available.

Currently, the WPF Report Viewer won't work in WinUI because of the differences in the resource dictionary XAML (system.xaml vs Microsoft.ui.xaml). It would be nice if there is a report viewer for WInUI.

If you do a Excel export, it renders the headers value, which we set with an expression (customer specific localised text), but as CSV the header names/IDs are used.
It would be nice to have a 'Export Settings' category on the page properties, see attachment for example. Also shows another useful feature of disabling export option easily per report.

The ObjectDataSource component in the Web Report Designer does not have complete design-time support. The major things that are missing:

• there is no dedicated wizard that helps to discover and select business classes and appropriate data retrieval methods.
• its data schema is not retrieved from the REST service and since it's unavailable, the Edit Expression dialog does not populate its Fields collection.

Telerik,

This is a feature request to allow a designer to set the locale at preview time.

We work on reports that are deployed and executed in many regions and locales around the world.

We cannot have our report designers switch the locale each time they need to test or validate a report, it would become too cumbersome.

Would you be able to add an option (default: Current locale) to the "Preview" screen in the designer that allows the report designer to set the locale to Preview the report as.

Thanks!!

Shawn

One of the main features the clients require when exporting the reports to XLS or XLSX is to have the page width already set to 1 page. But for none of these exporting options, this is possible, unless you intercept somehow the export functionality prior to rendering the document to the client

It would be nice to have 3D chart capabilities such as those found in the WPF ChartView or even the KendoUI charts.  The Telerik Reporting charts , although feature rich, are rather plain looking.

Do you have an updated road-map or plan to support Web assembly (WASM), especially Blazor? You already published Blazor articles in your blogs.

It will be a good idea to add a new report viewer based on Blazor, protecting the parameters between the viewer and its API controller.

Also, will be a very good idea to start your online report designer (like alternative products), based on web assembly

We'd like to distribute the standalone report tool to our clients and provide data through a web service. We don't want to have to redistribute a dll everytime we make new data available.

The standalone report tool should be able to query our webservice for what data is available and then allow the client user to create reports from it.  i.e. obtain list of table names dynamically as well as their column names and data.

A possible solution is to allow the tool to view and interact with classes in an external assembly that are dynamically generated with Reflection.Emit.

Hello, 

 

I can see that we can operate over a file definition using save, open, and save as. It would also be nice to be able to download the report definition as well. 

At the moment it's only possible to have your reports in old-fashioned projects.

It should be possible to add/design reports to SDK-style projects. That should work no matter what target framework is (.NET Core, .NET Standard or .NET Framework).

When using multi-child select statement like the below:

SELECT ORG, C1, C2, ... FROM (
   (SELECT X FROM Y WHERE Z1 = xxx AND Z2 = :param1 AND DATE BETWEEN :param2 AND :param3) C1,
   (SELECT X FROM Y WHERE Z1 = yyy AND Z2 = :param1 AND DATE BETWEEN :param2 AND :param3) C2,
   ...
)
Then binding with report parameter will be like:
param1 = rpt_param1
param2 = rpt_param2
param3 = rpt_param3

The an error occurred while excuting the query in the datasource wizard.
Also, some time the wizard accepts the query but the preview mode will display the same error.
The error is "ORA-01008 : Not all variables bound"

______________________________________
Workaround: Don't use the same query parameter in more than one child select statement. Create new datasource parameters per each select statement; then bind them all to the same report parameter. 

SELECT ORG, C1, C2, ... FROM (
   (SELECT X FROM Y WHERE Z1 = xxx AND Z2 = :param11 AND DATE BETWEEN :param12 AND :param13) C1,
   (SELECT X FROM Y WHERE Z1 = yyy AND Z2 = :param21 AND DATE BETWEEN :param22 AND :param23) C2,
   ...
)
Then binding with report parameter will be like:
param11 = rpt_param1
param21 = rpt_param1
param12 = rpt_param2
param22 = rpt_param2
param13 = rpt_param3
param23 = rpt_param3
______________________________________
Products:
* Report Designer v2014.Q2
* Oracle Database 10g1, 10g2 or 12c
* Oracle Client: ODTwithODAC 12.1.0.1.0 Or Less