Search results for query: *

Our locations are unique, but the first four characters of the location code defines the school. We have over 50,000 locations in our system. The are similar to this: 0369A1101P1, 0369A1211AHU1, 0370A1101AHU1. So I want to group by the first four characters, in other words by school. I want the...

Hello, we use Actuate 7 with MAXIMO 5.2 Oracle. I'm new to Actuate, on my own, and I need help. I've been to IBM Actuate Training and that is it. I'm developing a report for each school that shows all work scheduled for the following week similar to below: Adams Elementary wonum...

thanks to you both! I got it.

CR8.5 Oracle DB I've created a simple report, using the select expert. The select expert formula shows: not ({WORKORDER.EQNUM} in "19375", "19376", "19382", "19378", "19381", "19373", "19370", "19368", "19363", "19384", "19371", "19359"]) and {WORKORDER.ACTFINISH} in DateTime (2005, 06...

Thank you TurkBear I was able to achieve my request.

I hope I can ask this question fairly intelligently... I would like to use Ken Hamady's formula for finding the number of work days between two DateTime values, but I would like my DateVar Start to = a parameter value {?StartDate}. Ken's example is this: Local DateVar Start := {StartDate}...

I'm using CR 8.0 and have a report with a formula @directrate, Sum ({LABTRANS.REGULARHRS})/Total Available Hours*100. I want to create a datetime range parameter field and have the formula update the Total Available Hours value in the formula above based on the parameter's datetime range value...

I'm using CR 8.0 and have a report with a formula @directrate, Sum ({LABTRANS.REGULARHRS})/Total Available Hours*100. I want to create a datetime range parameter field and have the formula update the Total Available Hours value in the formula above based on the parameter's datetime range value...

Nevermind...I got it thank you. I'll try the average now.

This didn't work. Returned values are 0.00 Hrs for each G1.

I have CR 8.0, Oracle db I will try and explain my question as best that I can, as I'm a little green when it comes to shared variables. I have a report with two shared variables from a subreport in my main report. I have two groups in my main report. G1 - Shop, G2 - LaborName. The subreport...

Thank you soooo much! Both main and subreports were in portrait. At first i increased the width of the subreport beyond 8" and behold! So I put the width back to what is was previously and actually decreased the width in the layout tab. You look at these things long enough and the simple...

Actually I am using "across then down." I will only have two rows and two columns of data at the most (4 records)in my subreport. The subreport is in section D3. While in the main report, I formatted the subreport by unchecking "Can Grow" and the size of the subreport is large enough to show...

I have a CR 8.0 report with a multiple column (2) subreport. When I preview the container report it inaccurately shows my subreport with a single column. When I preview the subreport it is accurately showing multiple (2) columns. I am stumped.