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

Hi everyone,

I'm working with Telerik Report Designer, and I have a table inside a panel. The panel represents the entire page that gets printed. The table is bound to a JSON data source.

In my JSON data, I have several objects, and some of them have a value of 0.0 If two specific objects have a value of 0.0 I want to hide the panel (and therefore the entire page) to avoid printing out a table with no meaningful values.

The data source is linked to the table, not to the panel, so I am not sure how to make this condition work. I need to hide the panel based on the values within the data.

Does anyone have any idea how I can set up conditional formatting or report parameters to achieve this?

Thanks in advance!

We are trying to create a user interface with UI for Blazor that allows users to view and choose parameter values for their reports without having to go into the report viewer. However, the complexity of some of the expressions used for things like display value, available value filtering, and default values pose a challenge to evaluating those parameters ourselves. Is there a way to programmatically evaluate those parameters for the above using the telerik reporting library so that we can display them in our UI?

We are using the Telerik.Reporting.Report object to get the parameter data, and have also tried instantiating a InstanceReportSource for the object as well but both have only given the expression for display value/available values/default values rather than the evaluated values.