Print Page | Close Window

Report not returning Data

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13866
Printed Date: 20 Apr 2025 at 1:39pm


Topic: Report not returning Data
Posted By: Logle0917
Subject: Report not returning Data
Date 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


Replies:
Posted By: CircleD
Date 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.

Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window