I am using DexExpress xtraReport in a DNN 5.5 Module. I have a RunReport.ascx which has a ReportViewer Control and Toolbar in it. The reports generate fine in DNN but when I click the page forward button it does not page forward. It just has the 'Loading...' message but nothing happens. This only occurs in DNN. In a regular ASPX with the same code it pages just fine.

 

I am using DexExpress xtraReport 10.2.

 

Attached is the code. It is very simple. Jquery has been enabled on the DNN Page.

 

Can you provide insight into what is causing the problem?

 

Thank you

Al Rosales

<%@ control language="C#" inherits="mGroomer.Modules.Reports.RunReport" autoeventwireup="true"

codebehind="RunReport.ascx.cs" %>

<%@ Register Assembly="DevExpress.XtraReports.v10.2.Web, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"

Namespace="DevExpress.XtraReports.Web" TagPrefix="dx" %>

<%@ register tagprefix="dnn" assembly="DotNetNuke" namespace="DotNetNuke.UI.WebControls" %>

<link rel="Stylesheet" href="Content/ie6.css" />

<link rel="Stylesheet" href="Content/Site.css" />

<link rel="Stylesheet" href="Content/PageBorders/styles.css" />

<script type="text/javascript" src="Scripts/jquery-1.4.1-vsdoc.js" />

<script type="text/javascript" src="Scripts/jquery-1.4.1.js" />

<script type="text/javascript" src="Scripts/jquery-1.4.1.min.js" />

<script type="text/javascript" language="javascript">

function ShowError(error) {

$(document).ready(function () { error); });

}

</script>

<div>

<table cellpadding="0" cellspacing="0" border="0" style="margin: auto">

<tr>

<td style="padding-left: 6px; padding-right: 6px;">

<dx:ReportToolbar ID="ReportToolbar1" runat="server" ReportViewer="<%# ReportViewer1 %>"

EnableViewState="False" Width="100%">

<Items>

<dx:ReportToolbarButton ItemKind='Search' ToolTip='Display the search window' />

<dx:ReportToolbarSeparator />

<dx:ReportToolbarButton ItemKind='PrintReport' ToolTip='Print the report' />

<dx:ReportToolbarButton ItemKind='PrintPage' ToolTip='Print the current page' />

<dx:ReportToolbarSeparator />

<dx:ReportToolbarButton Enabled='False' ItemKind='FirstPage' ToolTip='First Page' />

<dx:ReportToolbarButton Enabled='False' ItemKind='PreviousPage' ToolTip='Previous Page' />

<dx:ReportToolbarLabel Text='Page' />

<dx:ReportToolbarComboBox ItemKind='PageNumber' Width='65px'>

</dx:ReportToolbarComboBox>

<dx:ReportToolbarLabel Text="of" />

<dx:ReportToolbarTextBox IsReadOnly='True' ItemKind='PageCount' />

<dx:ReportToolbarButton ItemKind='NextPage' ToolTip='Next Page' />

<dx:ReportToolbarButton ItemKind='LastPage' ToolTip='Last Page' />

<dx:ReportToolbarSeparator />

<dx:ReportToolbarButton ItemKind='SaveToDisk' ToolTip='Export a report and save it to the disk' />

<dx:ReportToolbarButton ItemKind='SaveToWindow' ToolTip='Export a report and show it in a new window' />

<dx:ReportToolbarComboBox ItemKind='SaveFormat' Width='70px'>

<Elements>

<dx:ListElement Text='Pdf' Value='pdf' />

<dx:ListElement Text='Xls' Value='xls' />

<dx:ListElement Text='Xlsx' Value='xlsx' />

<dx:ListElement Text='Rtf' Value='rtf' />

<dx:ListElement Text='Mht' Value='mht' />

<dx:ListElement Text='Html' Value='html' />

<dx:ListElement Text='Text' Value='txt' />

<dx:ListElement Text='Image' Value='png' />

<dx:ListElement Text='Csv' Value='csv' />

</Elements>

</dx:ReportToolbarComboBox>

</Items>

</dx:ReportToolbar>

</td>

</tr>

<tr>

<td>

<table cellspacing="0" cellpadding="0" border="0">

<tr>

<td class="PageBorder_tlc" style="width: 10px; height: 10px;">

<div style="width: 10px; height: 10px; font-size: 1px">

</div>

</td>

<td class="PageBorder_t" style="width: 10px">

</td>

<td class="PageBorder_trc" style="width: 10px; height: 10px;">

<div style="width: 10px; height: 10px; font-size: 1px">

</div>

</td>

</tr>

<tr>

<td class="PageBorder_l">

</td>

<td style="background-color: white;" align="center" class="style1">

<dx:ReportViewer ID="ReportViewer1" Style="width: 100%; height: 100%; text-align: left"

runat="server" ClientInstanceName="ReportViewer1" EnableViewState="False">

</dx:ReportViewer>

</td>

<td class="PageBorder_r">

</td>

</tr>

<tr>

<td class="PageBorder_blc" style="width: 10px; height: 10px;">

</td>

<td class="PageBorder_b" style="width: 10px">

</td>

<td class="PageBorder_brc" style="width: 10px; height: 10px;">

</td>

</tr>

</table>

</td>

</tr>

<tr>

<td valign="top" style="padding-left: 6px; padding-right: 6px;">

<dx:ReportToolbar ID="ReportToolbar2" runat="server" ReportViewer="<%# ReportViewer1 %>"

EnableViewState="False" Width="100%">

<Items>

<dx:ReportToolbarButton ItemKind="Search" ToolTip="Display the search window" />

<dx:ReportToolbarSeparator />

<dx:ReportToolbarButton ItemKind="PrintReport" ToolTip="Print the report" />

<dx:ReportToolbarButton ItemKind="PrintPage" ToolTip="Print the current page" />

<dx:ReportToolbarSeparator />

<dx:ReportToolbarButton Enabled="False" ItemKind="FirstPage" ToolTip="First Page" />

<dx:ReportToolbarButton Enabled="False" ItemKind="PreviousPage" ToolTip="Previous Page" />

<dx:ReportToolbarLabel Text="Page" />

<dx:ReportToolbarComboBox ItemKind="PageNumber" Width="65px">

</dx:ReportToolbarComboBox>

<dx:ReportToolbarLabel Text="of" />

<dx:ReportToolbarTextBox IsReadOnly="True" ItemKind="PageCount" />

<dx:ReportToolbarButton ItemKind="NextPage" ToolTip="Next Page" />

<dx:ReportToolbarButton ItemKind="LastPage" ToolTip="Last Page" />

<dx:ReportToolbarSeparator />

<dx:ReportToolbarButton ItemKind="SaveToDisk" ToolTip="Export a report and save it to the disk" />

<dx:ReportToolbarButton ItemKind="SaveToWindow" ToolTip="Export a report and show it in a new window" />

<dx:ReportToolbarComboBox ItemKind="SaveFormat" Width="70px">

<Elements>

<dx:ListElement Text="Pdf" Value="pdf" />

<dx:ListElement Text="Xls" Value="xls" />

<dx:ListElement Text="Xlsx" Value="xlsx" />

<dx:ListElement Text="Rtf" Value="rtf" />

<dx:ListElement Text="Mht" Value="mht" />

<dx:ListElement Text="Html" Value="html" />

<dx:ListElement Text="Text" Value="txt" />

<dx:ListElement Text="Image" Value="png" />

<dx:ListElement Text='Csv' Value='csv' />

</Elements>

</dx:ReportToolbarComboBox>

</Items>

</dx:ReportToolbar>

</td>

</tr>

</table>

</div>

using DotNetNuke.Entities.Modules;

using DotNetNuke.Services.Exceptions;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using mGroomer.Reports.Reports;

using System.Data.SqlClient;

using System.Data;

using System.Text.RegularExpressions;

using DevExpress.XtraReports.UI;

using DevExpress.Data.Utils;

　

namespace mGroomer.Modules.Reports

{

partial class RunReport : PortalModuleBase

{

protected void Page_Load( object sender, EventArgs e )

{

string reportTypeName = Request.QueryString["type"];

string reportParametersString = Request.QueryString["param"];

try

{

var report = Activator.CreateInstance("mGroomer.Reports", reportTypeName).Unwrap() as IMGroomerReport;

if (report == null)

{

throw new Exception(string.Format("{0} Report not found.", reportTypeName));

}

var reportParameters = new List<SqlParameter>();

if (!string.IsNullOrEmpty(reportParametersString))

{

Regex regex = new Regex(";");

string[] requestParameters = regex.Split(reportParametersString);

regex = new Regex(",");

foreach (var requestParameter in requestParameters)

{

var parameterDescriptions = regex.Split(requestParameter);

Response.Write("<br> Parm Name: " + parameterDescriptions[0] + " SqlDbType: " + parameterDescriptions[1] + " Value: " + parameterDescriptions[2] + "<br /> ");

reportParameters.Add(new SqlParameter()

{

ParameterName = parameterDescriptions[0],

SqlDbType = Helper.GetDBType(parameterDescriptions[1]),

Value = parameterDescriptions[2],

Direction = ParameterDirection.Input

});

 

}

}

　

report.IniliazeReport(reportParameters);

ReportViewer1.Report = report as XtraReport;

}

catch (Exception ex)

{

Response.Write("<script> \"" + ex.Message.Replace("\r\n", "\" + \r\n \"") + "\");</script>");

Exceptions.ProcessModuleLoadException(this, ex);

}

}

}

}