Home » Developer & Programmer » Reports & Discoverer » Set individual preferences for a specific user
Set individual preferences for a specific user [message #179464] Tue, 27 June 2006 09:34 Go to next message
serafo
Messages: 24
Registered: May 2006
Junior Member
Hello.
I am trying to set individual preferences for a specific user.
The user Login is HAMELO and the DataBase is DWHDES1

I am using the following command to change the number of columns per page :

dis51pr -user HAMELO@DWHDES1 -setpref "Application" "ColsPerPage" 50


Doesn't work! Viewer still shows only 6 Columns! Please help me..!!



Thanks
Re: Set individual preferences for a specific user [message #179565 is a reply to message #179464] Wed, 28 June 2006 01:06 Go to previous message
jowahl
Messages: 82
Registered: May 2006
Member
the only way i know is suppressing the columns in the report with format triggers:

for every column create a format trigger like this:

FUNCTION <functionname> RETURN BOOLEAN IS
BEGIN
IF USER = <username>
RETURN (FALSE);
ELSE
RETURN (TRUE);
END IF;
END;
Previous Topic: Reports in pdf format
Next Topic: Matrix Report
Goto Forum:
  


Current Time: Sun Jun 30 11:25:53 CDT 2024