Telerik Forums
Reporting Forum
4 answers
838 views
I have a TextBox that is calculating the difference in days between two dates.

Value: =IIF(Fields.originalshipdate>Fields.revisedshipdate, DateToInt(Fields.originalshipdate), DateToInt(Fields.revisedshipdate)) - DateToInt(now())
Format: {0:0}

public class OECReport : Telerik.Reporting.Report
{
    public static int DateToInt(DateTime date)
    {
        return date.Subtract(new DateTime(1899, 12, 31)).Days;
    }
}

This is returning an integer, in the range of -10 to 20, generally.

I am trying to use Conditional Formatting on this TextBox to Color the background based on the Value.

I've tried several different approaches without success.
----------------------------------------------------------
=ReportItem.Value < =0

Returns:

An error has occured while processing TextBox 'Alert':
Cannot perform '<' operation on System.String and System.Int32.

----------------------------------------------------------
=CInt(ReportItem.Value) < =0

An error has occured while processing TextBox 'Alert':
An error has occured while executing function CInt(). Check InnerException for further information.
------------- InnerException -------------
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
Input string was not in a correct format.

----------------------------------------------------------
=ReportItem.Value < 0

Fires on all rows, regardless of Value.
----------------------------------------------------------

Your help on this matter is appreciated.

Steve
Neli
Telerik team
 answered on 25 Oct 2019
2 answers
906 views

Hello Telerik Team, 

I work with an older version of Telerik Reporting (12.2.18.912) and recently saw that a trial version of a newer version (13.0.19.222) is still installed. 

I had installed it before I got my license. I checked in the Progress Control Panel, if I could uninstall the trial version, and couldn't find how.

The only option I have is to "Update To Purchase".

How could I remove the trial version?

Thank you in advance!

Best regards,
Tamara

Tamara
Top achievements
Rank 1
 answered on 25 Oct 2019
1 answer
272 views

I have an invoicing app that loads data from various sources and shows a balancing report that compares costs, etc...  Once the invoice is balanced and ready to be paid, it is set to approved status.  The problem is that sometimes invoice balancing reports need to be viewed later after processing, and some data may have changed in the interim.  So I would like to snapshot the invoice report when an invoice is set to approved status.

I have found solutions for rendering a report to pdf - those are easy enough to implement, but every request for how to view pdfs with the telerik ReportViewer control has been answered with "it's not supported, and we won't consider supporting it."  So I can export the report to pdf when then invoice is approved, but I have no way to display it to the user.  I could just open up the system pdf viewer, but that creates a weird disjointed experience - if the user selects 5 invoices to view reports and 3 of them are Approved and 2 are Pending, the pending ones will be displayed as part of the same ReportBook in the Winforms ReportViewer, but the other 3 would have to be opened in a separate window with Adobe Reader.  What I really want is to create an Invoice.GetReport() function that returns a ReportSource that encapsulates either a Report to be generated or a saved "frozen" report with the details that existed when the invoice was approved.

Is there any way at all to save a Rendered report (in any format - it doesn't have to be pdf) and then view it at a later time within the same user interface that I am using to display live reports?

Todor
Telerik team
 answered on 24 Oct 2019
3 answers
115 views
When one column goes on too multiple lines, the others get broken borders.  See attachment.
Todor
Telerik team
 answered on 24 Oct 2019
1 answer
96 views

Hello,

I have a TRDP report file with a WebServiceDataSource pointing to a web service with Telerik.Reporting dlls version 13.2.19.918.

When I try to view the report using the report viewer, I get an error: "Invalid format '= Parameters.token.Value'".

I stepped through the code and  the error comes from the web request that the WebServiceDataSource creates - it is initialized with the string

value " = Parameters.token.Value" instead of the computed expression.

 

When I switch back to the old version  13.1.19.618, everything works fine.

 

Is it a bug in the new version or is something that I missed?

 

Neli
Telerik team
 answered on 23 Oct 2019
2 answers
692 views

     Hi All , hope you can help here.... trying to setup a sub report only to run based on a user selection. Can this be done with an expression in the sub report property box (reportsource= or or binding)? If binding I'm not sure how to bind the parameter as the drop down only gives me ReportSource. I saw a post that suggests I can do this not explain how. 

 

Steve
Top achievements
Rank 1
 answered on 22 Oct 2019
5 answers
1.4K+ views

I'm creating an invoice report that sometimes requires a group to continue for multiple pages.

Is there a way within Report Designer to create a group-based page counter?

For example:

A report is 30 pages long but is split and page broken by a group.

The page counter for each grouping should display the current page, along with the number of pages for that specific group. Something like "Page 2 of 4"

Thanks! -Eric

Neli
Telerik team
 answered on 21 Oct 2019
1 answer
350 views
I'm using the standalone report designer with an ASP.NET MVC C# website.  My issue is that when I add a single select or multi select parameter, it always shows up in a list box instead of a dropdown.  Does anyone know if there's an option to display the parameter as a dropdown instead?  I've seen demos with normal dropdowns but I just can't find the option to change it.  I've attached a picture of the list box I'm referring to.
Neli
Telerik team
 answered on 21 Oct 2019
2 answers
723 views
Hello. I'm creating a report that contains qr codes in columns. The qr codes are displaying well, but if one of them is null, also is displayed. I'm trying to use conditional formatting, but if I uncheck "visible" in layout style, nothing is displayed in the column (background, borders...). I use another conditional formatting for alternating rows.

Thank you.
Roberto
Top achievements
Rank 1
 answered on 18 Oct 2019
3 answers
224 views

Hi,

 I have created a TRDX report files using Telerik stand alone report designer. I created an asp.net web application and calling the TRDX report in the browser using telerik report viewer control. Below is the code used in the page load to call trdx report.

  var reportSource = new UriReportSource() { Uri = "EVB_002.trdx" };
this.ReportViewer1.ReportSource = reportSource;

 We need to implement support for different languages in these reports, example when user wants to see report headers in French, there must be an option for user to select the language. I have gone through following 2 links given in telerik documentation and created a resource file(.resx). 

http://www.telerik.com/help/reporting/report-viewer-localization.html
http://www.telerik.com/help/reporting/advanced-localizing-reports.html

Please let me know the next steps to associate the resource files with telerik report viewer so that reports can be viewed in other languages.

Thanks,

Daniel

Neli
Telerik team
 answered on 17 Oct 2019
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?