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!

  • Congratulations Mike Lewis 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. JanHumanitas

    CognosScript Editor--> export imr to txt results in large (wide)column

    Ok, that's a possibility. But I'd rather not redefine database fields. Isn't there a solution in the script editor? Defining a column start position in the txt file?
  2. JanHumanitas

    CognosScript Editor--> export imr to txt results in large (wide)column

    Hello, I used the following Cognos Script to export a imr to a txt-file. Rep.ExportText "C:\***\***\***.txt" The resulting txt-file consists of 2 columns. The first column (name) is large, say 90 characters. Most names are 30 characters or less.. These 60 empty characters are gererated...
  3. JanHumanitas

    Cognos Impromptu report --> date function (last month)

    Hello, I want to generate a report that shows (montly) the "salary mutation date" of the salaries that have been mutated last month. For example: On May 1th 2008 I want to see that Mr. X has been promoted on April 15th 2008. But NOT Mr. Y who got a promotion on March 21th 2008. I hope...
  4. JanHumanitas

    CognosScript editor --> sending report using ms outlook

    Hello, I've made a script that generates and saves a report. Is there a function in CognosScript editor that can send this report by e-mail (outlook)? Otherwise I have to add such a function in the cmd file that runs the macro. But it would be nice when I can add this function in the script...
  5. JanHumanitas

    Calculate age on December 31th 2007

    Hello, I want to calculate the age customers had on December 31th 2007. Can anybody help me with this question? Thanx, Jan
  6. JanHumanitas

    Cognos Impromptu 7.4 --> if gender is "M" then "0"

    Hello, Simple question: I want to define a filterdefinition inside a report that covers the statement in the subject area: I want to add a "0" instead of "M" in my report. (there a 2 variables in de database "M" and "V", male, female) Hope you could help me out. Jan
  7. JanHumanitas

    Empty records in addresslabels

    Hello LB and dgillz, the values are null (tried IsNull({MyField})). And of course the left join solved the problem. Thanx for your help! Jan
  8. JanHumanitas

    Empty records in addresslabels

    Hello, We have a table with name, address, zipcode and country. We have a report that generates addresslabels. The question from the user was to show the country only when it is outside the netherlands ("LandID<>132"). Because not all LandID fields are filled, I made the following formula: if...

Part and Inventory Search

Back
Top