Search results for query: *

Hi, I have a problem to define the global temporary table into my UDF (DB2 v8.1). Somebody can help on this. Here's the code and the error : _________________________________________________ CREATE FUNCTION MySchema.GM_FCT (ID INTEGER) RETURNS TABLE ( ID INTEGER, NO INTEGER, NAME...

Hi, I install Impromptu version 7.3 MR1 and I try to filter the report on Blob column, as the cognos documentation says, but I don't see the blob column in report column folder in filter tab. Anybody try to filter a report on blob column? Gilles

Hi, I find how to simulate a cancel action whithin the dialog. I try to send and err(102) but the dialog continuous to run. Somebody know how to do this? Gilles.

Hi, I create a cross table report where I show a colomn total. I would like to have a total always the last column in rigth. The problem is when a new column is generated this one is somtime added on a rigth of total. Somebody know how to keep total always on rigth when a new column is...

Hi, I find how I can sommurize some information in a footer of a group. For exemple, in the report I have two field («recept», «ingredient»). The data is grouping by «recept». In a footer of group «recept» I would like to repeat all ingredients. It seems impossible to concat the same field...

Hi, I would like casting a string in a binary value to take an XOR instruction. Somebody know how to do this in macro script. Thank's in advance, Gilles.

Hi, I find how to define a session variable where each session can use and modify it without other session see this one. Somebody know how to do this. Thank's in advance. Gilles.

HI, I would like to know how can I produce a report in multiple language, for exemple french and english whithout creating a new report for each language. Is it possible to define dynamic field for title of report, title of columns, header, footer, etc. In fact, I want to pass a parameter...

HI, Somebody know how to format(size, police, bold, etc) of header and footer for a cross table and keep this format for a new column that appear when the report is rebuilt. In fact, when I format header and footer (size, police, bold, etc) the new column don't have a same definition as old...

Hi, I create a cross table report and I would like to know if is possible to force a fix column where no data was found in line data. In default, the column is generating by Impromptu and only the column with data appears. In context where the report is use by end user, it's more efficient...

Hi all, I find a function to know if a user is in a certain group (not a local group). I prefer to not use WMI to do this. Gilles.

Hi, Is it possible to crypt a password (for userclass and bduser) when we use a method OpenCatalog. Gilles.

Hi, I find how I can compare a data field with the same data field but for a previous occurrence. To goal is to show a delta between to datetime. For exemple : Action Time Delta 1 today at 9h00 - 1 today at 12h00 3h00 2 today at 10h00...

Hi everybody, I have a information question for user of IWR. I read a description of IWR on cognos site and I understand that's solution can deploy the reports on the web without Impromptu client version. Is it exact? Is it easy to install and use as cognos says? What's happen with a prompt...

Hi, I have a report where I use some prompts (for example start date and end date) as criteria and I show this dates in a header for information to user. When the report extract some lines the dates are show but when the report extract 0 line then the dates aren't show. Is it normal? What's...

Hi, I use a pickList with a multiple values. I use it for for prompt and it works very well. When I show it directly in a header, for example, it works good but when I want to show it in a calculation field, for example I want concatenate the values with an other, the picklist lost a multiple...

Hi cognos members, I have in a report a text field that vertical size is dynamic. Unfortunately, sommetimes this field overlap a second field. How can I do for the second field move down when the first is too long. Gilles.

Hi all, Somebody know how can I define a field, or section, that printing when a condition is true. I don't want just take the field or section hide because I want shrink the space unused. Gilles

Hi all, I have an external application in that user select some criterias for a report and he select a group by field too. My question is, does it more efficient create one report per grouping option field or create one report for extraction and one model per grouping option field. thank's...

HI, I use Impromptu 7.1 and ODBC to connect to Oracle. I have a big problem since 1 week when I pass a long parametre list I have an error from odbc. The error message is : Erreur nº -239 : DMS-E-GENERAL, Une erreur est survenue pendant l'opération appliquer les options à la requête...