Dynamic field not refreshing lists of data from table

[Former Member]

Hi,

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.

Thanks!

[former_member11696]

The issue is until the data is committed to the DB crystal can not see it. If you can enable Dirty Reads in the DB then CR will display the info. But dangerous enabling this as you will get data for all records, even those marked to be deleted.

[Former Member]

Check whether you have scheduled the List of Values in Business View manager. If so clear the instance so that you will get the updated values.

Regards,

Raghavendra.G

[Former Member]

Thanks for the reply... sorry i did not clarify..

I am using Crystal XI release 2. I am not using Business View.

I just created a dynamic parameter and the report connects to SQL using ODBC. The software that updates the tables in the db is correctly updating it (so there is no corrupted data).. however, somehow, Crystal is not refreshing the list that prompts the user because of that dynamic parameter.

I hope that clarifies it a bit.

Thanks!!!