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
| 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
Thread Tools Search this Thread Display Modes
  #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

Reply With Quote

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
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

All times are GMT -4. The time now is 08:18 AM.

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