Search results for query: *

Hello If the file to where you save the report as PDF is already open in Acrobat Reader, Impromptu crashes. I don't know if this was your case. Regards, Ronald

Hello If the package body has private functions or procedures, the order is important. Regards, Ronald Sönksen

Hello I reverse engineered a database package, from an Oracle8i database, or a script, into a PDM model. The package has many procedures. The problem is that QDesigner (Quest's PowerDesigner) v. 9.5 orders the procedures by their name inside the package. I wanted to maintain the same order like...

Hello I created a stored procedure report in Impromptu 6.0, that calls a stored procedure in an Oracle package. The stored procedure has some input parameters and a REF CURSOR output parameter. It is working. The problem is that some of the input parameters (with datatype DATE and NUMBER)...

Hello Tison Try this: clear set head on set verify off set pages 200 set lines 200 prompt accept tablespace_name prompt 'Enter Value Tablespace (Return For all) : ' col tspace form a20 Heading "Tablespace" col tot_ts_size form 99999999999999 Heading "Size (Mb)" col...

In the ASCII table, the character { comes after z. So, if the prompt 2 is set to {, all names beginning with a letter will be returned.

Hello Dave You also can use parameters for a macro when you insert the task manually. Just enclose the name of the macro in double quotes. Regards, Ronald Sönksen

A colleague of our enterprise in England has found a solution to my problem. [bigsmile] Parameters can be specified for a macro to be scheduled, in the property ScheduleName, if the name is enclosed in double quotes. The macro name must be followed by a space and the string of parameters. The...

Dave, The macros will be scheduled by the end users. It's impossible to know how each report will be scheduled . It's also possible to schedule the same report with different concurrent schedules, and different prompts. Thank you for your prompt answer. Regards, Ronald Sönksen

Hello Dave Thank you very much for your answer. [thumbsup2] I already thought about doing this (writing the data into a file to be read by the second macro), but there is a problem: If many reports are scheduled, how do I know which file (or part of a file) to use in the second macro ...

Yes, you can make this with a CognosScript macro. There are some examples from Cognos of how to do it.

I have a similar problem: There are many reports with a start date and end date prompt to filter the data. I have written a macro that gets expressions for these prompts, these expressions are related to the current time: (Start of|End of) current (time|hour|minute|day|week|month|quarter|year)...