Search results for query: *

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

Hi, Is it possible to use some of the data from a report in the SuggestRoiName function? One field of the my data has a unique number generated for the report. I would like to have the SuggestRoiName include this unique number in it's name. I know that this value is not known when the...

Roray, Thanks for that. It should help me to sort it out. Pete

Hello, I use Maximo to load Actuate Reports. Initially a Request Page is displayed for the user to make some selections and then load the actual report. Everything works great, but when the actual reprot is displayed the user can change the zoom level. Then, if they close the report without...

Hello, How do I add the TOC button to the toolbar on a web report? My toolbar has the navigation, print and download buttons but no TOC button. Pete

I am definitely displaying the right variable. I have been informed that the After frame is called before the Sequential Section and this is why the variable has 0 in it. I have modified the control showing the count to have a Value Exp - Count() and it seems to display the correct value...