Telerik Forums
Reporting Forum
0 answers
161 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
234 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
239 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
523 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
84 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
126 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
2 answers
602 views

I'm using the standalone Telerik Report Designer and I have to display items like below.

Let's say I have two tables Company, Employee.

 

CompanyName | NumOfEmployees | Location 

Google |  1,000 | United States

Apple | 900 | Unites States

Samsung | 700 | Korea

 

CompanyName | EmployeeName | Age

Google | James | 39

Google | Jane | 23

Apple | Catherine | 30

Samsung | Bob | 23

Samsung | Jully | 32

Samsung | Nicolas | 43

 

I wanna display like below

 

Google   |    United States   | 1,000 employees

         James |   39

         Jane    |   23

 

Apple     |    United States   | 900employees
         James |   39
         Catherine | 30

 

Samsung  |   Korea     | 1,000 employees

         Bob | 23

         Jully | 32
         Nicolas | 43

 

 

I have 2 stored procedures, one for company list and the other for employee list with the company name parameter.

How can I do this?

Donald McLean
Top achievements
Rank 2
 answered on 28 May 2020
18 answers
1.1K+ views
I've been experimenting using the stand alone report designer with an objectdatasource. After updating the ReportDesigner config file to include the assembly names, the only assemblies that appear are those that are created with the .net framework. Assemblies created with .net core are not visible. Is this correct behavior? Or is there something I need to add to the the .net core class library so they are visible?
Todor
Telerik team
 answered on 26 May 2020
2 answers
590 views
Hello,
I'm trying to use conditional formatting to uniquely format a whole row in a report. The condition I'm using is a property of the row itself, not of any particular value. In this case, the boolean property I'm using to determine whether to format the row is called, "IsSummaryRow".  If it's true, then I format the row.  The problem I'm coming across is when there are blank or missing values in the row (which is common), the conditional formatting doesn't get applied. The boolean property is not affected by the other values in the row. I'm using an object data source.
I've attached a screenshot so you can see what I mean. 
I'd appreciate your help.

Chris
Kieron
Top achievements
Rank 1
 answered on 25 May 2020
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?