Print Page | Close Window

Access DB Contents not Being Shown

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=384
Printed Date: 25 Apr 2024 at 9:39am


Topic: Access DB Contents not Being Shown
Posted By: pooba53
Subject: Access DB Contents not Being Shown
Date Posted: 22 Mar 2007 at 2:13pm
This is just weird...

I've already created a CrystalReport1 that is properly printing results from an Access database.

I created a CrystalReport2 that also accesses this database to print out different information. From the Field Explorer I did the drag and drop (just like in the first report) and I can do a "Browse Field Data..." on all of the report fields and they show the correct contents of my database.

When the report prints, nothing is shows up on ANY of my database fields! It's just plain strange. The formatting that is non-db related prints fine.

Any idea what the heck is going on? Any more information I can supply?



Replies:
Posted By: BrianBischof
Date Posted: 22 Mar 2007 at 2:38pm
Sounds like a 'weird quirk' in that you probably missed a simple step or you are joining two tables by the wrong field and no results are being returned. Maybe the record selection formula isn't right. Something simple like that related to pulling the data.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Posted By: pooba53
Date Posted: 22 Mar 2007 at 2:47pm
Ya' bloomin' smart guy!

I unlinked the two tables I was working with (Wizard must have done this) and all prints fine now.

I sure do thank you and I'm enjoying your book more than CR itself ;-)


Posted By: BrianBischof
Date Posted: 22 Mar 2007 at 2:59pm
Cool! I figured it would be something simple like that once you looked at it a second time. 

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>



Print Page | Close Window