In some cases, the word export will cut off the report content with a blank page.
Here is an example of the procedure on AdventureWorks 2019 database:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[ProcedureConditionsTest]
@ReportPart SMALLINT = 1
AS
BEGIN
SET NOCOUNT ON;
IF @ReportPart = 1
BEGIN
SELECT P.FirstName AS FirstNamePart1, P.MiddleName AS MiddleNamePart1, P.LastName AS LastNamePart1,
A.AddressLine1 AS AddressLine1Part1, A.AddressLine2 AS AddressLine2Part1, A.City AS CityPart1, A.PostalCode AS PostalCodePart1,
SP.StateProvinceCode AS StateProvinceCodePart1, SP.CountryRegionCode AS CountryRegionCodePart1, SP.[Name] AS NamePart1
FROM [Person].[Person] AS P
JOIN [Person].[BusinessEntityAddress] AS BEA ON P.BusinessEntityID = BEA.BusinessEntityID
JOIN [Person].[Address] AS A ON BEA.AddressID = A.AddressID
JOIN [Person].[StateProvince] AS SP ON A.StateProvinceID = SP.StateProvinceID
WHERE P.FirstName BETWEEN 'A. Scott' AND 'Justine'
ORDER BY P.FirstName, P.LastName
END
ELSE IF @ReportPart = 2
BEGIN
SELECT P.FirstName AS FirstNamePart2, P.MiddleName AS MiddleNamePart2, P.LastName AS LastNamePart2,
A.AddressLine1 AS AddressLine1Part2, A.AddressLine2 AS AddressLine2Part2, A.City AS CityPart2, A.PostalCode AS PostalCodePart2,
SP.StateProvinceCode AS StateProvinceCodePart2, SP.CountryRegionCode AS CountryRegionCodePart2, SP.[Name] AS NamePart2
FROM [Person].[Person] AS P
JOIN [Person].[BusinessEntityAddress] AS BEA ON P.BusinessEntityID = BEA.BusinessEntityID
JOIN [Person].[Address] AS A ON BEA.AddressID = A.AddressID
JOIN [Person].[StateProvince] AS SP ON A.StateProvinceID = SP.StateProvinceID
WHERE P.FirstName BETWEEN 'K.' AND 'Zoe'
ORDER BY P.FirstName, P.LastName
END
END
GOIn the report Designer I added two SQL Data Source named Part1 and Part2:
Part1:
EXEC [dbo].[ProcedureConditionsTest]
@ReportPart = 1Part2:
EXEC [dbo].[ProcedureConditionsTest]
@ReportPart = 2On both sources, I have column sufix Part1.
Hi Team,
I would like to request an HTML5 ASP.NET Core Report Viewer similar to the MVC version with wrappers. It would be great to be able to utilize Razor Syntax for developing instead of pure jQuery.
Thank you!
The overlap warnings may clutter up the page.
It will be a good option to be able to switch them off. The reason is that most of the time I want to ignore them because they actually do not cause problems. If I want to turn it on to check I would be able to.
When the font that is used to generate the report is not installed on the client machine, some of the text may be cropped
t would be very useful to be able to embed fonts in DOCX and the other OpenXMLs, as in PDF.
Clicking the cancel button on the HTML5 report viewer show "Report processing was canceled" in the UI but the report is still being generated and rendered on the server.
In this old thread it is stated that it isn't possible to cancel the report generation on the server. Is that still the case?
Please add the Web Report Designer Item Template for VB.NET projects too
In my report, there are multiple stacked Panels. Each of them may fit on a single physical page. They all have KeepTogether set to True and I expected each of the Panels to start on a new page as two of them cannot fit on one page. This may not happen when I have Page sections though.
When I delete the PageHeader and/or PageFooter the Panels are displayed as expected. However, if I set the Visible of the Page sections to False, the problem persists.
It looks like the Page section's Height is taken into account when evaluating the KeepTogether behavior even for the pages where it is hidden. This shrinks the available physical area and the Reporting engine decides that the Panel cannot fit there, hence the next Panel starts from the current page rather than the next page as I think is correct.
My report contains emojis, and they are displayed properly in the designer and in the Html5 Viewer.
When I export to PDF, the emojis disappear. The emoji font is listed as embedded in the PDF file. Even if I embed the full font, the emojis are not displayed.
I want to export a Report as a PNG image with transparent background.
I set the Style > Background to Transparent for the PictureBox in the detail section, for the Page and Detail sections, for the Report itself, and for Report > PageSettings. The PNG image is still rendered with white background.
Currently, I am using XmlSerializer to deserialize .trdx file, and it returns Telerik.Reporting.Report type object.
Since, for a long time, I need to add my own functions to be available in the report's expressions, and this need becomes larger and larger, it would be great if I could use the Telerik.Reporting.XmlSerialization.ReportXmlSerializer class to deserialize the .trdx file in my derived class.
For example:
var report = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer().Deserialize<MyReportDerivedClass>(TemplateStream);I noticed that using the Standalone Report Designer for .NET, I can't open the "ReportSource" dialog for a SubReport. The property cannot be edited from the Properties tab either.
Instead, when using the Standalone Report Designer for .NET Framework everything works fine.
Hello Support-Team,
in the WebReportDesigner, the Edit-Window shows "undefined" for the FieldNames, when selected a second Time.
This is also reproduceable in the demo application: https://demos.telerik.com/reporting/designer.
(see Screenshot in attached Files)
Steps to repoduce:
1. Open the Edit-Window for a TextBox (with a DataSource)
2. Select the DataSource-Entry.
3. Select some other Entry, e.g. "Report Parameters"
4. Select the DataSource-Entry.
Best regards
Alexander Schneider
System Development | Loy & Hutz Solutions GmbH
Currently the generated accessible PDF documents contain tagged elements, but lack information about the logical structure of the PDF document. This prevents screen readers of correctly reading the PDF document contents. The tools like PAC (PDF Accessibility Checker) do not display correctly the document structure.
Currently the behavior of the Web Designer and Standalone Designer is different in regard to DateTime Report Parameters and its "Kind" property.
The Web Designer will assume the value is of Kind "Utc" and the Standalone Designer uses "Unspecified".
This recently became more of an issue since the newer PostgreSQL Provider versions are a lot more strict regarding the "Kind" property:
Npgsql: Timestamp rationalization and improvements
The consequence of this is not being able to use Sql parameters which will work in both the WebDesigner/WebViewer and the StandaloneDesigner:
To resolve this issue right now, one would need to resort to ugly workarounds:
To properly address this issue it needs to be possible to set the Kind property in the Viewer. Or at least the behavior between the WebDesigner and Standalone Designer should be the same.
Additionally/Alternativly it should be possible to set the target Kind in the Report Parameter.
With kind regards,
Dominik Rothert
Reproducible in 17.1.23.606 - SRD .NET6
Steps to reproduce the behavior:
Expected behavior
No exceptions
Actual behavior
Table Body has 9 rows but 3 are expected.
Screenshots
Screenshot