The problem has a relation with the behaviour of impromptu.
Like you said, impromptu takes a lot of disk space for temporal files (yes, we've outer joins and several SQL for each report), in other way if you have a lot of records you'll miss memory in your server.
We noted this problem in w2K...
griffidm, i'm afraid you have this problem in every PC with every OS. I worked with a guy who is a cognos consultant and he confirmed me that there is no solution for it.
Maybe you have to modify the Macro with the solution which I said. Run a report, free impromptu, run another report, ...
I think that version 7 don´t resolve this problem yet!!!!
If you use the scheduler you won't get this problem, but You must create a Impromptu App instance for each report (that's great, isn't it?)
You can avoid the problem (only in a scheduled scenario) with the next solution:
Create a...
No, I didn´t. Also, I post the same message in Support Web Cognos. They reply me this is a bug not resolved, in version 7 too. If you are making a report, You should close impromptu for each execution. If you scheduled your report, you should close every Impromptu instance for each report.
We have a great problem with Impromptu. We develop a Report with a large set of records (it takes 200.000 Kb for one month). If we execute the report 3 times, Impromptu get 200.000 kb for each execution. You can only get free memory when you close Impromptu. I put a Call in Cognos Support and...
You can create a COM Object to make the Zip file (with Shell function as jbecher said), then you can use COM Objects to create the mail and Attach the newer zip file, for example, if yoy have a Outlook client, or IIS System, you can use CDont Objects. This is a Framework to manage the mail...
We have a Oracle Database configured in American Character Set, but some tables have then information with non-basic Characters (we are spanish). This means specials characters are holded well, but displaying is wrong.
Can We configure the Character Set in Impromptu Report?
Thanks in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.