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?
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
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,
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
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.
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.
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?