Also inside the Crystal Designer when you Set Location the ODBC use underscores must match the User Tools -> Options setting
Basically the Report setting must match the User tool setting. The ODBC use underscores optios determines wether the ODBC driver will convert non database characters in form and field names into an underscore. i.e. A form called "My:MainTicket" will be referenced as "My_MainTicket" when the ODBC use underscores option is selected and "My:MainTicket" when the option is not selected. The same goes for fields. A field called "Send Survey?" will be referenced in the report as "Send_Survey_" when the option is selected and "Send Survey?" when it is not. TIP ------- Just before the report Window Open action in the Active Link do a Run Process action to set the ODBC use underscores setting so it will match with what was used in the Crystal Reports definition. To set the option on thru code do: PERFORM-ACTION-SET-PREFERENCE 23235 1 To set the option off thru code do: PERFORM-ACTION-SET-PREFERENCE 23235 0 TIP ------- Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Wednesday, September 19, 2007 12:15 PM To: [email protected] Subject: Re: Crystal Reports problem (U) Hi Sandra, > Sounds like it could be an "ODBC Use Underscores" error > > Check your Windows Control Panel > Administrative Tools > Data Source > (ODBC) > AR System ODBC Data Source > Configuration Is the "Use > underscores" checked? > > Check Remedy > Tools > Options > Advanced Is the "ODBC Use > Underscores" checked? > > Which ever you use - underscores Yes or No - must be consistent > because your use of Crystal Reports with Remedy depends on this setting. Will check that tomorrow. BTW, what is the underscores thing? A workmate warned me. He said it caused some problems with crystal reports, when he activated the option. Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
