Search results for query: *

Might help to see what you have for a query.

There shopuld be some pdf files in the directory structure where you installed the erdPro open a datastream using a textual or graphical query.

in your obtainselect method of your datastream add a line after the obtainselect.. setclipboardtext(obtainselectstatement), This should put your Sql into the clipboard so you can see what Actuate is using.

Maximo no doubt, yes

On the datastream (properties tab) you can see the sql (Query) and the parameters will look like =:parameter name. In addition if you look at the method tab check the obtainselectstatment You can add showfactorystatus(ObtainSelectStatement) and the sql will appear in the output viewer. you can...

I wouldn't bother using that functionality, unless you'll be changing label text via the maximo application. Depending on which version of 6 you are running it will not work, this is especially true with SQL Server. I believe the issues were corrected in 6.2.1. Wes www.williamsconnell.com

I assume you have a group section by color, Then have each column use the following valueExp count() Where ( [size] = "xsmall" ) next column count() Where ( [size] = "small" ) etc. xsmall small medium etc. -Wes

I'd try it with SQL using the case statement. -W

Click on the datastream, click the methods tab, scroll down to the function obtainselectstatement add the following; setclipboardtext(ObtainSelectStatement) so it looks like this ObtainSelectStatement = Super::ObtainSelectStatement( ) setclipboardtext(ObtainSelectStatement) End Function...

Do you want a parameter to be converted to uppercase? Is this coming from a request page? (Maximo version 5.x) Or are they typing in the value in the application? and then running the report for selected records etc. Wes

IvySkye, is on it the jobplan should have a reference to the craft. The field\column is jobplan.laborcode Wes

I think Maximo only wants owner.tablename check options. Does the code work in the query analyzer? also workorder.siteid = :mrosite Also do you have any synonyms of 'CANCEL', 'COMP', 'CLOSE', 'INPRG' ETC? if so then you should use something like this workorder.status in (select value from...

I assume your are using Maximo. If it is version 5.x then you can open the datastream <object> (Graphical query) click on the conditions tab and add to the where clause. If it is Maximo 6 (MXES) open the datastream <object> here you'll have a textual query where you would add to the where...

first question is how do you know you need a sequential section? What are you trying to write a report about? e.g. pm listing, open work order report etc? so are you using one of the maximo templates? You'll have a new report app, a report section etc. Now what? Wes

I am afraid that you will have to re-write the reports. The sql from the SQR's will be useful, but SQR and Actuate are two completly different animals. Wes www.weswilliams.net

I update the scheduled finishdate for PM workorders. I just use the value stored in the variable when I display it in the report. This is the same value I used in the update statement. Otherwise you'd have to do another select to get the updated information. Seems like a no brainer to me unless...

This can be accomplished by calling another report and some scripting

Thx I have one frame with controls. ctrl 3 is on top of 2 and has a height of 0. 1 3 4 5 6 .. In and earlier section I use onrow to check and populate a variable. htp = row.GetValue(&quot;wo12&quot;) If Isnull(htp) then Htpnewpos = 0 else Htpnewpos = 360 end if Now in each control...

I find that incredible. Well I am guess I can do what will take me weeks in Actuate in a day with SQR. It appears to me that everything takes more time. I can hand code in SQR faster than using Crystal or Actuate. In addition, how does one document code? If I do a ton of overrides do I have to...

within a frame I want to dynamically position a label and a text control. If a field is not null or a variable or whatever is not empty, print the label and value and move everything below it down a line. If is is null print normally. It looks like each contol has an X value of 0 zero so how do...