Recent content by wesw

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