And the unlimited Display Only field method will not work as it will be subject to the same cell character limit as a Diary field.
Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Wednesday, March 15, 2017 3:13 PM To: [email protected] Subject: Re: Is it a good idea to eliminate the use of Diary Fields? ** John, BMC themselves went away from Diary fields for the most part (certainly in the work log process) many years ago....the down side, as you pointed out is storing the diary in individual records causes issues with reporting....this is easily worked around in a sufficiently advanced reporting tool allowing you to create sub-reports reporting all of the diary entries from a second table....the fact that they can't be pulled in the same entry is the only down side that I know of...with plenty of up sides. On Wed, Mar 15, 2017 at 3:06 PM, Reiser, John J wrote: ** Hello Listers, Is there a downside to replacing diary fields with a different method of capturing work activity? Since diary fields don’t show up in Mid Tier Web reporting I was looking into a way to replace the diary field for reporting. We actually have reports that get created in csv format for Excel that use the Diary. Occasionally we have a diary so large it breaks the cell character limit in Excel. I was contemplating using a table field to display records from a work activity form and then using either a join or some other temporary means to gather the activity into a report. Can I use an unlimited Display Only field to dump the diary during the report process? Is there a better mouse trap for collecting large amounts of data and reporting it? As always, thanks in advance. Thank you, --- John J. Reiser Building 760-J202 Remedy AR System Developer Senior Software Development Analyst Lockheed Martin - RMS Moorestown Region 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 "Where the Answers Are, and have been for 20 years"
