We use cognos script editor to run all our reports. Most of the reports are published in pdf format. As an earlier reply suggested you could use a recordset to generate the prompts, or you could hold this data as a csv file and load it into an array. The array data would then be merged into the...
try to examine the sql to see if you are referencing tables that you do not require data from. The fewer table referenced the faster the reports will run. Also try the flexible processing option.
I have a number of macros that append text to file if an error occurs. this gives me an error log. I wish to convert the text added to html file and preprend rather append the text. does anyone know the correct syntax
definately use flexible processing, but also examine the sql. if you have developed reports by re-using old ones, you can often remove fields that are not absolutely necessary. In otherwords try to keep the number of tables referenced to a minimum.
I currently use scheduler to produce pdf versions of impromptu reports. These are placed on a file server so that users can access them. The users tend to forget to close the pdf reports down when they use them, which prevents my macros from over writing the old version of the report. I used to...
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.