Hello Kim, A colleague of mine tried sub-reporting too, and yes that does work. I however tried creating a join within the ARS and building a report out of that join.
I wonder what is better for performance? I tried to look at the performance meter on Crystal but with the amount of data we have on our systems as of now it might not be enough to give a good feel of what method may be better over the other.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Olds, Kimberly M Sent: Wednesday, June 27, 2007 1:31 PM To: [email protected] Subject: Re: ODBC Driver: AR System ODBC Driver version 7.x 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.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007 11:54 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
