Click here to Skip to main content
15,887,683 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi
I need to disable excel export in Report viewer in asp.net. But error persist. I did debug, Error is "Object reference not set to an instance of an object" in this lien
" Dim ListRenderingExtensions As System.Reflection.MethodInfo = m_previewService.FieldType.GetMethod("ListRenderingExtensions", Flags)"


Please help me

Regards

Maideen

VB
Protected Sub DisableFormat(ByRef viewer As ReportViewer, ByVal formatName As String)

        Const Flags As System.Reflection.BindingFlags = System.Reflection.BindingFlags.NonPublic + System.Reflection.BindingFlags.Public + System.Reflection.BindingFlags.Instance
        Dim m_previewService As System.Reflection.FieldInfo = viewer.LocalReport.GetType().GetField("m_previewService", Flags)
        Dim ListRenderingExtensions As System.Reflection.MethodInfo = m_previewService.FieldType.GetMethod("ListRenderingExtensions", Flags)
        Dim previewServiceInstance As Object = m_previewService.GetValue(viewer.LocalReport)
        Dim extensions As IList = ListRenderingExtensions.Invoke(previewServiceInstance, Nothing)
        Dim name As System.Reflection.PropertyInfo = extensions(0).GetType().GetProperty("Name", Flags)

        Dim extension As Object

        For Each extension In Extensions
            If (String.Compare(name.GetValue(extension, Nothing).ToString(), formatName, True) = 0) Then
                Dim m_isVisible As System.Reflection.FieldInfo = extension.GetType().GetField("m_isVisible", System.Reflection.BindingFlags.NonPublic + System.Reflection.BindingFlags.Instance)
                m_isVisible.SetValue(extension, True)
                Dim m_isExposedExternally As System.Reflection.FieldInfo = extension.GetType().GetField("m_isExposedExternally", System.Reflection.BindingFlags.NonPublic + System.Reflection.BindingFlags.Instance)
                m_isExposedExternally.SetValue(extension, True)
                Exit For
            End If
        Next extension


    End Sub

    Protected Sub ReportViewer1_PreRender(sender As Object, e As EventArgs) Handles ReportViewer1.PreRender
        Call DisableFormat(Me.ReportViewer1, "Excel") ' Disable EXCEL format
    End Sub
Posted
Updated 5-Dec-14 3:30am
v2

1 solution

first check m_previewService.FieldType is not null and proceed with GetMethod call
 
Share this answer
 
Comments
Maideen Abdul Kader 5-Dec-14 9:33am    
Hi Damith
Thank you for prompt reply

Where to check ? I have tried, error is same

maideen

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900