Dear Telerik Support Team,

I hope this email finds you well.

We are currently facing an issue with our report rendering in the Telerik Report Viewer. While the report design is implemented perfectly, and the exported PDF displays as intended, the Report Viewer shows significant extra space in certain areas (see attached screenshots for reference).

Here are the details of the issue:

1. Problem Description:

   • In the Telerik Report Viewer, there is a noticeable amount of unnecessary blank space in the red-marked sections.
   • The PDF export of the same report works perfectly without any extra spaces.
   • This issue appears only in the Report Viewer, and it is not related to the report design as it has been validated multiple times.

2. Steps Taken:

   • Verified and adjusted the Page Settings, Margins, and section sizes in the report design.
   • Ensured all sections (Headers, Details, Footers) have the CanShrink property set correctly.
   • Checked for proper anchoring, docking, and layout alignment of report items.
   • Tested in different rendering formats and configurations.
   • Verified that the issue persists across different datasets and Report Viewer configurations.

Despite these measures, the issue persists, specifically in the Telerik Report Viewer.

Could you please assist us in identifying the cause of this discrepancy and suggest a solution to resolve this issue? Please reach out to me if you need further details.

Looking forward to your help on this matter. Thank you for your time and support!

Best regards,
Mohammad  Safayet Hoosain

Senior Software Engineer

Brain Station 23

Hi, I have a question - is the latest version of reporting working with .Net 9 RC2? Based on https://www.telerik.com/support/whats-new/reporting#compatibility-with-_net-9-preview it should be ok. Or not?

I switched our application to .Net RC 2 and all our PDF reports ends with errors. No report is rendered. All errors are about resources like:

"The expression contains object 'ResourcesInfo' that is not defined in the current context"

Tested verion of Telerik.Reporting.Services.AspNetCore is 18.2.24.924.

I have 3 panels in a report (using Standalone Designer R3 2021).

Corresponding to these panels, I have 3 fields in the data source V1Display, V2Display and V3Display.  The values in these fields are either 0 or 1, with 1 indicating the panel should be displayed.

I've tried different suggestions I've found in older threads and elsewhere to hide the panels based on Conditional Formatting or Binding.

How do I had a panel if its VxDisplay value = 0?

We have a case where we have the following json data source as the source of data:

{
    "Transaction":
    {
        "ProductList": {
            "Product":[
                {
                    "@Item": "Product Name 001",
                    "@Price": 1.00,
                    "Taxes": {
                        "Tax" :[
                            {
                                "@Type": "TaxType1",
                                "@Amount": 1.00
                            },
                            {
                            "@Type": "TaxType2",
                            "@Amount": 2.00
                            }
                        ]
                    }
                },
                {
                    "@Item": "Product Name 002",
                    "@Price": 1.00,
                    "Taxes": {
                        "Tax" :[
                            {
                                "@Type": "TaxType2",
                                "@Amount": 1.00
                            },
                            {
                            "@Type": "TaxType2",
                            "@Amount": 2.00
                            }
                        ]
                    }
                }
            ]
        }
    }
}

We have imported it into Telerik Designer in such a way that it appears like this in the Data Source Explorer:

We want to display in a table, for each Product line, the sum of all its Product.Taxes.Tax.Amount in addition to the product's own data. e.g
ProductName 001 | Product Price 001 | Sum(Product.Taxes.Tax.Amount) for Product 1
ProductName 002 | Product Price 002 | Sum(Product.Taxes.Tax.Amount) for Product 2

We can easily access attributes of Product such as "Item" or "Price". The problem arises when we want to access the sum of the Product.Taxes.Tax.Amount for each product.

It seems that the expression editor and Data Source configurator is not able to reach the depth level of Product.Taxes.Tax.Amount. We tried to acces via JSON Path in the Data Source but didn't work

How can we represent the Product.Taxes.Tax.Amount sum for each Product in a table?

Thanks in advance!

Hello All,

I've built 100's of Reports using the Telerik tools but I've never used a SQL query where I've used a DECLARE function for the data source.

Here is my query:

DECLARE @CaseNum as NVARCHAR(12) = '20604003'
DECLARE @Enc as INTEGER = '743212'
DECLARE @START_Date as DateTime ='2024-10-08 00:00:00.000'
DECLARE @Enc_Date as DateTime= '2024-10-17 00:00:00.000'
DECLARE @Location as NVARCHAR(75)= 'SHOULDER/ARM' 

SET @Location = (SELECT Location FROM tblVisitLog WHERE Encounter_code = @Enc AND CaseNumber = @CaseNum AND Discipline = 'PT' AND VisitType <> 'M') 

SET @START_Date = (SELECT TOP 1 TimeIN 
FROM tblVisitLog 
WHERE Encounter_code = (SELECT MIN(Encounter_code) FROM tblVisitLog WHERE CaseNumber = @CaseNum AND Discipline = 'PT' AND VisitType <> 'M' AND TimeIN > '2014-12-31 00:00:000' AND Location = @Location) AND CaseNumber = @CaseNum 
AND Discipline = 'PT' AND VisitType <> 'M')

SET @Enc_Date = (SELECT TimeIn FROM tblVisitLog WHERE Encounter_code = @Enc AND CaseNumber = @CaseNum AND Discipline = 'PT' AND VisitType <> 'M')

SELECT  COUNT(Encounter_code)
FROM tblVisitLog 
WHERE CaseNumber = @CaseNum AND TimeIN BETWEEN @START_Date AND @Enc_Date AND Discipline = 'PT'AND VisitType <> 'M' AND  Location = @Location

This works great in SQL Server, but this is throwing the following error when used as the Report Source: for this sub-report.

Invalid value of report parameter 'Location'.

I've ran this report specifying the values (shown here) in my SQL and using the Parameter.Location.Value on the Configuring data source parameters page. I've left them blank and specified the values on the Configure Design Time Parameters, in other words I've tried many many things.

I need help with this. Thank you,

Jack

Hello Colleagues,

We run into the unpredictable to us behaviour during rendering report into the Excel format (the PDF looks like fine).

The vertical page breaks is appeared and splits the page content but all properties related to the layout and element dimensions were configered properly for our opinion.

Shortly,

1)page setting is set up as: A4 (210 x 297 mm), Portrait, Margings Left/Right = 2 / 1 cm,  width of detailSection 18cm

2)The content: one table with total widht 18 cm

Result of rendering to the Excel: 2 pages  with vertical splits the table.

Table width = detailSection width (180mm). detailSection width(180) + Left/Right margins(20/10) = A4 width (210) = 210 mm

The mail question here is Why?

During some experiments we found that the result of page rendering into the Excel doesn't have any vertical breaks if content in the sectionDetails is not closer to the right edge of report layout then 13mm.

Could you help with understanding the rendering mechanism to the Excel format?

How properly placing the report elemets on the layout to avoiding vertical page breaking the Excel result?

Screenshots was attached. The archive (rar or zip) of template and excel results I couldn't attached 

Thank in advance

Best,

Alex

Hi, in Telerik Report Designer, I want a text box on my report to display the word chicken, but only if the value of another item, fields.name, begins with the letters apple so there would need to be a wildcard after the e in apple. If fields.name is anything else then I don't want the word chicken to show up on the report.

I'm new to the product and used to "Print When" logic.

Thanks