Search results for query: *

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?

eqnum wonum status worktype actstart actfinish Mean Failure Time 1023 56437 CLOSE CM 8/31/2011 8/31/2011 0.00 BP000002 51995 COMP CM 12/20/2010 12/20/2010 0.00 BP000016 51551 COMP SA 11/24/2010 1/5/2011 0.00 BP000018 52616 COMP CM 12/27/2010 1/4/2011...

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

The recordnumber > 100 works. Thank you so much!

1) In order to use the method you posted (report->group selection->top: 100->sum of {@cost}->descending) I had to insert a summary on the totalcost field. It is just a detail level field, I created a simple formula to give me the required information and placed it in the details section. When I...

I was originally not grouping by anything and only wanted the top 100 records. But I figured out a way to do it. I have another question if you are willing to help? It's a different report. This is the data I pull in: itemnum description unitcost totalcost(formula:unitcost*curbal) I am sorting...

Can I use that formula even if I'm not getting the sum?

I'm pulling in: Equipment Group (Which is a formula: Left(eqnum,6)) Description Total Cost (Which is another formula: unitcost * curbal) I had an issue with the equipment groups but that's taken care of. Now I am sorting by the total cost, descending order. I only want the 100 records with the...

I have Crystal 8.5 so that won't work, thanks though.

I'm not sure I know what you mean. I'm pretty new to Crystal. Do I create a formula for the counter?

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