Crystal Report Pro shows only 130 fields in large table 
Author Message
 Crystal Report Pro shows only 130 fields in large table

Actually, I found out my problem was stemming from the fact that the report
was developed on an earlier version of the table when it had only 130
fields.  Since then, 16 fields had been added.  You would think that simply
refreshing the database links to the report would work. Apparently, this
ancient version of Crystal stores the table structures in the report.  It
also will not (at least I can't figure out how) use query objects in Access
2.0 as the basis for a report.  Later versions of Crystal (4.6) will do
this. Well, now my problem is I get "The PDQQBE.DLL cannot be opened.
Please check its configuration." when I try to re-add the newer database
file to the report.  Then it proceeds to tell me that the Access database
file I am using isn't a valid data file.  Yeah, right.  The only reference
to this problem I have found in dejanews is someone solving it by checking
their network permissions.  This report I have runs locally and the database
is local (running on 98, not NT).  Anybody know what the hell to do now??



Sun, 01 Jul 2001 03:00:00 GMT  
 Crystal Report Pro shows only 130 fields in large table

Open the report in the designer and go to Database/Verify Database you will
get a message for each table in the report that has changed click OK and
save the report and now it will show all of the fields.  Note you need to do
this everytime the tables or indexes are changed. While this may seem
onerous Crystal is accessing your data without you having to have Access or
what ever database engine you are using. So it needs to store the table
structure in the report.

Wed, 04 Jul 2001 03:00:00 GMT  
 [ 4 post ] 

 Relevant Pages 

1. Formula field to table field name (Crystal Reports 8)

2. Crystal Reports 3/VB4 Field too large?!!!

3. Crystal Reports 8.5 Truncates Varchar fields larger then 255 characters

4. HELP: table links in Crystal Reports Pro 4.6.1

5. HELP: table links in Crystal Reports Pro 4.6.1

6. Crystal Reports - Empty Data Fields Don't Show

7. Print Char$(130)

8. RegExp ignores ASCII characters btwn 130 and 159

9. Crystal Report cannot see new field that is added to MS Access table

10. Crystal Reports - Fields from linked Access Tables ??

11. Help!!! Crystal Reports, Access table with OLE fields

12. pass name of table fields to Crystal report **


Powered by phpBB® Forum Software