Skip to Content
Former Member
Jul 31, 2009 at 09:12 PM

Dynamic field not refreshing lists of data from table



I need help.

I made a report with a dynamic field pulling from a specific table, connected by odbc in SQL.

The table is dated by another software without issues.

However, there was a point when the dynamic field was not showing correct records. For example, the field is supposed to allow the user to select the Purchase Order number being printed. Even though the purchase order is updated using the other software and the data is correct on the table when you make a select statement, the number showing on the prompt is not updating.

When I go thru a process in the other software to mark a record from that table as completed, that's the only time the prompt will show the correct PO numbers.

Am I missing something on the report?

What should I do or how do I narrow down the source of the issue.

I am using Crystal XI Release 2.

There's nothing in the report that is coded.