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

    Cognos 8 SubString of a GL Account Field

    I have a field, GLDEBITACCT, that has account codes such as 6200.2-004-00.00000-05.1. I need to create a paramter that allows users to insert a Project Code, which is the 5 digit number here, 6200.2-004-00.00000-05.1. How can I do this?
  2. CognosNewbie99

    Trying to use Quarter and Year for dates

    I need to create a report where the user is prompted to input Quarter, Year, and First Monday of the Quarter. I need to then use those inputs to figure out dates for the report and use those dates to pull in all the data. How can I figure these out in Cognos?
  3. CognosNewbie99

    How can a subtract dates to find a mean time?

    I'm using Crystal 8 with Maximo v4 and I'm having a little bit of trouble. I'm pulling in equipment along with work orders written against those pieces of equipment. I have an actual finish field on the work orders. I'd like to subrtact one actual finish date from another one the same piece of...
  4. CognosNewbie99

    How can I limit the number of records in the entire report?

    I want to limit a report to only the top 100 records. I can only find ways to limit the records allowed per page, but I need to know how to limit the records for the entire report
  5. CognosNewbie99

    Checking 2 parameters

    I am writing a Cognos report which involves 2 different date fields and a status field. There is a parameter of a date range, begin date and start date. I need the report to only pull the info that has (date1 in date range) OR (date2 in date range and status = completed or closed). I put this in...

Part and Inventory Search

Back
Top