Telerik Forums
Reporting Forum
1 answer
11 views

Hello, 

I have .trdp files that have a textbox with a culture set as 'en-US' and the format for the textbox is '{0:C2}'.

There is no such change in the file.

It was rendering negative currency values properly until I updated  Telerik. Reporting  Nuget version from  NuGet '17.2.23.1010' to '7.2.23.1114' in my .Net 7 project.

Please, guide me if I am missing something.

1 answer
80 views

I have a table in my report where i have the borders for the row and column headers set to solid 1pt borders

I also have conditional formatting set on the rows so that every other row has a light grey background color for readability

The problem is, that any row/column header that touches one of the detail rows with the conditional formatting loses the border that touches that cell.

I have attached screenshots of the report in preview mode and in design mode

Todor
Telerik team
 answered on 31 Jul 2023
1 answer
55 views
Is there a way to set the colors for a pie chart without having to set the conditional formatting values for both the series and the legend? It would be nice to be able to just set it once.
Momchil
Telerik team
 answered on 10 Jul 2023
1 answer
59 views

I have a main report (A) which loads and embeds a 2nd report (B) as a subreport.

Report B can also be loaded on its own, without being contained in report A. 

I would like to hide (or blank out the value) in a Textbox on Report B if it has been loaded on its own. How do I do this?

Mike
Top achievements
Rank 1
Iron
 answered on 24 Apr 2023
1 answer
189 views

Good Afternoon Telerik Support,

 

I am trying to format an Averaged date & time between two values as HH:MM:SS (see screenshot). However, when I used the format Date & Time value for HH:MM:SS it gives me the following error (see screenshot) How can I fix this as I do not want the milliseconds at the end and it seems to keep adding it.

 

(Average Combined Time)

 

(Error After formatting it to HH:MM:SS ({0:hh:mm:ss})

 

 

Thank you!

1 answer
96 views

I'm configuring a custom format for a SQL datasource using Telerik (desktop) Report Designer v14.2.21.115.

I create the custom format for a date field as such

I click OK and when I preview the report I get an error "Input string was not in a correct format".  Looking at the custom format settings again, the value type changes back to numeric as below

Why does the Value Type change back to Numeric?

A similar issue occurs with CallTime when I format it as HH:mm

The property for the fields do contain the appropriate format values

Taras
Top achievements
Rank 3
Iron
Iron
Veteran
 answered on 01 Feb 2022
1 answer
163 views

I am calling a JSON Webservice that does not return a nested object if the values are null.

I am using the value of the nested object (Fields.Orders.Salesperon.Name) in a detail row of my report.

This results in an error for any rows with no salesperson: "The expression containt object 'Name' that is not defined in the current context".

Here's a sample of what's being returned from the webservice:

{
  "Orders": [
    {
      "OrderNumber": 1,
      "Salesperson: { "Name": "Joe Example" }
    },
    {
      "OrderNumber": 2,
      "Salesperson: {}
    }
}

OrderNumber 1 will print fine. The row for OrderNumber 2 will have an error box.

Screenshot from the actual report:

 

How can I prevent this? I've tried null checks, value binding, conditional formatting... but it all throws an error because it's trying to access the nonexistent "Name" field on a record.

1 answer
92 views

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?

Taras
Top achievements
Rank 3
Iron
Iron
Veteran
 answered on 13 Dec 2021
3 answers
960 views
Good afternoon.
I'm trying to do conditional formatting for the last row in table on a page, but I can't figure out when a page break occurs. Is it possible to do this?

I can calculate the last row in the group and add conditional formatting like this:

= Exec ('groupID', Count (Fields.No)) = = RowNumber ()

But I do not know how to find out that the row is the last when moving to a new page.
Dimitar
Telerik team
 answered on 11 Oct 2021
1 answer
141 views

Good Morning Telerik,

 

The query I am using within Telerik to query my data from the SQL database is the following.

SELECT *

FROM WebTasks

WHERE COMPLETEDDATE BETWEEN TO_DATE(:FromDate,'MM/DD/YYYY HH24:MI:SS') AND TO_DATE(:ToDate,'MM/DD/YYYY HH24:MI:SS')

 

It creates two parameters the "To Date" and "From Date" however- selecting the date and clicking preview just returns the entire table with all the data going back before and after the selected dates. one of the tables with the dates is "COMPLETEDDATE" but it seems to be ignoring this I guess?

 

What am I doing wrong?

Top users last month
Patrick
Top achievements
Rank 1
Iron
Iron
Iron
MIS
Top achievements
Rank 1
Ross
Top achievements
Rank 1
Marcin
Top achievements
Rank 1
Iron
Iron
Sean
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?