Recent content by PeteWalburn

Hi, I am using Maximo version 6 to run reports in Actuate 8 and am having a problem with scheduling reports. I want the date format for Actuate to match the format within Maximo. This should be whatever the format is on the user's PC. The time format should be in 24 hour format. Could...

Try putting the code in the FinishReport event of the report (at the top-level). We do things where we update or insert records into the database from Actuate reports. I believe that the Actuate Encyclopaedia has had service pack 2 installed and so the code for updating the database had to...

Hi Wes, I probably do really need to do another SELECT, but I have managed to fix the problem. I do the update in the FinishReport event. Also, service pack 2 had been installed and so code that used to work no longer does. Pete

Hello, I have a report which must UPDATE the database. I have tried this in 2 ways: In the Fetch Function I call an update function which executes a SQL UPDATE statement. It the executes a COMMIT statement. The other method I have tried is: In the Fetch Function I build up arrays of the...

What I have done for similar situations is: Make a global variable for the Count. In the BuildFromRow function of one of the controls (or probably the OnRow function of the frame) add code to increment the global variable. Add a frame to the After section and add a control to the frame to...

Hi, You need to override the ObtainSelectStatement function on the DataStream. It will need to be something like: Function ObtainSelectStatement( ) As String If Not(where="") Then If Not(WhereClause="") Then WhereClause = WhereClause & " AND " End If WhereClause = WhereClause &...

Override the BrowserCode function of the control. Something like: Function BrowserCode( ) As String BrowserCode = Super::BrowserCode( ) Dim strNL As String strNL = Chr$(10) BrowserCode = "<INPUT TYPE='text' NAME='Storeroom' id='Storeroom' VALUE='" & loc & "'...

Margaret, The way that I have got around the ambiguous field name problem is to have a simple query in the SQLquerySource - such as: SELECT DESCRIPTION FROM SITE WHERE SITEID=:mroSite Then I have a subreport with it's own SqlQuerySource with multiple tables. You will still need to override...

Try setting it to: "From Date " & format$(param_from_date,"dd-mmm-yy") Pete

I tried it in the Start Sub of the Root of the report and also in the next level down. It gave errors in both places, and the documentation doesn't mention where it can be used (implying it can be used anywhere).

The variable is NULL when the hyperlink report is loaded. It then does a calculation to figure out the value to pu in the variable. It is at this point that I would like to change the SuggestRoiName. Pete

Yes, and when I use SetScaleFactor I receive the message: Invalid procedure reference. - (SetScaleFactor) I guess that I can't use the function in the Start()Sub, so is there somewhere specific that I should use it. The function seems to be exactly what I need. Pete

I've tried using both of these functions. When I use the SuggestRoiName(row As AcDataRow) version, the row is always "nothing". I have put a check for: If Not (row Is Nothing) Then but it is always nothing and so the code does not get executed. I have tried just using the global variable...

OK, I must admit defeat on this issue. I have a report with a SQLQuerySource. In th eStart Function of this SqlQuerySource, a new ID value is created and stored in a global variable. Then in the Fetch Function, new records are written to a table for each row in the SqlQuerySource and given the...

It's strange, but it always seems to happen like this. After trying to find a solution to my problem for hours, I finally posted a question to this board. And then I found the Function SuggestRoiName( row As AcDataRow ) As String so, I now know how I should be able to get the report to do...