I have 2 issues I'm trying to overcome.
First, occasionally Excel loses the Jet Report add-in and it must be re-added manually. This happens on Office 2003 and 2007. So far no data on 2010. Anyone come across that?
Second, I have 30+ users on 2 terminal servers and I have to log in as each of them on each server and configure them manually for Jet Reports. That's over 60 logins and configurations and with the recent upgrade to Office 2010 I'd like to automate everything I can.
How can I automtically set up each user, and any new user?
Server 2003. One is 32 bit the other is 64 bit.
Office 2010
Jet Reports 2010
Thanks!
Date
Votes
9 comments
-
Jet Reports Historic Posts Hi,
Unfortunately, we have never figured out a way to keep Excel from losing the Jet add-in on the machines where that happens. It definitely doesn't happen to most people, but on some machines it just seems to happen. You could try writing a login script which either runs the Jet activator silently or adds the Excel Jet add-in registry key manually for your users on login and see if that helps (the Excel add-in registry keys are in (HKCU\Software\Microsoft\Office\14.0\Excel\Options\OPEN).
One thing that may help you as far as configuring users is the new Centralized Data Sources feature in Jet Reports 2010 R2 (or Jet Reports 2011 which was just released). This feature allows you to create a SQL Server database which stores the data sources for all your users so you only have to configure the data sources once (other than things like database logins which are specific to each user). After setting up your data sources, you would just need to copy the Settings.xml file from %appdata%\Jet Reports to that location in each user's profile. Settings.xml contains application settings including the setting which tells Jet what SQL server to look at for centralized data sources.
In order to use this, first you have to install the new version of Jet Reports, then create a SQL Server database to store the settings and run the scripts from our support site on that database to set it up. The scripts are located here: http://support.jetreports.com/index.php?_m=downloads&_a=viewdownload&downloaditemid=138&nav=0,19
Does this help?
Regards,
Hughes -
Jet Reports Historic Posts I'm experiencing similar issues where Jet Reports is occasionally failing to load Data sources xml and I have to re-import a saved version…This happens on my local Excel and not server (Citrix). Moreover, Excel takes considerable time to load the first time you open it and sometimes I have to close re-open because I don't see Jet menu bar.
I'm using Excel 2007 with latest Jet Essentials 2011.
My main question though has to do Citrix set-up.
We have Jet Reports 7 running on our server using Citrix to connect our users, and want to update to Jet Essentials 2011. One of the main problems are the different data sources for each user and the incompatibility of updating from Jet Reports 7 to Jet Essentials on how the Data sources are handled/saved. I have tested the update with Jet Reports 2010 (before Jet Essentials launch) and I lost all my data sources and applications settings.
I have read about the cetralized set-up and I wanted to know if I can set this once on the server including all our data sources and control the access via windows authentication. Also, if this can incorporate Jet activation and application settings for all users.
Thanks
P.S - sorry airplaneguy if I'm hijacking your topic :oops: -
Jet Reports Historic Posts OK, I have read the guide how to setup Jet Reports centrally and I wanted to know if I'm on the right track:
Our SQL administrator will create a database which Jet Reports will use as the centralised settings (just tell him to create a database for Jet Reports, that's it?)
He will then run the two scripts fhilton attached in his reply (I assume no further setup is required, right? Just run?)
Now the big question: he is the SQL administrator but he only knows Jet Reports as an application he installs on his citrix server and that's it. How do I build this setup and hand to him to upload it on the server/database?
Let's say we complete the steps above where is the file located with all the settings so the admin can copy it under all the users profile/folder? I believe this is the final step that will save us the time from connecting to each user's Jet Reports session to look for the setup file, right? Ideally, when the whole process is complete, any user that logs to Jet Reports will get automatically the new setup including the shared Jet data sources, settings, etc?
Thanks in advance!
8-) -
Jet Reports Historic Posts Hi,
I think the file you're looking for is:
%appdata%\Jet Reports\Settings.xml
This file contains the Jet application settings, including whether to connect to a server for centralized data sources and how to connect to that server. If you copy that file into the user's profile, then when they use Jet, they should be setup to connect to the centralized settings database for their data sources. Of course, there are some settings that are not centralized such as database passwords (if you're not using Windows Authentication). So there may be additional steps if the user needs to enter that sort of information. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts fhilton,
All our Navision dbs are accessible through citrix using windows authentication.
So to sum up I want to confirm the steps to do a test run:
I will need to create a profile on the server with the desired setup and then copy settings.xml in the users' profile folders.
Run the two SQL scripts.
Log in to any user and it will load the centralised setup. -
Jet Reports Historic Posts Jackies,
I think you have a couple steps missing but maybe I'm misunderstanding you. I think the steps would go like this:
1. Create the Jet settings database on the server.
2. Run the SQL scripts on the Jet settings database to create the tables and fields needed by Jet.
3. Give your Windows users read/write access to the Jet settings database.
4. In Jet Reports, go to your Application settings and choose to use centralized settings along with the relevant database settings.
5. In the Jet Application Settings, go to the Licensing page and import your Jet license(s). Jet licenses get stored in the Jet settings database when you're using centralized settings.
6. Create and set up your data source(s). (You could export your local data sources and then after you change to centralized settings, import them.)
7. Copy the Settings.xml file where you set it to use centralized settings.
8. Log in as any user and copy the Settings.xml file to their "%appdata%\Jet Reports" folder.
The user should now have any data sources that you created in step 6. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts "Does this work for you?"
I don't know but I will surely find out shortly! Thanks!! -
Jet Reports Historic Posts There's now a video tutorial on configuring centralized settings that may help
Its available on the video tutorial website-
http://www.jetreports.com/customer-portal/tutorials.php
Here's a direct link to the video-
http://download.jetreports.com/popup/jet-reports-en-centralized-settings.php -
Jet Reports Historic Posts Thanks SJL4782!!
Please sign in to leave a comment.