S/LIST Reporter (OpenInsight 16-Bit Specific)
At 13 MAR 2002 03:13:55PM S Bell wrote:
Anyone know a way to remove some of the fields from the list of Available Ccomumns in S/List?
Some of the fields in the data file are for things the user doesn't need or know about. When they try to create a query or a report in S/List, they would like not to see these extra fields appear in the Available Columns list. Something like you could control the files Easy Writer would list in ARev. Althought I never knew of any way to weed out any of the fields on Easy Writer's Avalable Columns either.
Any ideas or even ways to gray out the ones they shouldn't use?
Steve Bell
At 13 MAR 2002 04:26PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
It did exist in EasyWriter I believe and it does exist in S/List. It's sort of a developer 'hidden feature'…
SList_Security
Common /SList_Security/ Tables@, Columns@, Options@
Tables@
An @Fm delimited list of the tables the user should be given access to.
Columns@
An array containing one element per table field mark delimited with an @Vm delimited list of columns for the corresponding table. If this list of columns is null (or ?ALL?), then all columns for the table will be displayed.
Options@
An @Vm delimited variable containing the options for SList 97. There are currently two available as follows :- (They should be in UPPER case.)
NOSYS If Tables@ is not set then this option suppresses the display of any tables beginning SYS from all table dropdowns
NOXREF If Columns@ is not set then this option suppresses the display of any columns ending _XREF from all column dropdowns.
World Leaders in all things RevSoft
At 13 MAR 2002 07:46PM S Bell wrote:
I've looked around but can't seem to find where any of these things are. Is this an easy thing to do or is it kind of touchy. Kinda sounds like a REV MEDIA MAP.
At 13 MAR 2002 07:59PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
This is a labelled common area you need to set somewhere in your system before S/List is invoked so it involves a bit of programming sorry. Upcoming releases will make this entry window driven.
World Leaders in all things RevSoft