Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| 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 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
  #1 (permalink)  
Old December 6th, 2005, 11:55 AM
Registered User
Join Date: Dec 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal reports (v8.5) returning blank fields

Hello folks,
I have a strange problem that keeps appearing with the crystal reports I'm writing.

My problem is that some fields return blank when the reports are run. At first, i found that it was happening when I used
formulas based on data (I.e a formula that is designed to ALWAYS return something returns no data at all e.g select case
with default case)
This was annoying enough.

But now, I've got a report which uses data from two separate databases (One is SQL, the other is a local access file)
and, even though the linking fields match exactly, the data drawn from the local access file is only sometimes displayed.

The tables are linked by postcode. The access database just has two fields: postcode and Objective area.
When you look up a postcode, you get which objective area its in - it should be that simple.
Theres no hidden whitespace at the end of either postcode field, and I've also turned on the 'Allow partial text matches' option
in the link options.

Can anyone help me work out why crystal reports keeps returning blank data for formulas and for this linked database data?

Thanks for your help folks


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Reports - hiding blank fields Gandalf_the_Grey Access 3 December 12th, 2006 07:58 PM
Crystal Reports v8 with SQL 2005 VBM2 VB Databases Basics 0 November 14th, 2006 09:04 AM
Blank fields - queries with many tables dvarrin Crystal Reports 0 February 1st, 2005 05:43 AM
Parameters fields coming up blank in report jjshah BOOK: Professional Crystal Reports for VS.NET 0 January 26th, 2005 03:19 PM
Crystal Reports, to occupy blank spaces singaravel Crystal Reports 1 September 22nd, 2004 02:13 AM

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