Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 10th, 2004, 08:32 PM
Registered User
 
Join Date: Dec 2004
Location: , , USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default crystalreportviewer and paging

Hi everyone,

I am trying to use crystal report in asp.net. reports first page is displayed successfully but when I go to the next page report is not displayed but instead a report viewer control is displayed. If I try to refresh the report then also the report viewer control is displayed. Only the first page works fine. I was wondering if there is any paging control in crystalreportviewer.
This is the code that I am using
Dim oConnection As New SqlClient.SqlConnection("server=(local); database = test; Trusted_connection=yes ")
oConnection.Open()
Dim contentType As String
Dim oCommand As New _
SqlClient.SqlCommand("select * from tmpRptCheckRegister", oConnection)


Dim ds As New DataSet()

Dim oDataAdapter As New SqlClient.SqlDataAdapter(oCommand)

oDataAdapter.Fill(ds, "oClaims")

Dim rpt As New CrystalReport1()
rpt.SetDataSource(ds.Tables("oClaims"))
CrystalReportViewer1.ReportSource = rpt

This code works fine because data is coming in the dataset and first page is displayed sucessfully. I tried to keep this code inside the isnotpostback statment and also outside the if isnotpostback statemnet. It shows the crystalreportviewer if it is inside the If isnotpostback statement and it keeps on showing page 1 after refresh or when I try to go to next page when I keep this code outside the if notpostback statement.

Any help will be greatly appreciated.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paging in CrystalReportViewer rakeshvc Crystal Reports 1 May 19th, 2014 06:18 AM
DB recordset paging using ajax paging? kumiko Classic ASP Basics 0 May 26th, 2008 10:23 AM
two reports in one CrystalReportViewer sali Crystal Reports 2 August 7th, 2007 12:29 AM
CrystalReportViewer paging problem AVeldkamp Crystal Reports 13 August 4th, 2006 03:19 AM
crystalreportviewer and paging vinki General .NET 0 December 10th, 2004 08:33 PM



All times are GMT -4. The time now is 05:52 AM.


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