Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GilMerc

    Temporary Table Error

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

    Cognos Impromptu - "linking" tables - revenue

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

    Cognos Impromptu - "linking" tables - revenue

    Are you linking the tables in a catalog? Gilles.
  4. GilMerc

    Macro-Wait for Retrieval before print

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

    Impromtpu - Filter BLOB

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

    Format DateTime Value in Cross-Tab Report

    HI, You must use a function DateTime_To_Date in a calculation field. Gilles.
  7. GilMerc

    Extracting Top n number of rows

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

    Macro - Dialog

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

    Impromptu - Cross Table total

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

    Cut and Paste error in Impromptu

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

    Impromptu - Sommury information

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

    Macro Script - casting

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

    Macro Script - casting

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

    Display current date in prompt

    You're right DD.
  15. GilMerc

    Ho do I add record in Impromptu based on Indicator ?

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

    Date Prompt

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

    Changing table names in a Cognos report...

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

    Changing table names in a Cognos report...

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

    Problem Macro - Impromptu OpenCatalog Method

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

    Problem Macro - Impromptu OpenCatalog Method

    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.

Part and Inventory Search

Back
Top