Hello!.
After upgrade, report designer does not open with message "Cannot load file or assembly ' Telerik.Reporting.Design, Version=15.2.21.1125"

Tests I have done:
· Run from Extensions - Telerik - Reporting - Upgrade Wizard. The same error message appears.
· Create a new project and add a report. The result is that the same error message appears.
· From the Progress Control Panel I have uninstalled and reinstalled Telerik Reporting. Same result.
· I have run the Telerik.Reporting.VsX.vsix wizard from the BIN/VS2019 folder. Same result.
· I have tried to create a new project with VS2022 and the same thing happens.

Can you guide me what can I do? 

I have an issue with Telerik reporting.

I have set the caching to be on file. However, when generating large reports, the Cache folder keeps on recreating folder with all the cache items ( more than 10,000), and even if the report is closed on the browser, the cache folder keeps on being recreated every while.

 

Is there a way we can stop this or if we can stop caching ?

I have a table in a parent group (not the detail). I have two report parameters, and two filters. One is the Fiscal Year, and the other is the Fiscal Period. I am trying to do a YTD sum based on the filter fields.Fiscal Period <= Parameters.FiscalPeriod.Value, and then SUM(Fields.Value). If I have have period 3 selected, for example, I get three rows returned. How do I SUM all the returned rows based on the period I selected?

Hello,

We are migrating a 100+ reports from Crystal Reports to Telerik as part of an app redo. The old app was a windows app, the new app is an Angular (12 or 13) app. We will have the Angular ReportViewer presenting the report. The server side is C# .net5 or .net6.

We are the beginning of the project and have been creating proof of concepts to ensure functionality and no surprises when integrating with the main app.

The back-end database is MS-SQL (any version, any edition supported).

Focusing on speed, least data transmitted from server to client, etc. AND without concern for parameters - what is the recommended DataSource choice?

We are capable of using any of the supported methods, we just don't know if any have advantages given the above critera.

Thanks in advance for any help. 

Hi Team,

I found the same question  how-to-edit-the-created-pdf-metadata. I want to remove created date meta data from pdf document, which is generated by Telerik.Reporting.Processing.ReportProcessor().RenderReport.

As per our requirement, we create SHA256 hash from generated document, and compare it with previous one. Each time hash are mismatched.

As per initial analysis, I found that only Created Date meta data information is varying, which results hash mismatch.

Is there anyway to provide Create date i.e. null or remove such meta data.  I did not found such metadata information in PDF Rendering Design Considerations and PDF Device Information Settings

 

Hi,

I am using Web Service DS and i get this error in the standalone report designer.

I have been able to return the data in json format via Postman with the same Header parameters, but when i try to configure the data source in the report designer, I get the following error. 

System.InvalidCastException: Unable to cast object of type 'System.String' to type 'Newtonsoft.Json.Linq.JToken'.

Issue Value

{"esFilters":{"Paging":[{"paged":false,"resultsPerPage":0,"pageNumber":0}]}}

or

{ esFilters: {"Filters":[{"filterName":"","filterValue":"","filterOperator":""}],"Paging":[{"paged":true,"resultsPerPage":100,"pageNumber":1}]}}

Please advice. Thsi API works in the application and postman without any issues.

Thanks,

BV

 

 

I would like to export all the database objects used within a report (.trdp file), and the number of times each reference is used. The rationale is we need to be able to easily identify all the database objects (e.g., tables and columns) used in a report whenever schema change discussions arise. This would include columns used in text elements, tables, charts, expressions, and so on.

Example:

REPORT	DATASOURCE	TABLENAME	FIELD	NUM_REFERENCES
FacilitiesReport.trdp	facilities	facility	id	1
FacilitiesReport.trdp	facilities	facility	name	2
FacilitiesReport.trdp	facilities	facility	zip_code	1
FacilitiesReport.trdp	facilities	city	zip	1
FacilitiesReport.trdp	facilities	city	name	3
FacilitiesReport.trdp	facilities	city	state	1

I doubt this exists out of the box so I figure I need to script something. I am considering creating an instance of a report and looping through all the objects and collecting all datasource and field references in a dictionary and then exporting the completed dictionary to a csv.

I could also unzip the trdp file and parse the xml, but if the schema changes from version to version I could wind up with brittle or broken code.

Has anyone here down something similar? Recommendations?

 

I'm exporting a report programmatically to PDF using code like this:

                var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
                var deviceInfo = new System.Collections.Hashtable();
                var reportSource = new Telerik.Reporting.UriReportSource();
                reportSource.Uri = "<My report path>.trdp";

//Various parameters are set
                object ParmValue;
                ParmValue = "<My value>";
                reportSource.Parameters.Add("<My parameter name>", ParmValue);

                Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo);

After this I save the result into SQL server for retrieval later. For these reports I always get a result object back even if there are no data rows returned from the database query the report makes (it still has headers/footers/etc. but no details). What I'd like to do is determine if there weren't any data rows returned and take alternate action myself. 

Is there a way to determine how many data rows were retrieved by the report? The only solution I can come up with at the moment is querying the database twice; first without the report being involved to see if the database query will returns any rows; and then again by the RenderReport method if there's data to report on. That isn't efficient though. Is there something in the report objects that will tell me if there was no data returned to the report?

Hi,

 

I'm struggling to authenticate a Microsoft Dynamics 365 webservice with OAuth2.

I'm using the Web Service Data Source wizard within the Report designer to connect to the Web service but not having any luck. I can successfully access the Web service and OAuth2 API in Postman. 

When I try to download the response in the preview window, I get a 400 bad request error. I believe the problem is with fetching the token/authentication but not sure.

Can someone please tell me what I'm doing wrong?

How do I create a dropdown with the options of: greater than >, less than <, or equal to =, then have a textbox for the value?

See attached image for something similar I am looking for. I'm trying to make a report where the user can enter a number, then select one of the options I just described. I've been stuck on this for a week!!!

 

I've read so many articles, and watched 7-8 year outdated youtube videos. Any help is greatly appreciated!

 

-Chris