Is anyone automating xml files from Jet Reports?
I'd love to auto populate my internal website and perhaps our public website with some scheduled jet reports.
Date
Votes
4 comments
-
Jet Reports Historic Posts Sounds ambitious!
We currently use DTS packages to pull the data from spreadsheets to a SQL database, but nothing like XML. I'd think you'd probably have to write a nice macro in Excel to do the conversion.
Or… If you're using Excel 2007, the format is some sort of compressed XML - maybe there is some web based viewer product? (Just guessing).
Report back to us with what you find! -
Jet Reports Historic Posts A macro is probably the only solution, tough excel 2007 indeed uses a "dialect" of xml, reading it as open source is another mather…
I've used macros to split it up in several excel files, but never to make xml files.
You will have to do a lot of tweaking, hard coding and trial and error, but it's nowhere near impossible…
Are you using a native nav or an SQL Server?
As said before, if it's an SQL Server, just opt for the SSIS. -
Jet Reports Historic Posts I missed a very important feature of Jet Reports. In the scheduler you can create an HTML file. I now have a jet report modifying the same file on a regular basis, and my website hyperlinks to the file. It's brilliant!
Now I have price lists for every manufacturer I carry, updated daily, with the date on the top of the page of the last update. -
Jet Reports Historic Posts I was playing with HTML the other day myself. I've had some issues reading the HTML output in Firefox - specifically sometimes hidden columns are still shown. Are your results Ok in firefox or is that not an issue?
Please sign in to leave a comment.