Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Report not returning Data Post Reply Post New Topic
Author Message
Logle0917
Newbie
Newbie


Joined: 21 Jul 2011
Location: United States
Online Status: Offline
Posts: 14
Quote Logle0917 Replybullet Topic: Report not returning Data
    Posted: 25 Jul 2011 at 8:28am
I have a CR 2008 that was updated from CR 8 it worked then doesn't now.  This is on an Oracle 10.2.0.5 db.  There are 12 tables in this report.  I have tried recreating the Report from scratch but nothing pulls. I have tried putting in one table at a time and pulling the fields that I need. I get data back. So I know that it is connectected to the db but when all tables are put together no data. I even took all the formulas out and only used a date parameter query and no data came back.  Any suggestions would be greatly appreciated.
 
Lisa
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet Posted: 25 Jul 2011 at 12:37pm
You need to check for nulls.They will stop a report whenever they are encountered.You might also try checking the "convert nulls to default"and see if it populates then.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 26 Jul 2011 at 10:41am
You also might need to look at changing some or all of your joins to outer joins.  If you're joining to at table that may or may not have data based on the join, you need to make this an outer join.
 
-Dell
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.016 seconds.