- Visual Studio 2022
- Installed Telerik.Reporting (16.0.22.225) Manage Nuget Packages for Solution, Restarted VS, then installed via the Telerik Control Panel and targeted only VS 2022, did not install sample files, Restarted VS.
- Added new class library - Target Framework: .NET 6.0

When I add a new Blank report to the new class library, I get an error:
The reference "System.Windows.Forms, Version 4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" could not be added to the project.

The class library is empty except for this report.

 

I have a wpf project, with a telerik reports Report Library project, a lot of time ago I don't make a reports here, I need to make a new report, and I do it, and I add a SQL data source, with a sql query and I run it and response me with the data ok, but in design mode, when I try to add a textbox, the reporter don't show me any info in "fields", I review all and I don't find what is wrong, what's going on??

I need a series of reports that display folder information in a hierarchical layout (undeterminate number of folder level parents/children) so i need to find a way to create a report that presents each level and then its children recursively, such as a recursive BandedReport or possibly a Subreport would do...
- Data is retrieved from an SQL database table in a self-referencing datatable(the Folder.ParentID points to another folder record with the same Folder.FolderID. 
- I design the Reports in the StandAlone designer.
- We need them to be "self-processing"... that is, apart from setting parameters being passed from the calling Winforms Application, there should be no "additional processing" or "value setting" or "business logic" from the calling application. We need it to be truly "set parameters and call RefreshReport()" and let it go... This is so that we (AND our clients) can add reports like these to our application without needing to change application code or needing custom programming.

I have looked at and run the project from 2013 "Recursive HierarchyReporting" (https://www.telerik.com/forums/recursive-hierarchy-reporting) and found it somewhat useful except 1) it processes the selection of the subreports within the code class and 2) it uses a dataobject hierarchical layout within the data structure rather than a flat table of records that self reference.
can you point me to some more recent examples of how to accomplish the hierarchical report from a self referencing SQL datatable query?
many thanks!!

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?