Outgoing Email with AttachmentLisa, Is the output of that statement a 2 column output? If so you could build a database view from that statement, and then have a table field show the contents of that view and you could report from that view..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kemes, Lisa Sent: Monday, April 02, 2007 12:45 PM To: [email protected] Subject: Distinct Counts ** A customer would like to run reports on his form that includes distinct counts. In SQL this is easy (Select Building, count(Area_Code) from PBX_COST_MASTER group by building). How can I get this data extracted from a Form in Remedy? We do not have Crystal Reports yet (would that help?) We are using Remedy 6.3 patch 21. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.24/742 - Release Date: 4/1/2007 8:49 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
