Fields in Table from PostgreSQL Database missing when using Table in Crystal Report

Posted on 2012-03-22
Medium Priority
Last Modified: 2012-04-19
The table has 18 fields in the pg database.  Two of the fields are character varying (256).  When I bring the table into the database expert of Crystal, I only see 16 fields.  Is it because of the length?  

Thanks for your help.
Question by:dupree007
  • 2
  • 2
LVL 101

Assisted Solution

mlmcc earned 600 total points
ID: 37753607
Where are you looking at the list?

Is this on a new report or an existing report?


Accepted Solution

dupree007 earned 0 total points
ID: 37753617
It happens whether I create a new report and it true in my existing reports.

Author Comment

ID: 37753635
Ahh...it was a new field though.  I forgot to "Verify Database."  All set master mlmcc!  Thanks anyway!
LVL 101

Expert Comment

ID: 37753649
I thought it might be that but expected the new reports to show the field.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question