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...

niteflite, It's possible to sum level 2 & 3. First, you must create a calculation field for each sum and define them as a «cumulative sum» (I have a french version, please correct my expression if it's wrong) for a level 2 or a level 3 depend a calculation field. For exemple...

Are you linking the tables in a catalog? Gilles.

1hrllab, If you want to show a message you must use a dialog. With this, you will show message and after it play a report. Second, put application visible to false. With this user don't show impromptu and the message «application isn't responding» don't show. For printing, show print/print...

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, You must use a function DateTime_To_Date in a calculation field. Gilles.

Monsky, I think you can do this by using view. Define a view on DB for table where you extract top 5 rows and others. I think you'll need to define a new column where you set a rank (1,2,3,4,5,99 for others). In the report you can group rows by this new rank. 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...

By experience I don't cut and paste calculation. It seems that impromptu lost reference in this case. The solution : retyping the function. Gilles

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, First, I found how to do this with CSNG function. the instruction is : csng(asc(char) xor 1 xor number) and it works. I want to read this new result in caracter but it's impossible because the value is now too long. Second, in vbscript it's impossible to have a string return, it's for...

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.

You're right DD.

Recce, I don't understand what you want to do but I think it's possible with conditionnal setup. The difficulty is to know where you want to insert it. For exemple, if you want to insert a line after a record where column A = 10 (it's example). You can define in conditionnel setup of record...

Mitra, Like I said in previous thread, it's possible to have a null value with macro. If you use a macro, you can define a prompt of date in string datatype. In this case, you can accept null value or a date format. In the filter you must transform a string in date type or transform a date...

BluByU, If we follow Dave's approach, the name of table will be rename in new catalog then take it a same name of your old table and the report doesn't see the difference. To do this, you just to rename a table name in definition. Gilles.

Dave, I never try this approach but it's very intersting. I will keep in mind this for a future. Gilles.

I'm sorry, I don't use AccessManager. I suppose it doesn't the same error but I have one. Gilles.

Hi fuhbar, I have a same problem with opencatalog method. The statement run correctly in Impromptu administration but not in Impromptu User version. Do you know a exact syntax on this undocumented methode (OpenCatalogEx). In fact, I use and other class then creator. Thank's.