Hi everyone,
I'm having a bit of trouble maintaining our Jet Report Versions along with Schedules.
We are using Jet 7.1 with Nav 5.0 SP1 since May '09
At the moment i have 2 Directory Structures.
Forms\Backup_Forms\Jet - Sales and Marketing (this would differ depending on what the reports are and holds .xls for Scheduling)
and
Forms\Jet - Sales and Marketing (this holds the .xlt so the users/Account Managers wont have errors with 2 people saving/running the report at the same time)
I have a total of 48 Reports with 51 schedules
the end result is if i change an option on the report i need to fix up 2 spreadsheets and a schedule (which is on another computer)
could someone give me some pointers on how they have set it up?
thanks
-Bromy
Date
Votes
9 comments
-
Jet Reports Historic Posts Official comment In our environment, we have all reports centrally located on a network drive, however our users do not even have the viewer installed. We put all reports on the scheduler, and have them delivered via email.
We have one or two power users who have designer and/or viewer access, however they have this to maintain their own reports independently of IT.
Through this forum, I have not read about anybody going to the lengths you have to organise - probably why there has been no response to this thread!
Good luck anyway!
cheers -
Jet Reports Historic Posts i havent had any responses.
surely someone has a similar situation to me?
-Bromy -
Jet Reports Historic Posts So no-one has any reports stored?
any ideas will be good.
even if they don't work
-Bromy -
Jet Reports Historic Posts I'll bite :)
I've never used an xlt file with Jet.
On the reports in backup_forms, can you link to the .xlt file from it, i.e.
='[C:\Forms\report1.xlt]Sheet1'!$C$6
from within
C:\Forms\Backup_Forms\report.xls?
Never tried this….
As with the schedule, you can modify a schedule directly from windows.
1) Browse to UNC location of the scheduler machine, i.e. \\Jetserver1
2) select 'Scheduled Task', and there you have them all.
3) All Jet config is done on the command line, and the date/time is handled by the standard windows schedules. The best thing here is you can use some features in Windows that aren't implemented in Jet, such as multiple execution schedules for the same job.
cheers, Mark -
Jet Reports Historic Posts Thank you for the response Markl
The XLT is just a template extension, when double clicking a template it creates an unsaved local copy.
I use that so the original cant be edited
i'm not sure what you mean when referencing to the XLT.
ive kept the two seperate so,- When the schedule runs (using the "Backup_forms" copy) and emailed to the appropriate person its not a Template File
- so when they run a report they cant save over the origional (this way i can use formula in the options page to dynamically set the options)
and i'll have a look at the Schedule Task options -
Jet Reports Historic Posts i'm not sure what you mean when referencing to the XLT.
What I was trying to suggest, is if you have to manage the same 'options' in two places, you could just have one refer to another. Again I have not tried this so I'm just making it up as I go.
For Example, you have your options in cols D and their values in E
In the .xls file, instead of having say:
D3 = "Posting Date"
E3 = "010109..123109"
You could have:
D3 ='[C:\Forms\report1.xlt]Options'!$D$3
E3 ='[C:\Forms\report1.xlt]Options'!$E$3
Again, I'm not 100% sure if this was one of your issues or not (thats how I read it)
If you ware referring to your actual jet formulas, then I don't think there would be any way around it, unless you treat the XLT as the 'master' and somehow automate a (nightly/hourly/whatever) conversion from forms\*.xlt to forms\backup_forms\*.xls
Another way to manage the multi-user usage - give every user their own directory for a copy of the Jet reports, and write a simple batch script to regularly copy the 'master' reports (which would also be the scheduled ones) into their individual locations. This would remove the multi-user open/run/save issue.
Or perhaps if you have that many people using your Jet reports you may need a more complicated enterprise solution? (reporting services, BI, etc)
Hopefully you'll be able to take something at least from it. -
Jet Reports Historic Posts Centralized reporting and storage is something that we are looking at including as a feature in Jet. In terms of a solution today, SharePoint portal services and Microsoft Office SharePoint services do a pretty good job of this. The Jet Scheduler integrates with document libraries by enabling incoming email in SharePoint and setting the incoming email address on the appropriate document libraries. SharePoint will track versioning and make sure that everyone is working from the appropriate reports.
-
Jet Reports Historic Posts what you are refering to is not a problem.
i have a simple date formula for the options
E2=NP("Eval","=Today()")
D3="Start Date"
E3="=Date(Year(e2),month(e2)-1,1)
D4="End Date"
E4="=Date(year(e2),month(e2),0)
then use NP("Datefilter") to get the other details.
for you second suggestion (having a separate directory per user)
this becomes a larger task because we have 20+ Users using Jet
what my original query was, how do people store Jet Reports and make them available for users?
Do you have 1 person who runs the reports and sends them to the appropriate person?
Do you have a shared drive where anyone can use it?
When we first start using jet i knew that we would be using it extensively, which is OK, but we never received any advice on how to store/organize our reports. -
Jet Reports Historic Posts Thank you for your Responses
-Bromy
Please sign in to leave a comment.