Hi all,
Is it possible that a running Jet report conflicts with the windows clipboard? I keep noticing that whenever me or my coworker is running a report (and we have some that can run for multiple days) we find ourselves losing our clipboard data.
My coworker sometimes gets a message along the lines of 'cannot empty clipboard' while I from time to time can experience that a ctrl-v does not paste the data i just ctrl-c'ed but a navision data line. Obviously this leads me to believe Jet may have something to do with this ;)
Now, is there any way around this? Copy/pasting can be quite a hassle now (disregarding whether we're running Jet locally or via Citrix).
Thanks in advance,
Chris
Date
Votes
3 comments
-
Jet Reports Historic Posts I have similar experiences with cut and paste. I have a suspicion that Jet uses the clipboard as part of its processing. I have also had issues using it via terminal server, including thost clipboard errors. To the point I have to close Excel and log off the remote TS session.
Unfortuantely (or fortunately for me) we have a dedicated PC where we run all our lengthy reports on, so I don't have much in the way of problems, and hence haven't looked for a solution.
I'd be interested to see if anybody else has some clipboard related stories? -
Jet Reports Historic Posts The reason for this is actually the result of how the clipboard works in Windows. The clipboard is a global object intended to create a cohesion, so to speak, between Windows applications. Unfortunately, that means that a "Copy" operation in any application, including Excel, uses the global clipboard. This becomes a problem for Jet Reports while expanding replicators (Rows, Columns, Sheets) in particular. A replicator, by definition, copies everything in the region (i.e. Row) and inserts that region for as many values as there are in the list. In order for this technology to work, Jet Reports uses Excel to perform the copy, Excel copies the data to the clipboard, ultimately causing the interference that you're seeing.
I know that doesn't solve your problem, but hopefully it sheds some light on the situation. We are aware that this is an annoyance and are continually looking for ways to improve the user experience. Your feedback is much appreciated! -
Jet Reports Historic Posts Very interesting read Sam, keep it coming!
SchoutenCC, I'm curious what kind of reports you have running for days?
Complex inventory ones?
If you really have those kind of runtimes, it could be very interesting to create some extra keys in NAV for them.
Running them, as Mark suggested, on a dedicated machine with lots of CPU power and a fast (Gb) line will be another solution to greatly reduce the runtime.
Please sign in to leave a comment.