I have DataSource assigned to my report, which content is displayed in its Detail section. The Page sections have some static content. The SkipBlankPages property is set to False.
When the data set received by the report is empty, the static content in its Page sections is not displayed in Interactive View. In PrintPreview the Page Header/Footer content is displayed as expected. When the data set returns valid data, the Interactive view displays everything as expected.
I've run into a problem when using a Combo Box for a Multi-Select Parameter. The issue is that if the user selected values then clicks the preview button, while the dropdown list is still displayed, the parameter is not set before the report is generated.
I would prefer to use the combo box to set the parameters, but this will be an issue for the users. If I click elsewhere on the report or just re-run the report the parameters are set properly. This does not occur with the Listbox functionality.
The error below is thrown in PictureBox when System cryptography Use FIPS compliant algorithms is enabled:
An error has occurred while processing PictureBox 'pictureBox1': Exception has been thrown by the target of an invocation.When a report includes drill-down item(s), the report is run again each time the user expands a drill down item. This is apparent in the demo at https://demos.telerik.com/reporting/product-sales
I would like to see all of the drill-down data generated and delivered with the initial report, but collapsed and awaiting inspection.
Perhaps this would be an attribute of the drill-down element (pre-fetch versus re-run) so that developers can choose the most appropriate experience for their users / conserve server resources.
It would be great if you could make the border of the stand alone report designer visible. It's hard enough to see and grab thin gray lines but Report Designer borders become invisible. Below is a screen shot of the report designer in front of my Telerik Reporting program folder:
Our team is in the process of converting Crystal Reports documents over to Telerik Reporting and one of Crystal Reports advantages over Telerik Reporting was the ability to create custom fields with Crystal or Visual Basic Syntax, including the declaration of variables. Lack of variables and a few common constructs can make simple expressions overly complex.
One of the more common use cases for us is formatting text differently based on one or more other values. Without the ability to write if/elseif/else blocks we wind up with nested ternary statements which can be are hard to read and maintain.
While we can write user functions that seems impractical for long term maintenance and support. It would be very helpful if we could create expressions using C# directly in the Report Designer and have the embedded within the report itself.
See my initial request for something similar in the forms here: https://www.telerik.com/forums/feature-request-if-elseif-else-and-or-switch-statement-support-in-expressions
<Nullable>enable</Nullable>validation errors are returned for endpoint which accept null (or nothing) for parameters.
Currently, when GroupFooterSection.PrintAtBottom is set to True, all subsequent sections will be moved to the next page. For that reason, the Report Footer also moves to another page even when its PrintAtBottom is True and both sections can fit on a single page.
If I set the Group Footer PrintAtBottom to False, it will be printed just below the Detail section, which may leave unwanted blank space between the Group Footer and the Report Footer.
I think that it is more intuitive to have both the Group Footer and the Report Footer printed at the bottom of the last page in this scenario, with the Group Footer just above the Report Footer.
In Web Report Designer I added a List to my report groupHeaderSection and then couldn't delete it. It switched it to a TextBox. When trying to delete the TextBox the number of the box increments up/down.
There are times when I can't drag it to a different location.
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!