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