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,
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!
Having the PrintOnFirstPage property set to False does not always hide the Page Footer section on the first page
If the vertical space of the report(The paper height of the paper size which can be seen in Report.PageSettings) allows it, the footer will get rendered on the first page despite the property being False.
Code128 Barcode does not always pick the correct subset for the given input value
For example, the string A12B34C56DIt seems that the MultiSelect Combo Box Filtering does not work in the Report Viewer. o be smaller if the user starts typing
example of how it is removed
Hi, While the Report Designer exports tags to the PDF (with Accessibility enabled), the tags exported are not fully compliant with PDF/UA or 508 requirements. For example, my document has several hundred pages, each with two or three data tables on them. While the tags get exported, they are only Paragraph tags, and NOT Table tags. Is there a way to designate Table Header Rows, Header Columns, and Data Cells in Telerik Reporting such that upon export to PDF they get tagged properly?
The issue may be observed with the online demos - see the linked screenshot.
If I go back and add new records, the total rows count gets updated but still doesn't count the initial rows.
I have a table with a dark background. In some scenarios, one or more data source fields may be empty, leaving the corresponding table cells with no content. When I export this report to DOCX, the empty cells contain strange white lines.
In the other export formats, the issue does not occur.
Here is how the table looks like in Word:

Currently, when I create a report with the Standalone Designer and localize it, I can preview it only with the language of the machine where I run the designer.
It would be very helpful to have the option to select one of the languages I have set up during localization when previewing.
We use Reporting REST Service to generate our reports. When exporting to BMP, EMF, GIF, JPEG, and PNG which are all multi-document formats, the downloaded documents are corrupted and cannot be opened in Image viewer.
The TIFF image, which is a single document is exported and opened as expected.
When the EnableAccessibility PDF device info setting is set to true in the RuntimeSettings of a report, the text set to an item in the AccessibleDescription report item property is not respected.
For example, a PictureBox with AccessibleDescription set to "Text1" will have the "Picture Box" alternate text set in the exported PDF instead of "the Text1" string.
I am trying to add HtmlTextBox to my report. After double-clicking on the HtmlTextBox, instead of opening the HTML editor, an error message appears

And after that, it is not possible to delete any element of the report