Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal Report Viewer not showing all records Post Reply Post New Topic
Author Message
bigmac_025
Newbie
Newbie
Avatar

Joined: 02 Aug 2008
Location: United States
Online Status: Offline
Posts: 3
Quote bigmac_025 Replybullet Topic: Crystal Report Viewer not showing all records
    Posted: 02 Aug 2008 at 6:52pm

In VB.NET 2003 I am performing a simple query and returning the query results into a dataset.  I have set-up the dataset to be viewed in a Crystal Report.  When I perform the query the Report Viewer only displays 6 pages (one record per page) where there should be at least 300 records displayed.  Any ideas on why it won't display all records?  I have confirmed that the dataset contains all records.

Thanks
Tim
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 05 Aug 2008 at 12:07pm
Are you linking multiple tables from the dataset in the report, or is there just one table?  If you're linking tables, what kind of join are you using?  Do all of the tables have data for all records?
 
-Dell
IP IP Logged
bigmac_025
Newbie
Newbie
Avatar

Joined: 02 Aug 2008
Location: United States
Online Status: Offline
Posts: 3
Quote bigmac_025 Replybullet Posted: 08 Aug 2008 at 7:40am

I figured out the problem, I had the fields set in the header sections and not in the display sections.  Once I moved the fields everything displayed.

 

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.015 seconds.