@Sparkum said in Any Jet Reports guru's here?:
@scottalanmiller
For sure, and I am definately going to take SUMINDEXING to our developer.
So that would explain the 45-60 minutes jump (since we got the 3 hours back down to 60 minutes)
But the fact that it jumped from 60 minutes to 120 minutes is ENTIRELY on me since my previous version still runs in 60 minutes.
I hate to sound ignorant, as I don't know much of anything about Jet Reports, and I'm basing just off the information I've gleaned from this discussion, their website, and my knowledge of excel (which seems to be massively greater than I think I'd like to admit. Dark Days of "Doing Everything With Nothing"... /tangent)
Schedule reports to automatically run and distribute on a regular interval – daily, weekly or monthly. You can also trigger reports to send based on set alerts (did the budget get exceeded?). Tailor reports to your needs, save your scheduled tasks, then sit back and relax while Jet Reports does the work for you. Like magic!
Maybe set these reports on a schedule? That'd save actually noticing the run time, though it wouldn't actually reduce it.
It sounds like, since the formulas are a little longer, and I'm assuming there are many of them, it is trying to run calculations god knows how many times during the report compilation. Try turning off Automatic Workbook Calculation (File -> Options -> Formulas -> Workbook Calculation. Set to Manual. Will recalculate before saves and can be done manually with F9) See if that helps.
Another possibility is if your screen is showing Jet Reports trying to compile the report from a spreadsheet, it might be heavily taxing the processor due to the visuals. Take a look into programmatically turning off and on screen updating in excel. Might help