Telerik Forums
Reporting Forum
2 answers
212 views

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?

akin
Top achievements
Rank 1
 answered on 21 Jul 2015
1 answer
344 views

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?

Stef
Telerik team
 answered on 20 Jul 2015
3 answers
257 views
Hi,

I recently upgraded to Q1 2012 Telerik Reporting as well as Telerik RadControls for WPF, using the upgrade wizards provided. Once I got my application (previously built on Q3 2011) to compile, I was able to run the application. I'm using the WPF ReportViewer to load a report. The report managed to load correctly. However when I tried to set the Zoom Mode to Page Width or Whole Page, I encountered a problem of System.InvalidOperationException.

The additional information given by the exception is :

"Layout.measurement override of element 'Telerik.Windows.Controls.Primitives.LayoutTransformControl' should not return NaN values as its DesiredSize."

All the other zoom levels seemed ok... Previously with Q3 2011, the zoom was working fine.

Hope you can help me on this issue. Thank you very much for your time.
Stef
Telerik team
 answered on 20 Jul 2015
3 answers
378 views
Telerik Q3 2014
Visual Studio Ultimate 2013
MVC 5 Report Viewer

Report works locally fine, deploy to IIS 7.5 and get below error.
Internal Server Error
An error has occurred.
Access to th epath 'C\Windows\TEMP\ReportService\...\LastCheckTime
value.dat is denied.

I go to the server and delete the TEMP data then the report works again.

Why is this erorr occuring and what is the resolution. We cannot have random Telerik failures in production.

Stef
Telerik team
 answered on 20 Jul 2015
4 answers
416 views
I am receiving a System.NotSupportedException of "Adding or removing items from a 'HttpRouteCollection' is not supported. Please use a key when adding and removing items." when my application hits the ReportsControllerConfiguration.RegisterRoutes() method. 

Thank you for assistance in advance.
Stef
Telerik team
 answered on 20 Jul 2015
1 answer
225 views

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

Stef
Telerik team
 answered on 20 Jul 2015
1 answer
195 views

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

Stef
Telerik team
 answered on 20 Jul 2015
1 answer
114 views

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 ?​

Stef
Telerik team
 answered on 20 Jul 2015
1 answer
101 views

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?

 

Nasko
Telerik team
 answered on 20 Jul 2015
3 answers
72 views
I am trying to create a report that is structured like the attachment.   I have to fields Machine and Category that would be a header and then data pertaining to those 2 would be listed under.  Right now I have a sub report using a table.  I get the data from the DB and stuff into a datatable.any help is greatly appreciated. 
Nasko
Telerik team
 answered on 20 Jul 2015
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?