Editing Selection Values Crashes CR9

[jbhsuman]

CR9

I seem to be having a problem setting some values regardless if I am using the selection expert, creating a parameter or adding it to the selection formula. The problem seems to manifest itself when I make a change to the original parameter.

Example: Original values

{table.Field} in ["COPMT", "DEDPMT", "INSPMT", "OVRPMT", "SELFPAY"]

change to

{table.CODE} in ["2ndinspmt", "COPMT", "DEDPMT", "INSPMT", "OVRPMT", "SELFPAY"]

CR9 crashes when I try to add another value, in this case "2NDINSPMT". Subsequently, if I delete the entire parameter and then try to add it again in it's original form, CR9 still crashes.

I have also tried to choose a different field to filter on but this also crashes CR9.

I'm not sure if this is related, but when I edit the parameter and try to choose the selection values, even thought I have the correct table and field selected, CR9 does not display all the available field values.


Any suggestions would be appreciated.

Thanks

Joe

 

[Turkbear]

Hi,
As to the second part of your question: CR will only return a 'sample' of the data when you Browse the data in the formula editor..I am not sure how many ( or where it can be set, if anywhere).

I cannot figure out why your CR would crash under those circumstances, so no help for you main problem, sorry..

 

[jbhsuman]

Thanks for trying.

 

[synapsevampire]

I'd guess that you're using the wrong connectivty or driver to access you data (the wrong ODBC driver for instanc will cause errors, use the CR supplied ODBC whenever posible, not the database manufacturers driver).

Obviously what you're trying to do is common, so it's NOT a Crystal related problem, it's driver or install related.

Please post technical information, such as the database used and how you're connecting.

Or just try switching the type of connectivity (try native or a different ODBC driver).

-k