If you set the server to use preferences, and create preference records for each user with default values for reporting (server, port, RPC, use underscores), when they log in to the User Tool it will set their local options settings to the correct reporting values. If they log in on a different computer that also has a User Tool, it will do the same there, as long as they have not cleared them in the User Tool and saved that as an update to their server-based preference record. We have used this with no problems whatsoever on our current production 5.1.2 server since 2003. Once you get them to log in the first time using a preference server, the User Tool defaults to that behavior automatically. On the 7.x systems it will automatically set you to use the preference server even if you don't key it in by hand the first time, which I think was required on the 5.x system.
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Tuesday, April 29, 2008 2:05 PM To: [email protected] Subject: Re: Reporting in ITSM 7.0.1 ** The install created the DSN automatically. We do not have preferences set for any of the users. So I should have configure the server preference options and this would manage the login process without manually adding the User DSN? In a message dated 4/29/2008 11:48:29 A.M. Pacific Daylight Time, [EMAIL PROTECTED] writes: ** The User Tool installation _should_ have created the ODBC DSN with minimal configuration on each Windows desktop. Then if you create AR System User Preference records for all of your users (we create them with a custom filter) you can set the report server name AND PORT, and ODBC Use Underscores = Yes in the preference record. IF your server enforces preferences (ours does) - Preference Server Options: use This Server - then everyone who logs in to the User Tool picks up the preferences from the server and their reporting works properly without manually editing the DSN. They can change their preferences later and break them (several of our accounts lost theirs during multi-server testing), but at least they will get started with the correct settings. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Tuesday, April 29, 2008 1:40 PM To: [email protected] Subject: Reporting in ITSM 7.0.1 ** Hello All, To run reports in ITSM 7.0.1, our users open the "Report Console" - however when executing a report thru the Report Console for the first time the user received an error. To fix the error, I have been going into the Administrative Console of Windows, adding the User DSN by configuring the user's login name and password - is there better or easier way to fix this? After this person has been set up with the ODBC connection, they never need to configure this again and it works fine from this point on. However, we have between 500-700 users and there must be a better way than each person having to login via the ODBC connection and configure a User DSN. I thought of the System DSN was configured - then people should be able to login automatically - or is this resolved by adding "Reporting Admin" permission? _____ Need a new ride? Check out the largest site for U.S. used car listings at AOL Autos <http://autos.aol.com/used?NCID=aolcmp00300000002851> . __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _____ Need a new ride? Check out the largest site for U.S. used car listings at AOL Autos <http://autos.aol.com/used?NCID=aolcmp00300000002851> . __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
