Telerik Forums
Reporting Forum
3 answers
113 views

We're getting this message in our standard error output:

EagleServer.exe Information: 0 : Unit.DotsPerInch = 96

EagleServer.exe is our application.

 

This happens on the bold line below:

  using (XmlReader xmlReader = XmlReader.Create(new StringReader(entity.ReportDefinitionXml)))
                {
                    ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
                    report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
                }

 

The message in the standard error output causes our application to think that something failed. Is there any way we can prevent this from happening?

Ivan Hristov
Telerik team
 answered on 04 Jun 2020
2 answers
649 views

Hi!

I have a chart in my report where I print inspections that are divided between finished and unfinished. I get this data from a database field and at the end of my report I created another field called total that sums up all of these numbers. 
What I need to do next is to get the percentage of how many of these inspections are finished and unfinished, and for that I need to get the sum of each one of the fields and divide by the sum of all finished and unfinished inspections, what should be something like this:

= (((Sum(Fields.FinishedInsp))/((Sum(Fields.FinishedInsp))+(Sum(Fields.UnfinishedInsp))))-1)*100

But I noticed that Telerik always return 0 for a division between two Sum() functions instead of the actual value, any idea why am I getting 0 and how to fix the problem?


Noah
Top achievements
Rank 2
 answered on 04 Jun 2020
0 answers
81 views

HI,

 

I would like to allow my customers the ability to add and hide columns from reports made up of crosstab tables.

I have not been able to achieve this.

 

IS this possible on telerik report designer?

 

THANKS

Balen
Top achievements
Rank 1
 asked on 04 Jun 2020
0 answers
164 views

Hello, I am using an older version of the Telerik Reporting tool (R1 2017 SP2)  and in earlier versions than that I was able to get the values for parameters that were passed.

Code that passes and generates the report:

var typeReportSource = new Telerik.Reporting.TypeReportSource();
typeReportSource.TypeName = string.Format("ReportLogic.{0}, ReportLogic, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null", ReportName);
foreach (var Parameter in Parameters)
{
    typeReportSource.Parameters.Add(Parameter.Name, Parameter.Value);
}
 
var result = reportProcessor.RenderReport("PDF", typeReportSource, null);

 

Report code:

void QuoteRequest_ItemDataBinding(object sender, EventArgs e)
{
     var id = Convert.ToInt32(this.ReportParameters[0].Value);
 
      // Transfer the value of the processing instance of ReportParameter
      // to the parameter value of the sqlDataSource component
      using (var db = new PetaPoco.Database())
      {
                var pcqp = new Repository(db).GetAllDynamicFields(id);
      }
}

Before this was able to pull a value,

In the earlier versions this was able to pull a value from this.ReportParameters[0].Value. But when I updated to this version it would just pass back a null value. Is there a reason why this could have happened? 

Mark
Top achievements
Rank 2
 asked on 03 Jun 2020
4 answers
237 views

Hello Telerik,
We are not able to filter the Grouped data in Excel after exporting from Telerik Reports.
Grouping of data is done through CrossTab in Telerik reports.
A sample excel file is shared for your reference.
As you can see in the excel, i have grouoed the data based on COL1, COL2, COL3.
Now when i filter COL3 and select value as BAA, then it shows only row 1 data instead of showing rows 1,2,3 and 4
similarly when i filter COl2 and select XYZ, then it shows only row 10 data instead of showing rows 10,11,12,13,14,15,16,17,18
What am i missing here. Or is it the limitation in Excel exported from Telerik Reports

 

Sijeesh
Top achievements
Rank 1
Veteran
 answered on 03 Jun 2020
1 answer
251 views

Hi,

We have updated our Reporting dlls to R2 2020.
We use WebView inside UWP app to show HTML5 Report Viewer and Web Report designer. Currently, the report viewer is working fine but we have a problem with a web designer. We tested with a separate web page outside of UWP WebView using the Chrome browser and it is working fine. We also noticed, that the same thing which is working in a Chrome browser is not working on Microsoft Edge, it seems it is the same issue. Also everything is working fine in a new Chromium-based Microsoft Edge, it is working fine.
in summary:
- working fine for Chrome, Microsoft Edge (Chromium-based)
- not working on UWP WebView control, Microsoft Edge.
Definition of not working: the control is loading fine, but when I open the report it is not showing report. We debugged client-server communication and it is sending appropriate information from the server. The same server is used for all testings (UWP, Chrome, Edge).
Is it something missing with a new release, or is it know the issue, or did someone reported this already?


Thank you,

Neli
Telerik team
 answered on 02 Jun 2020
3 answers
532 views
I have 2 bool report parameters. If the user changes the one to true, i want the other one to automatically change to false and vice versa. Say the first boolean is report parameter 1 on the list and the other one is report parameter 2. By using the expressions, I have managed to change parameter 2 to the correct value when changing parameter 1's value, but I can't get it to work the other way around. Expression on par 1: =(Parameters.parameter2.Value=False) Expression on par 2: =(Parameters.parameter1.Value=False) If I remove the expression on parameter 2, it works up.
Todor
Telerik team
 answered on 01 Jun 2020
3 answers
89 views

Hi All,

 

I have created a report in visual studio with two static datasources on it for testing purposes while in development to ensure that the report shows the data correctly.  I have two one for the main report and then there is a table on the report which has another datasource.  If i preview the report everything works as i would expect.  I then have the following code to create the form and assign the datasources dynamically at runtime so that i can select the correct data from the mysql database based on users input.

Dim ReportViewer As New RadfrmReportViewer
           Dim NotificationReport As New rptDCN
           Dim strMainDataCommand As String = "SELECT * FROM tbldcns WHERE dcn_id = '" & lstDCNs.SelectedItem.Tag & "';"
           Dim strPartsDataCommand As String = "SELECT part_name FROM tbldcn_inc_prts WHERE dcn_id = '" & lstDCNs.SelectedItem.Tag & "';"
 
           Dim mysqlReportMainDataSource As New SqlDataSource(strMainDataCommand, strDBConnectionString)
           Dim mysqlReportPartsDataSource As New SqlDataSource(strPartsDataCommand, strDBConnectionString)
 
           NotificationReport.DataSource = mysqlReportMainDataSource
           NotificationReport.rpttblParts.DataSource = mysqlReportPartsDataSource
           NotificationReport.txtFooter.Value = "Printed on {Now()} By " & System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Replace(Environment.UserName, ".", " "))
 
           Dim DisplayReport As New InstanceReportSource
           DisplayReport.ReportDocument = NotificationReport
           ReportViewer.ReportViewer1.ReportSource = DisplayReport
           ReportViewer.ReportViewer1.ZoomMode = Telerik.ReportViewer.WinForms.ZoomMode.FullPage
           ReportViewer.ReportViewer1.RefreshReport()
 
           ReportViewer.Show()

 

However when i now run the application and run the code i am getting the error that's attached.

 

 

 

I have double checked the SQL strings and the connection string including copying and pasting them exactly into the static data sources and its still not working.  I'm sure that i am doing something wrong but i can't see what at all.  Please can someone assist me with this.

 

Also the strDBConnectionString variable is also used in several other locations including to populate a listcontrol which allows the user to select the item they wish to generate the report for and that is all working as expected.

I have also double checked the SQL and connection strings at runtime to ensure that they are populating correctly.

Thanks in advanced

Luke

Todor
Telerik team
 answered on 01 Jun 2020
1 answer
1.6K+ views

Hello,

Is there a way to make a part of the expression value as Bold in the Edit Expression window in Telerik reporting.

As shown in the screenshot, I need to format a piece of the expression to Bold font.

In the Edit expression for the Legend value "= Fields.LegendName + '  ' + Fields.TotalCnt"

I want something like 'ABC 30' where ABC is the Fields.LegendName and 30 is the Fields.TotalCnt

I need to make the value 30 as bold.

Neli
Telerik team
 answered on 01 Jun 2020
2 answers
131 views

I am using a Telerick graph inside my WPF application.  I am not seeing a way to enable scrolling either horizontal or vertical on the graph.  I am not using xaml. My report is called EmployeeReport (EmployeeReport.cs, EmployeeReport.Designer.cs, EmployeeReport.resx)  Just to review, my EmployeeReport.cs is implementing the interface Telerik.Reporting.Report.  The constructor of EmployeeReport.cs receives an IEnumerable which is applied as the datasource to the graph.  

The graph values change and the graph size is staying the same. All the items are getting mixed together.  

Summary, how do adjust the graph to be one size and scroll  both horizontal or vertical.

 

Rich Schone
Top achievements
Rank 1
Veteran
 answered on 29 May 2020
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?