I have a process where I query SYSCOLUM to create a list of fields. In the list of fields I use the remarks field to create a hover over tooltip of the field description. In looking at the master file on the reporting server, this field is limited to 78 characters (but the Segment Description is 256 characters... wierd). I'm finding that a number of my descriptions are longer then 78 characters. Has anyone modified this file before? As far as I understand, this master is used all over the place by WF. I am nervous about the downstream affects if I change the remarks column to hold 256 characters. If anyone has any words of wisdom / caution on adjusting this master, it would be greatly appreciated.

Thanks!

This message has been edited. Last edited by: eric.woerle,

Eric,

Rather than use "REMARKS" column which is the holding column for the "Description", use "LONGDESC" instead which should give you 2048 bytes of description (if your data goes to that size!).

T

Thanks Tony!

I didn't see longdesc in the masterfile on the reporting server when I opened it up this morning. Now that I know what to look for, its there plain as day!

A pleasure Eric, it's something that I have used for a long time to do exactly that - tooltips

T

Hi Eric,

Just a thought, but how are you generating your tooltip? Are you applying a particular style that using SET POPUPDESC = ON would not provide?

I use a specific tooltip that provides additional details such as Alias, Usage, Actual as well as Longdesc which is why I am not using POPUPDESC. Might it provide your requirements without having to jump through hoops?

T

Tony,

This is a custom Guided Adhoc application. Think Report Assistant super lite. We worked with InfoBuild India to build it. Its basically written in JavaScript / JQuery. So we aren't using POPUPDESC for this. Although it seems thats a style sheet command I should take a closer look at it. We have three parts of the page that creates a list of fields and organizes them using the Accordion Style from JQuery to create folders etc. In the fex that creates the html, we just define the title attribute with the REMARKS field from syscolum (Now LONGDESC). We basically are holding the output as html and using a !ibi.fil to populate it in the appropriate pieces of the page.