ReportViewer

// Navigate to a desired page
private void NavigateToPage(object sender, System.EventArgs e)
{
var desiredPage = 5;

// Check if the viewer can navigate to the page since the report may have fewer pages for example
if (this.reportViewer1.CanMoveToPage(desiredPage))
{
// By setting the property the viewer will automatically navigate to the page in question
this.reportViewer1.CurrentPage = desiredPage;
}
}

' Navigate to a desired page
Private Sub NavigateToPage(sender As Object, e As System.EventArgs)
Dim desiredPage = 5


' Check if the viewer can navigate to the page since the report may have fewer pages for example

If Me.ReportViewer1.CanMoveToPage(desiredPage) Then

' By setting the property the viewer will automatically navigate to the page in question

Me.ReportViewer1.CurrentPage = desiredPage
End If
End Sub

' Toggle the document map
Private Sub ToggleDocumentMapVisibility(sender As Object, e As System.EventArgs)
Me.ReportViewer1.DocumentMapVisible = Not Me.ReportViewer1.DocumentMapVisible
End Sub

// Toggle the document map
private void ToggleDocumentMapVisibility(object sender, System.EventArgs e)
{
this.reportViewer1.DocumentMapVisible = !this.reportViewer1.DocumentMapVisible;
}

' Navigate to the previous report in the history if available
Private Sub NavigateBack(sender As Object, e As System.EventArgs)
If Me.ReportViewer1.NavigateBackEnabled Then
Me.ReportViewer1.NavigateBack()
End If
End Sub

// Navigate to the previous report in the history if available
private void NavigateBack(object sender, System.EventArgs e)
{
if (this.reportViewer1.NavigateBackEnabled)
{
this.reportViewer1.NavigateBack();
}
}

' Navigate to the next report in the history if available
Private Sub NavigateForward(sender As Object, e As System.EventArgs)
If Me.ReportViewer1.NavigateBackEnabled Then
Me.ReportViewer1.NavigateBack()
End If
End Sub

// Navigate to the next report in the history if available
private void NavigateForward(object sender, System.EventArgs e)
{
if (this.reportViewer1.NavigateForwardEnabled)
{
this.reportViewer1.NavigateForward();
}
}

' Toggle the parameters area
Private Sub ToggleParametersAreaVisibility(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ParametersAreaVisible = Not Me.ReportViewer1.ParametersAreaVisible
End Sub

// Toggle the parameters area
private void ToggleParametersAreaVisibility(object sender, System.EventArgs e)
{
this.reportViewer1.ParametersAreaVisible = !this.reportViewer1.ParametersAreaVisible;
}

private void SetEmbeddedReportEngineConnection(object sender, System.EventArgs e)
{
this.reportViewer1.ReportEngineConnection = new Telerik.ReportViewer.Common.EmbeddedConnectionInfo().ConnectionString;
//if the ReportEngineConnection property is set to null or empty string, it will use the EmbeddedConnectionInfo by default.
}

Private Sub SetEmbeddedReportEngineConnection(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ReportEngineConnection = New Telerik.ReportViewer.Common.EmbeddedConnectionInfo().ConnectionString

'if the ReportEngineConnection property is set to null or empty string, it will use the EmbeddedReportEngineConnectionInfo by default.

End Sub

private void SetReportServerReportEngineConnection(object sender, System.EventArgs e)
{
this.reportViewer1.ReportEngineConnection = new Telerik.ReportViewer.Common.ReportServerConnectionInfo("http://reportserver:83", "user", "pass").ConnectionString;
}

Private Sub SetEmbeddedReportEngineConnection(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ReportEngineConnection = New Telerik.ReportViewer.Common.EmbeddedConnectionInfo().ConnectionString

'if the ReportEngineConnection property is set to null or empty string, it will use the EmbeddedReportEngineConnectionInfo by default.

End Sub

private void SetRestServiceReportEngineConnection(object sender, System.EventArgs e)
{
this.reportViewer1.ReportEngineConnection = new Telerik.ReportViewer.Common.RestServiceConnectionInfo("http://servicehost:83/api/reports", "authToken").ConnectionString;
}

Private Sub SetEmbeddedReportEngineConnection(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ReportEngineConnection = New Telerik.ReportViewer.Common.EmbeddedConnectionInfo().ConnectionString

'if the ReportEngineConnection property is set to null or empty string, it will use the EmbeddedReportEngineConnectionInfo by default.

End Sub

' Go to the middle of the report
Private Sub GoToMiddle(sender As Object, e As System.EventArgs)
Dim middlePage = Me.ReportViewer1.TotalPages / 2
Me.ReportViewer1.CurrentPage = middlePage
End Sub

// Go to the middle of the report
private void GoToMiddle(object sender, System.EventArgs e)
{
var middlePage = this.reportViewer1.TotalPages / 2;
this.reportViewer1.CurrentPage = middlePage;
}

' Switch to interactive mode
Private Sub SwitchToInteractive(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ViewMode = Telerik.ReportViewer.Wpf.ViewMode.Interactive
End Sub

// Switch to interactive mode
private void SwitchToInteractive(object sender, System.EventArgs e)
{
this.reportViewer1.ViewMode = Telerik.ReportViewer.Wpf.ViewMode.Interactive;
}

' Set the zoom mode to PageWidth
Private Sub ChangeZoomMode(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ZoomMode = Telerik.ReportViewer.Wpf.ZoomMode.PageWidth
End Sub

// Set the zoom mode to PageWidth
private void ChangeZoomMode(object sender, System.EventArgs e)
{
this.reportViewer1.ZoomMode = Telerik.ReportViewer.Wpf.ZoomMode.PageWidth;
}

' Set the zoom percent to a specific value
Private Sub ChangeZoomPercent(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ZoomMode = Telerik.ReportViewer.Wpf.ZoomMode.Percent
Me.ReportViewer1.ZoomPercent = 140
End Sub

// Set the zoom percent to a specific value
private void ChangeZoomPercent(object sender, System.EventArgs e)
{
this.reportViewer1.ZoomMode = Telerik.ReportViewer.Wpf.ZoomMode.Percent;
this.reportViewer1.ZoomPercent = 140;
}

// Stop rendering the report.
private void CancelRendering(object sender, System.EventArgs e)
{
this.reportViewer1.CancelRendering();
}

' Stop rendering the report.
Private Sub CancelRendering(sender As Object, e As System.EventArgs)
Me.ReportViewer1.CancelRendering()
End Sub

// Navigate to a desired page
private void NavigateToPage(object sender, System.EventArgs e)
{
var desiredPage = 5;

// Check if the viewer can navigate to the page since the report may have fewer pages for example
if (this.reportViewer1.CanMoveToPage(desiredPage))
{
// By setting the property the viewer will automatically navigate to the page in question
this.reportViewer1.CurrentPage = desiredPage;
}
}

' Navigate to a desired page
Private Sub NavigateToPage(sender As Object, e As System.EventArgs)
Dim desiredPage = 5


' Check if the viewer can navigate to the page since the report may have fewer pages for example

If Me.ReportViewer1.CanMoveToPage(desiredPage) Then

' By setting the property the viewer will automatically navigate to the page in question

Me.ReportViewer1.CurrentPage = desiredPage
End If
End Sub

// Opens the dialog to export the report
private void ExportReport(object sender, System.EventArgs e)
{
this.reportViewer1.ExportReport("PDF", null);
}

' Opens the dialog to export the report
Private Sub ExportReport(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ExportReport("PDF", Nothing)
End Sub

// Navigate to the previous report in the history if available
private void NavigateBack(object sender, System.EventArgs e)
{
if (this.reportViewer1.NavigateBackEnabled)
{
this.reportViewer1.NavigateBack();
}
}

' Navigate to the previous report in the history if available
Private Sub NavigateBack(sender As Object, e As System.EventArgs)
If Me.ReportViewer1.NavigateBackEnabled Then
Me.ReportViewer1.NavigateBack()
End If
End Sub

// Navigate to the next report in the history if available
private void NavigateForward(object sender, System.EventArgs e)
{
if (this.reportViewer1.NavigateForwardEnabled)
{
this.reportViewer1.NavigateForward();
}
}

' Navigate to the next report in the history if available
Private Sub NavigateForward(sender As Object, e As System.EventArgs)
If Me.ReportViewer1.NavigateBackEnabled Then
Me.ReportViewer1.NavigateBack()
End If
End Sub

// Opens the dialog to print the report
private void PrintReport(object sender, System.EventArgs e)
{
this.reportViewer1.PrintReport();
}

' Opens the dialog to print the report
Private Sub PrintReport(sender As Object, e As System.EventArgs)
Me.ReportViewer1.PrintReport()
End Sub

// Refresh the report with the current parameters
private void RefreshReport(object sender, System.EventArgs e)
{
this.reportViewer1.RefreshReport();
}

' Refresh the report with the current parameters
Private Sub RefreshReport(sender As Object, e As System.EventArgs)
Me.ReportViewer1.RefreshReport()
End Sub

// Opens the page setup dialog for the report
private void ShowPageSetup(object sender, System.EventArgs e)
{
this.reportViewer1.ShowPageSetupDialog();
}

' Opens the dialog to print the report
Private Sub ShowPageSetup(sender As Object, e As System.EventArgs)
Me.ReportViewer1.ShowPageSetupDialog()
End Sub

void reportViewer1_Error(object sender, Telerik.Reporting.ErrorEventArgs args)
{
if (args.Exception is System.Exception) // check for a specific exception
{
var message = args.Exception.Message;
// do something with the message and/or the
}
}

Private Sub reportViewer1_Error(sender As Object, args As Telerik.Reporting.ErrorEventArgs)
If TypeOf args.Exception Is System.Exception Then

' check for a specific exception


' do something with the message and/or the

Dim message = args.Exception.Message
End If
End Sub

void reportViewer1_ExportBegin(object sender, Telerik.ReportViewer.Common.ExportBeginEventArgs args)
{
if (true) // some logic here
{
// Cancel is false by default
args.Cancel = true;
}

switch (args.Format)
{
case "Excel":
// do something
break;
case "PDF":
// do something
break;
}
}

Private Sub reportViewer1_ExportBegin(sender As Object, args As Telerik.ReportViewer.Common.ExportBeginEventArgs)
If True Then

' some logic here


' Cancel is false by default

args.Cancel = True
End If

Select Case args.Format
Case "Excel"

' do something

Exit Select
Case "PDF"

' do something

Exit Select
End Select
End Sub

void reportViewer1_ExportEnd(object sender, Telerik.ReportViewer.Common.ExportEndEventArgs args)
{
if (null != args.Exception)
{
//some logic if report processing is not successful
}
else
{
//suppress the viewer SaveFileDialog and use your own
args.Handled = true;
var fileName = args.DocumentName;
var extension = args.DocumentExtension;
var filter = string.Format("{0} (*.{1})|*.{1}|All Files (*.*)|*.*",
fileName,
extension);

var saveFileDlg = new Microsoft.Win32.SaveFileDialog
{
Filter = filter,
FileName = fileName + "." + extension,
};

if (saveFileDlg.ShowDialog() == true)
{
try
{
using (var fs = new FileStream(saveFileDlg.FileName, FileMode.Create))
{
fs.Write(args.DocumentBytes, 0, args.DocumentBytes.Length);
}

//Optionally open the file
if (!string.IsNullOrEmpty(saveFileDlg.FileName))
{
System.Diagnostics.Process.Start(saveFileDlg.FileName);
}
}
catch (Exception)
{
//Handle exception
}
}
}
}

Private Sub reportViewer1_ExportEnd(sender As Object, args As Telerik.ReportViewer.Common.ExportEndEventArgs)

'some logic if report processing is not successful

If args.Exception IsNot Nothing Then
Else

'suppress the viewer SaveFileDialog and use your own

args.Handled = True
Dim fileName = args.DocumentName
Dim extension = args.DocumentExtension
Dim filter = String.Format("{0} (*.{1})|*.{1}|All Files (*.*)|*.*", fileName, extension)

Dim saveFileDlg = New Microsoft.Win32.SaveFileDialog() With { _
.Filter = filter, _
.FileName = fileName + "." + extension _
}

If saveFileDlg.ShowDialog() = True Then
Try
Using fs = New FileStream(saveFileDlg.FileName, FileMode.Create)
fs.Write(args.DocumentBytes, 0, args.DocumentBytes.Length)
End Using


'Optionally open the file

If Not String.IsNullOrEmpty(saveFileDlg.FileName) Then
System.Diagnostics.Process.Start(saveFileDlg.FileName)
End If

'Handle exception

Catch generatedExceptionName As Exception
End Try
End If
End If
End Sub

void reportViewer1_InteractiveActionEnter(object sender, Telerik.ReportViewer.Wpf.InteractiveActionEventArgs args)
{
var strB = new System.Text.StringBuilder();
strB.AppendLine("You have just entered an action area.");
strB.AppendLine("Action type: " + args.Action.GetType().Name);
strB.AppendLine("ReportItem name: " + args.Action.ReportItemName);
strB.AppendLine(string.Format("Mouse cursor position: {0}; Item bounds: {1}", args.CursorPos, args.Bounds));

Console.Out.WriteLine(strB.ToString());
}

' Handles the InteractiveActionEnter event
Private Sub reportViewer1_InteractiveActionEnter(sender As Object, args As Telerik.ReportViewer.Wpf.InteractiveActionEventArgs) Handles ReportViewer1.InteractiveActionEnter

Dim strB = New System.Text.StringBuilder()
strB.AppendLine("You have just entered an action area.")
strB.AppendLine("Action type: " + args.Action.[GetType]().Name)
strB.AppendLine("ReportItem name: " + args.Action.ReportItemName)
strB.AppendLine(String.Format("Mouse cursor position: {0}; Item bounds: {1}", args.CursorPos, args.Bounds))

Console.Out.WriteLine(strB.ToString())
End Sub

void reportViewer1_CustomInteractiveActionExecuting(object sender, Telerik.ReportViewer.Wpf.InteractiveActionCancelEventArgs args)
{
var strB = new System.Text.StringBuilder();
strB.AppendLine("ReportItem name: " + args.Action.ReportItemName);

var customAction = args.Action as Telerik.Reporting.Processing.CustomAction;
if (null != customAction)
{
foreach (var p in customAction.Parameters)
{
strB.AppendLine(string.Format("Parameter \"{0}\" value: {1}", p.Key, p.Value));
}
}

strB.AppendLine(string.Format("Mouse cursor position: {0}; Item bounds: {1}", args.CursorPos, args.Bounds));

MessageBox.Show(strB.ToString());
}

void reportViewer1_InteractiveActionExecuting(object sender, Telerik.ReportViewer.Wpf.InteractiveActionCancelEventArgs args)
{
var navigateToUrlAction = args.Action as Telerik.Reporting.Processing.NavigateToUrlAction;
if (null != navigateToUrlAction)
{
if (!navigateToUrlAction.Url.StartsWith("https"))
{
args.Cancel = MessageBox.Show("You are about to navigate to a non-secure page. Continue?", "Warning", MessageBoxButton.YesNo, MessageBoxImage.Warning) != MessageBoxResult.Yes;
}
}
}

' Handles the InteractiveActionExecuting event
Private Sub reportViewer1_CustomInteractiveActionExecuting(sender As Object, args As Telerik.ReportViewer.Wpf.InteractiveActionCancelEventArgs) Handles ReportViewer1.InteractiveActionExecuting

Dim strB = New System.Text.StringBuilder()
strB.AppendLine("ReportItem name: " + args.Action.ReportItemName)

Dim customAction = TryCast(args.Action, Telerik.Reporting.Processing.CustomAction)
If customAction IsNot Nothing Then
For Each p As KeyValuePair(Of String, Object) In customAction.Parameters
strB.AppendLine(String.Format("Parameter ""{0}"" value: {1}", p.Key, p.Value))
Next
End If

strB.AppendLine(String.Format("Mouse cursor position: {0}; Item bounds: {1}", args.CursorPos, args.Bounds))

MessageBox.Show(strB.ToString())
End Sub

' Handles the InteractiveActionExecuting event
Private Sub reportViewer1_CustomInteractiveActionExecuting(sender As Object, args As Telerik.ReportViewer.Wpf.InteractiveActionCancelEventArgs) Handles ReportViewer1.InteractiveActionExecuting

Dim strB = New System.Text.StringBuilder()
strB.AppendLine("ReportItem name: " + args.Action.ReportItemName)

Dim customAction = TryCast(args.Action, Telerik.Reporting.Processing.CustomAction)
If customAction IsNot Nothing Then
For Each p As KeyValuePair(Of String, Object) In customAction.Parameters
strB.AppendLine(String.Format("Parameter ""{0}"" value: {1}", p.Key, p.Value))
Next
End If

strB.AppendLine(String.Format("Mouse cursor position: {0}; Item bounds: {1}", args.CursorPos, args.Bounds))

MessageBox.Show(strB.ToString())
End Sub

void reportViewer1_InteractiveActionLeave(object sender, Telerik.ReportViewer.Wpf.InteractiveActionEventArgs args)
{
var strB = new System.Text.StringBuilder();
strB.AppendLine("You have just left an action area.");
strB.AppendLine("Action type: " + args.Action.GetType().Name);
strB.AppendLine("ReportItem name: " + args.Action.ReportItemName);
strB.AppendLine(string.Format("Item bounds: {0}", args.Bounds));

Console.Out.WriteLine(strB.ToString());
}

' Handles the InteractiveActionLeave event
Private Sub reportViewer1_InteractiveActionLeave(sender As Object, args As Telerik.ReportViewer.Wpf.InteractiveActionEventArgs) Handles ReportViewer1.InteractiveActionLeave

Dim strB = New System.Text.StringBuilder()
strB.AppendLine("You have just left an action area.")
strB.AppendLine("Action type: " + args.Action.[GetType]().Name)
strB.AppendLine("ReportItem name: " + args.Action.ReportItemName)
strB.AppendLine(String.Format("Item bounds: {0}", args.Bounds))

Console.Out.WriteLine(strB.ToString())
End Sub

void reportViewer1_PrintBegin(object sender, Telerik.ReportViewer.Common.PrintBeginEventArgs e)
{
if (true) // some logic here
{
// Cancel is false by default
e.Cancel = true;
}

//To prevent the Print Dialog from appearing, you should specify valid printer settings to this method.
if (true)
{
// Obtain the settings of the default printer
e.PrinterSettings = new System.Drawing.Printing.PrinterSettings();

// To suppress the Print dialogs. The standard print controller comes with no UI
e.PrintController = new System.Drawing.Printing.StandardPrintController();
}
}

Private Sub reportViewer1_PrintBegin(sender As Object, e As Telerik.ReportViewer.Common.PrintBeginEventArgs)
If True Then

' some logic here


' Cancel is false by default

e.Cancel = True
End If


' To prevent the Print Dialog from appearing, you should specify valid printer settings to this method.

If True Then

' Obtain the settings of the default printer

e.PrinterSettings = New System.Drawing.Printing.PrinterSettings()


' To suppress the Print dialogs. The standard print controller comes with no UI

e.PrintController = New System.Drawing.Printing.StandardPrintController()
End If
End Sub

void reportViewer1_PrintEnd(object sender, Telerik.ReportViewer.Common.PrintEndEventArgs e)
{
// suitable for logging and triggering other actions
}

Private Sub reportViewer1_PrintEnd(sender As Object, e As Telerik.ReportViewer.Common.PrintEndEventArgs)

' suitable for logging and triggering other actions

End Sub

void reportViewer1_RenderingBegin(object sender, Telerik.ReportViewer.Common.RenderingBeginEventArgs e)
{
if (true) // some logic here
{
// Cancel is false by default
e.Cancel = true;
}
}

Private Sub reportViewer1_RenderingBegin(sender As Object, e As Telerik.ReportViewer.Common.RenderingBeginEventArgs)
If True Then

' some logic here


' Cancel is false by default

e.Cancel = True
End If
End Sub

void reportViewer1_RenderingEnd(object sender, Telerik.ReportViewer.Common.RenderingEndEventArgs e)
{
// suitable for logging and triggering other actions
}

Private Sub reportViewer1_RenderingEnd(sender As Object, e As Telerik.ReportViewer.Common.RenderingEndEventArgs)

' suitable for logging and triggering other actions

End Sub

void reportViewer1_UpdateUI(object sender, System.EventArgs e)
{
// invoked whenever the viewer state is changed
}

Private Sub reportViewer1_UpdateUI(sender As Object, e As System.EventArgs)

' invoked whenever the viewer state is changed

End Sub

private void reportViewer1_ViewerToolTipOpening(object sender, Telerik.ReportViewer.Wpf.ToolTipOpeningEventArgs args)
{
if (args.ToolTip.Title.Contains("DoNotShow"))
{
args.Cancel = true;
}
else
{
args.ToolTip.Title = "The tooltip title is changed!";
args.ToolTip.Text += " (changed)";
}
}

' Handles the InteractiveActionLeave event
Private Sub reportViewer1_ViewerToolTipOpening(sender As Object, args As Telerik.ReportViewer.Wpf.ToolTipOpeningEventArgs) Handles ReportViewer1.ViewerToolTipOpening
If args.ToolTip.Title.Contains("DoNotShow") Then
args.Cancel = True
Else
args.ToolTip.Title = "The tooltip title is changed!"
args.ToolTip.Text += " (changed)"
End If
End Sub