Within this report I want to view all hires within a date range, but rather than just seeing hires that start or end on a particular date, i want to view all live hires.
So for example, if a hire starts on 05/01/15 and ends on 25/01/15, i'm not able to see it if i search the start date as 10/01/15. Is there any way I can view live hires rather than hires that have started and finished within a certain date range?
Hi,
I've created trdx file with standalone report designer to user function "GetMonth(now.month)" in textbox
I've added report viewer like below code into codebehind onload;
Telerik.Reporting.UriReportSource uriReportSource = new Telerik.Reporting.UriReportSource();
uriReportSource.Uri = "Report1.trdx";
ReportViewer1.ReportSource = uriReportSource;
and i've added custom function
public static object GetMonth(int value)
{
return System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(value);
}
But it gives below error:
An error has occurred while processing TextBox 'textBox21': The expression contains undefined function call GetMonth().
Please help me, how can i call user custom function from trdx file on report viewer?
Hi Team,
Good Day!
I am using a Standalone Telerik Report and I want to set a new ObjectDataSource from a Dataset during run-time. But even how much I tried the report cannot retrieved or used the new ObjectDataSource that I set during run-time. Below is My Code. Please kindly help assist on which part of my code do i get wrong or is this possible in Telerik Report?
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Try
Me.Text = CurrReport.FileName
Dim uriReportSource As New Telerik.Reporting.UriReportSource()
uriReportSource.Uri = IO.Path.GetDirectoryName(Diagnostics.Process.GetCurrentProcess().MainModule.FileName) & "\Reports\" & CurrReport.ReportName
ReportViewer1.Cursor = Windows.Forms.Cursors.Default
ReportViewer1.ReportSource = SetUpReportSource(uriReportSource)
ReportViewer1.RefreshReport()
Catch ex As Exception
Glenfield.Common.HandleError(ex)
End Try
End Sub
Public Function SetUpReportSource(sourceReportSource As ReportSource) As ReportSource
Try
Dim uriReportSource = DirectCast(sourceReportSource, UriReportSource)
Dim reportInstance = DeserializeReport(uriReportSource)
ValidateReportSource(uriReportSource.Uri)
Me.SetConnectionString(reportInstance)
Return CreateInstanceReportSource(reportInstance, uriReportSource)
Catch ex As Exception
Glenfield.Common.HandleError(ex)
End Try
End Function
Public Function DeserializeReport(uriReportSource As UriReportSource) As Report
Dim m_Report As Telerik.Reporting.Report = New Telerik.Reporting.Report()
Dim settings = New System.Xml.XmlReaderSettings()
settings.IgnoreWhitespace = True
Try
Using xmlReader = System.Xml.XmlReader.Create(uriReportSource.Uri, settings)
Dim xmlSerializer = New Telerik.Reporting.XmlSerialization.ReportXmlSerializer()
Dim report = DirectCast(xmlSerializer.Deserialize(xmlReader), Telerik.Reporting.Report)
m_Report = report
Return m_Report
End Using
Catch ex As Exception
Glenfield.Common.HandleError(ex)
End Try
End Function
Public Sub ValidateReportSource(value As String)
Try
If value.Trim().StartsWith("=") Then
Throw New InvalidOperationException("Expressions for ReportSource are not supported when changing the connection string dynamically")
End If
Catch ex As Exception
Glenfield.Common.HandleError(ex)
End Try
End Sub
Public Sub SetConnectionString(reportItemBase As ReportItemBase)
Try
Dim objectDataSource As New Telerik.Reporting.ObjectDataSource()
objectDataSource.DataSource = CurrReport.m_CurrDataset
objectDataSource.DataMember = "rptData"
If reportItemBase.Items.Count < 1 Then
Return
End If
If TypeOf reportItemBase Is Report Then
Dim report = DirectCast(reportItemBase, Report)
report.DataSource = objectDataSource
'For Each item As Telerik.Reporting.ReportItemBase In reportItemBase.Items
' 'recursively set the connection string to the items from the Items collection
' SetConnectionString(item)
' 'set the drillthrough report connection strings
' Dim drillThroughAction = TryCast(item.Action, NavigateToReportAction)
' If drillThroughAction IsNot Nothing Then
' Dim updatedReportInstance = Me.SetUpReportSource(drillThroughAction.ReportSource)
' drillThroughAction.ReportSource = updatedReportInstance
' End If
' 'Covers all data items(Crosstab, Table, List, Graph, Map and Chart)
' If TypeOf item Is DataItem Then
' Dim dataItem = DirectCast(item, DataItem)
' dataItem.DataSource = objectDataSource
' Continue For
' End If
'Next
For Each WkFItem As Microsoft.Reporting.WinForms.ReportParameter In CurrReport.ReportParameters
If report.ReportParameters.Contains(WkFItem.Name) Then
report.ReportParameters(WkFItem.Name).Value = WkFItem.Values(0)
End If
Next
report.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Custom
report.PageSettings.Margins.Left = New Unit(0.25, UnitType.Inch)
report.PageSettings.Margins.Right = New Unit(0.25, UnitType.Inch)
report.PageSettings.Margins.Top = New Unit(0.25, UnitType.Inch)
report.PageSettings.Margins.Bottom = New Unit(0.25, UnitType.Inch)
If Glenfield.Globals.PaperSize = PrintPaperSize.Letter Then
If CurrReport.Orientation = PrintOrientation.Portrait Then
report.PageSettings.PaperSize = New SizeU(New Unit(11, UnitType.Inch), New Unit(8.5, UnitType.Inch))
Else
report.PageSettings.PaperSize = New SizeU(New Unit(8.5, UnitType.Inch), New Unit(11, UnitType.Inch))
End If
report.PageSettings.PaperKind = PaperKind.Letter
Else
If CurrReport.Orientation = PrintOrientation.Portrait Then
report.PageSettings.PaperSize = New SizeU(New Unit(11.69, UnitType.Inch), New Unit(8.25, UnitType.Inch))
Else
report.PageSettings.PaperSize = New SizeU(New Unit(8.25, UnitType.Inch), New Unit(11.69, UnitType.Inch))
End If
report.PageSettings.PaperKind = PaperKind.A4
End If
End If
Catch ex As Exception
Glenfield.Common.HandleError(ex)
End Try
End Sub
Private Function CreateInstanceReportSource(report As IReportDocument, originalReportSource As ReportSource) As ReportSource
Dim instanceReportSource = New InstanceReportSource() With { _
.ReportDocument = report _
}
Try
instanceReportSource.Parameters.AddRange(originalReportSource.Parameters)
Catch ex As Exception
Glenfield.Common.HandleError(ex)
End Try
Return instanceReportSource
End Function
Hello,
When I run a report telerik after making changes in the X-Axis Rotation Label to better fit them in the chart of type "Chart", the change isn't verified and returns to the default setting.
How is this possible? Is there any step that should follow?
I'm using 6.1.12.823 version of telerik reporting integrated with Visual Studio.
Best Regards,
Emídio Teixeira
Hi Everyone
ASP MVC project.
I use Q1 2015 SP1 (9.0.15.324)
I have page with Html.TelerikReporting().ReportViewer()
There are parameters which user can set. I want to crate
functionality which will send email with attached pdf report from this ReportViewer.
What the best way to implement this functionality? Could
I export Report on HTML page array bytes (PDF) in JavaScript ?
Hi,
I need some help retrieving the active set report parameters from a web report viewer.
I have a aspx page with the report viewer on it, in addition to the viewer I also have a custom email button. When the user clicks on that button I would like to sent a mail with the current report as a attachment. Problem with that is that when the user changes a few report parameters I have to apply those changes to report before I create the PDF file.
The creation of the PDF file I'm doing with the report processor:
Dim
reportProcessor
As
New
Processing.ReportProcessor()
Dim
deviceInfo
As
New
Hashtable()
Dim
instanceReportSource = reportViewer.ReportSource
Dim
result
As
Processing.RenderingResult = reportProcessor.RenderReport(
"PDF"
, instanceReportSource, deviceInfo)
Problem with the code above is that the parameters of the report viewer report source are the original parameters and not the ones who the user has changed.
Anyone suggestions how I can send the displayed report as a PDF attachment in a mail?