Not sure if this will help - but I did sub-reports for certain things so I did not have to do join forms. I have a form that collects data from a vendor via email and those entries are tied to our help desk cases via the Case ID. When I did the sub-report - that was the link. So I can print a Report for a specific ticket with each corresponding entry in the other form.
Kim Olds Anne Arundel County Public Schools - Help Desk 410-222-5254 410-222-5611 fax -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, June 18, 2007 5:06 PM To: [email protected] Subject: ODBC Driver: AR System ODBC Driver version 7.x 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
