Hello Listers, ARS 7.6.03 MS SQL Server 2005 VMWare Windows 2003 Enterprise
My question: Does anyone use Diary Fields anymore? I don't see a Diary field anywhere on the Incident form. I don't have access to the ITSM suite so I only know about the Incident form from a user perspective. I have something similar to the Incident Work History form. The difference is that I take the info from my "Work Activity" fields and push them to a Diary field in addition to pushing them to a Work Activity form. The customer wanted custom tagging added to each Diary entry. I'd rather not store the data twice so I was wondering if there is a way to use a display only field during report retrieval to table walk the Work Activity and use the concatenated rows as field data. I think I can do it for a report of one record from the parent form but what if the end user wants to report 2 or more parent records. I don't have access to Crystal Server or I would just do a sub-report. A join won't work because it would duplicate parent data fields for every Work Activity record. Any ideas are welcome. TIA, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature
