Hi all.
I've got myself into a situation where I have a report that is over our e-mail sending size limit, and we are unable to increase this limit.
I've tried some external scripts, however then Outlook displayed security warnings, requireing manual intervention. I've looked for command line SMTP utility however I can't find a freeware one that supports authentication (and works).
Has anybody got any ideas on automatically zipping it before emailing, through Jet somehow?
thanks, Mark
Date
Votes
8 comments
-
Jet Reports Historic Posts Finding a prog that can override security could be seen as a crack… outlook will always check for external interferrence, if it could be easely overwritten, malware would have a great time.
Maybe you can look for the answer in your report. I know from experience that lay-outing a XLS increases the size of the file a lot. Pivots, of course, are also not that nice to filesize.
Also, do your reports get mailed in XLS or in XLSX (office 2007)? We've experienced an average drop in filesize of more than 50% when we made the change (proving itsellf systematically more efficient than regular 'zip' compression)…
Also, it could be a nice question to ask in the "future request" section, to ask for the possibility to ZIP files (and maybe put multiple in one zip…)! -
Jet Reports Historic Posts We're stuck using Excel 2003, so the option of an XLSX is unfortunately something we can't look at just yet. Hopefully one day.
We've actually got quite a lot of data in the report, on purpose. We're trying to get around some of our end users lack of technical skills (they couldn't manage Jet in viewer mode) by giving them a report they can take the bits out they need.
My workaround is to share the output location on the network. If that doesn't work out I'm going to break it down into several smaller files. A little more to manage, but should work out Ok. -
Jet Reports Historic Posts Indeed, as long as it's used internally you can use a network share…
The upside also is you can keep a register of previous files there, plusthe mailboxes aren't cluttered with 40x the same big file (which is only used in half of the cases).
For those reasons, we almost always opt for a network path for internal distribution (SQL reporting & jetreports alike). -
Jet Reports Historic Posts Have you considered to save the files as HTML files? And share them through a browser?
The Jet Scheduler allows you to generate reports over night and save them as HTML. Each Excel sheet will become a separate HTML file.
And for those of you who think they will not be able to drilldown into NAV any longer…
- go to your report in Design mode;
- select the cell for which you want to provide a drilldown;
- use your right mouse button to "Insert comment";
- delete the comments and enter "drilldown";
- run and save the report as you normally would do.
When the Jet Scheduler has created the HTML file, open it and you will have a nice drilldown button :D -
Jet Reports Historic Posts I was in a similar situation (save a report as pdf and publish it to sharepoint) and opted for creating an excel macro that i've entered into the windows scheduler (using windows scripting). This macro opens the necessary jet file, updates it, publishes as pdf and then saves to network disk and sharepoint, after which loop to next b.u. number. You could try a similar approach with creating a macro that opens jet, updates and then zips before sending it off.
-
Jet Reports Historic Posts Indeed, as long as it's used internally you can use a network share…
The upside also is you can keep a register of previous files there, plusthe mailboxes aren't cluttered with 40x the same big file (which is only used in half of the cases).
For those reasons, we almost always opt for a network path for internal distribution (SQL reporting & jetreports alike).
This is how we do it. There is a folder that holds all the daily reports. We don't need to keep a record of previous days though, and just overwrite them. -
Jet Reports Historic Posts Have you considered to save the files as HTML files? And share them through a browser?
The Jet Scheduler allows you to generate reports over night and save them as HTML. Each Excel sheet will become a separate HTML file.
And for those of you who think they will not be able to drilldown into NAV any longer…
- go to your report in Design mode;
- select the cell for which you want to provide a drilldown;
- use your right mouse button to "Insert comment";
- delete the comments and enter "drilldown";
- run and save the report as you normally would do.
When the Jet Scheduler has created the HTML file, open it and you will have a nice drilldown button :D
Hi, I've tried your drilldown suggestion exactly as above but the html files created have no drilldown link to click. Is there another step?
I'm using Jet Essentials 2012 and Office 2010 -
Jet Reports Historic Posts Hans posted his steps in 2008 using Jet v7. This functionality was actually not carried forward when Jet was rewritten in 2009, so it no longer exists. It was one of the few things that was actually removed from the product during that transition. The way the HTML file was created was changed significantly between Jet v7 and 2009 and creating the hyperlinks was no longer feasible.
Regards,
Hughes
Please sign in to leave a comment.