I am attempting to build a formatting rule to hide a row in my table.

=iif(isnull(Fields.PODetails_Comment,"")="",1,0)

My data will have null and '' (MSSQL). When running the report, it appears to work most times and others it does not.

I went as far as doing it in SQL "Case when isnull(podetails.comments,'') = '' then 1 else 0 end" then modified the expression in the conditional format to use that new field from SQL...same result.

I finally did a LEN() on the field:

=IIF(Len(fields.PODetails_Comment)>0,0,1)

Again, in most cases, the report looks fine. However, once in a while it will show the row when it should not.

Ideas?

I had an old Silverlight Project which I am trying to upgrade.
I did upgrade the reports using the Upgrade Wizard from Telerik.
Now I am using HTML Report Viewer to display the reports. 
The report and parameters are being set from the client side using java script for which I followed  https://docs.telerik.com/reporting/html5-report-viewer-howto-custom-parameters 
I can see the parameters being passed from the console and in the report viewer but the parameters are not being received by the Stored Procedure. The stored procedure gets the parameter values as NULL. 

Unable to figure out why it is happening like this. 

Thanks

Could you tell me why when I create a new text box in the "detail_ItemDataBinding" method (for each row) ... this new text box is only created in the second row (and in the third row, and in fourth ... but never in the first) ...? I can not create any new text boxes in the first row ... It's the same code for each row

Why it happens?

Thanks

Hi,

I am using HTML5 Telerik Report Viewer for my MVC 5 Project and using Stored Procedures to fetch the data. Its pretty awesome.

The only issue I am facing is, I cannot use the column names exactly returned by my stored procedure. The pattern is following:
If a user select February from the options, report should show:
Sr. No         February         Name

  1                  15                  xyz

  2                  30                 abc

but if user select December, it should show the following:

Sr. No         December         Name
  1                  15                  xyz
  2                  30                 abc

 

I cannot make the columns dynamic. My stored procedure can return dynamic column name (using pivot). Can you please help me out? I am unable to find such a solution on your forums and/or stackoverflow. Please keep in mind that I am using MVC 5 HTML 5 Report Viewer with stored procedures.

 

Thanks alot

 

I had an old Silverlight Project which I am trying to upgrade.
I did upgrade the reports using the Upgrade Wizard from Telerik.
Now I am using HTML Report Viewer to display the reports. 
The report and parameters are being set from the client side using java script for which I followed  https://docs.telerik.com/reporting/html5-report-viewer-howto-custom-parameters 
I can see the parameters being passed from the console and in the report viewer but the parameters are not being received by the Stored Procedure. The stored procedure gets the parameter values as NULL. 

Unable to figure out why it is happening like this. 

Thanks

I want change or set a new sorting in telerik reporting 2016 r3 in code behind.I am using silverlight.

I cannot to update or set the new sorting. It does not work?

I tried to use below code in need_datasource (before or after datasource assignning) but does not effect.

Telerik.Reporting.Sorting sorting1 = new Telerik.Reporting.Sorting();

sorting1.Expression = "=Fields.MyField";

sorting1.Direction = Telerik.Reporting.SortDirection.Asc;

this.report.Sortings.Add(sorting1);

 or by direct assigning :

this.report.Sortings.Add(new instance with new expression and direction);

Does not work!

 

 

 

Hello 

I am trying to follow article below:

https://docs.telerik.com/reporting/designing-reports-parameters-programmatic-control

I designed my report in Standalone Report Designer(Test.trdp), Data source is stored procedure taking one parameter(@pDest).

Now, I am trying to display report in WPF ReportViewer, how shall I pass this parameter to ReportViewer ?

       <tr:ReportViewer Grid.Row="0" x:Name="ReportViewer1" HorizontalAlignment="Stretch" EnableAccessibility="False">
                <tr:ReportViewer.ReportSource>
                    <telerikReporting:UriReportSource Uri="Reports/Test.trdp"/>
                </tr:ReportViewer.ReportSource>
            </tr:ReportViewer>

How do I assign NeedDataSource event handler? 

 

I'm using the hyperlink on a Textbox (not a HTMLTextbox but rather a plain Textbox).   I did this via the Action property and selecting Navigate to URL with Link Selected set to NewWindow.   The target URL is set to the following expression:

= Parameters.URLPrefix.Value + CStr(Fields.SERVICEREQUESTIDNUM)

It works great in the Report Viewer and when I export it as a PDF, but not in Excel.   How do I fix this?   Is this an Excel setting that is preventing me from hyperlinking.  Thanks.

In a stacked column graph (not the 100% one), is it possible to construct an expression that show the percentage of the amount of the series as expressed as a percentage of the total for the column, as per the attached?

Or do I have to do this in the SQL?

I just installed a trial version and I am not getting the telerik menu when i am viewing a report in vs2017.

 

Telerik reporting: v12.0.18.227

VS2017 enterprise: v15.6.2