Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
|
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 30th, 2008, 06:01 AM
Authorized User
 
Join Date: Nov 2006
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Somesh
Default Problem with PAGING for Report Viewer

Hi,

I am working with SQL Server reporting Service 2005. I have some local report(RDLC file). A small pice of code loading the reports into a page within a Report Viewer.

I want to add the paging option into that report viewer. How to do?

Here I am giving the code for report viewer.

ASPX Page:-
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ReportViewer.aspx.cs" Inherits="WebApp_ReportViewer" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Width="855px" SizeToReportContent="True">
</rsweb:ReportViewer>

</div>
</form>
</body>
</html>
The code os ASPX.CS page:-

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using QSNet.Engine.UI;
using QSNet.Utility;
using QSNet.Engine;
using System.Collections.Generic;
using QSNet.Engine.Model;
using QSNet.Security;
using Infragistics.WebUI.UltraWebGrid;
using QSNet.Model.Student;
using QSNet.Business.Student;
using Microsoft.Reporting.WebForms;
using System.ComponentModel;
public partial class WebApp_ReportViewer : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//To Do :- calling the load report function
LoadReport();
//To Do :- getting the report data from object named as source which has been send from previous page
object source = Session["BissunessObject"];
//To Do :- display the report
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet2_SP_STUD_STUDENT_Address ", source));
//ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DS_STUD_STUDENT", source));
// ReportViewer1.Page.LoadComplete;
}
private void LoadReport()
{

ReportViewer1.LocalReport.EnableExternalImages = true;
//To Do :- Getting the report name which has been send from previous page.
string strReportFileName = Request.QueryString["rptName"];
//To Do :- Display the Page title.
ReportViewer1.Page.Title = Request.QueryString["rptTitle"];
//To Do :- Load the report viewer in local mode
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("./Reports/Student/AddressLabel_Without_StudentName.rdlc");
//string Path = "./Reports/" + strReportFileName;
//ReportViewer1.LocalReport.ReportPath = Server.MapPath(Path);
LocalReport lr = ReportViewer1.LocalReport;
lr.ReportPath = Server.MapPath("./Reports/Student/AddressLabel_Without_StudentName.rdlc");
//lr.ReportPath = Server.MapPath(Path);
ReportViewer1.LocalReport.DataSources.Clear();
}
}


Now please tell me how to add the Paging for the report viewer?

My mail ID:- csomesh@bodeninc.com

Somesh Chatterjee
__________________
somesh chaterjee





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with crystal activex report viewer NagarajuK Crystal Reports 1 March 17th, 2008 06:57 PM
Problem with Paging in Report Viewer Probleminfinity ASP.NET 3.5 Professionals 0 November 12th, 2007 12:11 PM
Crystal Report Viewer Control problem ^^" aekpong Pro VB Databases 5 June 16th, 2006 02:50 AM
Crystal Report (9) Viewer Problem Kaustav VB Components 1 October 30th, 2005 07:02 PM
MS Acess 2000 Report Paging Problem socoolbrewster Access 9 February 13th, 2004 10:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.