Search results for query: *

Firstly, I am still using Actuate 7 I have a problem with a report which results in some components being removed and some not. I'm running this code in the OnRow method dependant on a returned db field. Bizzarely, changing the component's position in the layers changes the components that...

Hi All I have a query when I want to outer join to more than one table. Using standard PLsql I get the following "ORA-01417: a table may be outer joined to at most one other table". My question: does ANSI sql have an answer to this?

Thanks for the suggestion, changing the driver worked.

We have just 'upgraded' to CR V9 (Yes I know) running on oracle 9 and one of the V8.5 reports now throws up this error. Copying the query and running it in toad does not throw up the same error so I imagine it is a CR query engine problem. 1) Has anyone ever run into this problem (You may have...

Genius is a word overused. Fit's though. Thanks

CR V8.5 ORCL9 DB When exporting to excel v8 the following long text field: This workorder is covered by our comprehensive contract with the Client. If the fault is outside the following scope it is Capex work, and approval is required from TW before carrying out the work - please provide an...

Using Dave's suggestion of piece-meal executions, I tracked the problem down to the parameters 'lower' and 'upper'. If they are removed and substituted with a db datetime field then the SQL is fine in actuate. Furthermore, colleagues trying to run the SQL in TOAD found the same failure where I...

Try putting this into the finish method of the hyperlinked control. Super::Finish( ) Me.LinkTo = "<your report path>" + & "<your report name>" & ".rox?" + & "&Kolleksjon=" + & <field containing the data to pass> I have achieved what you want to do this way.

Thanks for your responses. In PLSQL "Trunc" applied to a date removes the time component to leave you with a date (See below taken off a PLSQL tech site) In Oracle/PLSQL, the trunc function returns a date truncated to a specific unit of measure. The syntax for the trunc function is: trunc (...

Hi Dave That command in Toad just brings up a pop-up window which I can't copy and paste. I assume you are wanting to know the data type of changedate, which is "Date".

I have the following fragment of SQL as part of a textual query in the Actuate reports application (Select provider, Count(*) As CountOfPrev From wostatus, workorder where workorder.wonum = wostatus.wonum and wostatus.wonum in (Select wonum from workorder where siteid = 'N304' and location =...

I have the following fragment of SQL as part of a textual query (Select provider, Count(*) As CountOfPrev From wostatus, workorder where workorder.wonum = wostatus.wonum and wostatus.wonum in (Select wonum from workorder where siteid = 'N304' and location = :site) and wostatus.status =...

I Have tracked down the problem to the line: Filename = InputBox("Enter the query name to archive","Archive Query","<Query Name>") Or at least that line causes the report to fail when virtually everything else is commented out, whether it is the only problem is another thing.

The code below moves files between locations and then reports activity. The code works fine in actuate but when I try to run it from the server it throws up the error "Unterminated string constant" Any help gratefully received. Function Fetch( ) As AcDataRow Dim Row As DataRow1 Dim Result As...

Hi I use a global search path to point to our libraries. This is set from the options tab "Global Search Path". Select New and navigate to where your libraries are stored. Each time you open a report it will look for libraries in this location. This will have to be done for each computer.

I must admit, that is where I was thinking of going next.

Example 2 says: You can call AVar with any of the following statements: x = row.AVar x = row.GetValue( "AVar" ) x = row.GetValue( 2 ) I have tried this with object name and variable name, in quotes, out of quotes. I am trying to access a variable of type double and the...

Thanks. I have tried this in quotes, out of quotes, in as many combinations as I can think of. It always seems to report the GetValue function as an illegal variable.

I cannot make "GetValue" work. I have tried the "Help" and using the format suggested there I have the following in the Finish method of an object: GetValue("CallstatsSiteidBefore","PeriodSLA") which causes the following: NewReportApp::CallstatsSiteidBefore%Finish(5): Illegal variable use...

Thanks MKhanA, but I don't think this would work. I am using an Ac7 crosstab so I don't think this will help. Have you ever used the crosstab facility? The help file suggests a properties "TotalColumnPlacement" and "TotalRowPlacement" controls display but I can't find them anywhere.