Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JBo
  • Order by date
  1. JBo

    changing batch fetch size in impromptu.ini?

    I understand that I can change the maximum batch fetch limit for Impromptu queries by amending the impromptu.ini file. I know the line of code to enter but do not where to enter it. I have tried this several times but to no effect. What am I doing wrong?
  2. JBo

    I want to save reports in excel with format using script, how?

    Thanks again Dave Yes, I already now this. I'm getting pretty clued up when it comes to Impromptu forum, but there's always something you don't know. So I appreciate your support. J
  3. JBo

    Out of memory

    Sorry if you may have already checked this but, have you recently deleted the contents of your TEMP directories on your workstation or server. If not these may be full and hindering the caching of data. J
  4. JBo

    I want to save reports in excel with format using script, how?

    Dave It is the physical report layout to which I refer. I have only recently begun working full time with Impromptu and thus I am still on a learning curve. The majority of our company reports were set up some time ago by an external agent and, whilst fulfilling there purpose, they restrict...
  5. JBo

    I want to save reports in excel with format using script, how?

    Cheers Dave Here's one for you. I'm creating subreports from quite a complex original. Copying the calculated data elements from the parent report is no problem (as long as impromptu doesn't crash), but how can I copy the report structure from the parent. Quite a quandary, I think you'll...
  6. JBo

    I want to save reports in excel with format using script, how?

    Thanks Dave I cracked it in the end. This helps no end. I envisage problems with crashes whilst I run these macros. Do you have any suggestions regarding avoiding this and what to do when it does crash? J
  7. JBo

    I want to save reports in excel with format using script, how?

    Thanks Dave I've searched for Sendkeys but I can only find a post about saving excel without format and some rather basic problems. Can you be more specific as to a solution? I currently handle over a hundred reports and automation with Cognos Script has become my 'raison d'etre'. Many...
  8. JBo

    I want to save reports in excel with format using script, how?

    I can write script to run and save a report in excel, but how can I get the script to save the same report in excel with format? Does anyone know the solution?

Part and Inventory Search

Back
Top