Telerik Forums
Reporting Forum
4 answers
557 views

Hi guys,

I have a table, and one of the columns is it works perfectly when I set the picture value from the data source.

But we have some invalid images, and we want to validate the image in the . So how can I set the image in the or maybe get the image path in the  function.

 

This is my code, tried to fill the TextBox9 with the image path, but not working properly:

 

Private Sub PictureBox4_ItemDataBinding(sender As Object, e As EventArgs) Handles PictureBox4.ItemDataBinding
        Dim picture As Telerik.Reporting.Processing.PictureBox = DirectCast(sender, Telerik.Reporting.Processing.PictureBox)

        Dim s As String = String.Format("= '{0}' + {1}", "/portals/0/PI/ProductImages/", TextBox9.Value.Replace("=", ""))

        picture.Image = Image.FromFile(s)
        TextBox13.Value = s
    End Sub

thanks

 

Stef
Telerik team
 answered on 29 Nov 2016
1 answer
869 views

Im trying to use nested if statement, but it fails to work:

 

inside my textbox:

=Max(IIF(Fields.RequestContactCodeDescription = "Broker", 
IIF(Fields.HomePhoneNo = "", IIF(Fields.BusinessPhoneNo = "", IIF(Fields.CellNo = "", "No Contact Num", Fields.CellNo), Fields.BusinessPhoneNo), Fields.HomePhoneNo), ""))

 

 

equivalent pseudo if statement:

If(Fields.RequestContactCodeDescription == "Broker"){

     if(Fields.HomePhoneNo == ""){

          if(Fields.CellNo == ""){

           [...]

          }else{

            //Show CellNo

          }

      }else{

         //Show HomePhoneNo

     } 

}else{

//show nothing

}

 

What I want it to do:

Find the entries that has 'Broker' as the code Description. Then show his Home phone number, if he doesnt have that then show his Cell number, if he doesnt have that then show his Business number

Stef
Telerik team
 answered on 29 Nov 2016
4 answers
51 views

I have already update my telerik reporting to R3 2016.  But when I drag the ReportVeiwer from toolbox, the top menu is still old style, unlike the demo site.

https://demos.telerik.com/reporting/invoice?&skinName=office365

How can I fix that?

Bertha
Top achievements
Rank 1
 answered on 28 Nov 2016
5 answers
130 views

Hi Team,

 

I need to download Telerik version 7.1.13.612. Currently, I am using version 10 but I don't want to upgrade. 

 

Thanks in advance for help.

 

Regards,

Ravi

Ravi-Kumar
Top achievements
Rank 2
 answered on 28 Nov 2016
12 answers
450 views

Hello,

I'm evaluating Telerik Reporting for an asp.net solution. I'm using the standalone Report Designer to test edit trdp files, and the html5 report viewer wrapper to display in the asp.net application (using IdentifierType="UriReportSource" and Identifier = "Dashboard.trdp").

Questions:

1. The sample trdp file I'm testing on has 9 charts/tables and they all specify the same DataSource object (a MySQL connection string is set and tested with a query). The query issued to the DB server takes around 5 seconds to return, and, given I have 9 charts linked to the DataSource, the report takes nearly 50 seconds to render. Is there a way to limit the DataSource refresh to only once and have the charts pickup from the DS?

2. In the same subject, I've tried to set a DataSet to be the datasource (ObjectDataSource) for the report, but I stumble upon the same issue in different snippets from your forums: The ReportSource data type is not DirectCast compatible with the InstanceReportSource type used by the html5 wrapper. It's been a mission to figure this out, and I wonder if I should just give up on the html5 version of the viewer and roll back to the previous version (apparently all snippet I've found appear to have no issues converting these data types).

Dim instanceReportSource As Telerik.Reporting.InstanceReportSource = DirectCast(reportViewer1.ReportSource, Telerik.Reporting.InstanceReportSource)

(and vice versa).

3. Given the data types incompatibility, is there a way for my code-behind to access the items in the report? The examples in article "Accessing Report Items Programmatically" are of no help, as apparently it uses the older version of the viewer (not html5).

Looking forward to hear from someone more experienced.
Thank you!

 

Stef
Telerik team
 answered on 28 Nov 2016
1 answer
1.0K+ views

I have been using the Report Viewer in order to create a report viewer to handle different kind of reports. I created a single report with the built-in option on Visual Studio 2015.

ReportSource rptDoc = new ReportSource();
rptDoc.IdentifierType = IdentifierType.TypeReportSource;
rptDoc.Identifier = "ReportLibrary.Sample";

 

In order to create the report. Such report does not receive any parameters, however I sill have this issue 

Unable to get report parameters.
Report 'ReportLibrary.Sample' cannot be resolved.

 

What I basically want is the following and it does not seem to have any sample or information on the whole documentation.

  • I want to use a Report and been able to set up its datasource to an objectdatasource which binds to a DataSet reading from an xml file/route.
  • Been able to set up this programmatically
  • The reportviewer must be set up on the backend side so I can enter or manipulate different reports.
  • Work on a ASP.Net web forms application.

 

Stef
Telerik team
 answered on 25 Nov 2016
1 answer
644 views
In my report I have a table that i calculating sum of values in a column. I want to be able to use the sum value in group footer as well. How can i reference the value in group footer? What is the way to store the value in variable for it to be able to be used at any other place in report. 
Katia
Telerik team
 answered on 25 Nov 2016
1 answer
121 views

Hi,
After switch to new PC and fresh instalation of Visual Studio 2015 update 3 and Telerik Reporting v. 9.1.15.731 I tried to modify DataSources in report. I have some Data Objects in the same project which uses DataObject attribute for classes as well as DataObjectMethod(DataObjectMethodType.Select) for methods. It is working on old PC without any problems. On fresh installed one when I selects "Show data components only" in data source wizard - it displays nothing. Of course project is builded up before check so assemblies are present.
Do you have any idea what can cause this problem? I spent already few hours on search with no luck so any ideas are welcome.

KAMIL
Top achievements
Rank 1
 answered on 25 Nov 2016
17 answers
283 views
Hi All,

We are using Telerik reporting control with subreports (master detailed kind of stuff) placed into design section of main report. When we export the report to PDF, we see exactly double the number of pages as displayed in the report.
Report is exported to pdf in a weired manner. First page displays main report data and next page displays only value from sub report.

The same problem is happening with the print option also.

Could you please help me out, digging this problem?

Thanks in Advance,
Rupali
doli
Top achievements
Rank 1
 answered on 25 Nov 2016
3 answers
208 views

In my ReportHeader there are a number of Fields that read from a SQL query. It works fine, as most of the fields are provided in the first row.

However there is a Field that require a condition in finding the right row. e.g.

SQL query:

CompanyName OfficeLocation  Name   Phone   EmployeeType

ABC                    Ontario            Tom      123         Contract

ABC                    Ontario            Ann       234        Full

ABC                    Ontario            May      456        Boss

 

ReportHeader:

Company Name: [=Fields.CompanyName]

Office : [=Fields.OfficeLocation]

Boss: [=Fields.Name] (Wont work, as it will display Tom and not May since Tom is the first row)

 

So how do I make it so it will display May in the Boss Field?

Pinkesh
Top achievements
Rank 1
 answered on 24 Nov 2016
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?