After configuring the AR System ODBC Driver to connect to crystal, I see an option right on the top of the list of all available tables, called 'Add Command'.
Was this option available in the previous versions of the AR System ODBC driver??? >From the looks of it you can write an SQL statement to create a view to report out of.. I'm beginning to think this might be useful to create a join view of tables to report out of without creating the join form within Remedy.. Has anyone used this option before? And what have you'll done using this option. I'd like to see what different reporting possibilities this option makes available to a report developer. Joe No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.9.0/852 - Release Date: 6/17/2007 8:23 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

