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