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?

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

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

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

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

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

Does anyone know how to hide row and column totals?

Ac Ver 7 Oracle db v8i I have inserted a cross-tab into the after slot and, on page one the cross-tab displays fine to a point but is ended half way though a row and doesn't display in subsequent pages, even though there are clearly many more rows. Is it that the cross-tab 'wizard' is anything...

V8.5 Oracle 9 I am trying to share a string array across a report and a sub report. On declaring the array again in the main report the report keeps coming up with a subscript out of range error but, of course, a ReDim resets all elements to an empty string. Any help or suggestions?

I am trying to set a variable in a frame object from the datastream Fetch method. Can anybody help with the syntax as I have tried dot notation as follows and it doesnt work. FC_sec_Rep1.Frame1.NoReport = True Im on the point of finding a tall building to throw myself off!!

Ac Ver 7 Oracle DB I am trying to format the point labels of a chart to show whole numbers. Cant find anything in properties. Anyone know how?

Hi Don't know if this is the forum for this but I'm writing an Oracle 8 SQL query as below and want to restrict the output to just the top 10 groups. Does anyone know the way? SELECT LOCATIONS.DESCRIPTION, COUNT(*) FROM WORKORDER, LOCATIONS WHERE WORKORDER.LOCATION = LOCATIONS.LOCATION AND...

I am using CR8.5 on an oracle 8 database. Using the pdsodbc.dll driver the report works fine but converting to pdsora7 in preparation for system registration causes missing data. The missing data is in a table which is aliased and removing the alias table seems to cure the problem. Any help...

Ac7 Oracle DB My report has a parallel section with 2 reports and flows. No matter what I do I keep getting a verify error. Firstly, what does it mean and what can I do to solve it?

Win 2k CR V8.5 Oracle DB I have a report that builds a table with three subreports as well as data from the main report on the details line. The detail line looks like this: MAIN, MAIN, SUB1, MAIN, SUB2, SUB2 SUB2, SUB3, SUB3 SUB3 It looks great on the page, on the screen and when exported...

I have a parallel report with eight subs which fails with the following: Running... Starting... Generating SelectionReport002.roi ... Connecting... Generating... (Previous line repeated 9 times.) Basic Error: 6 Module: C:\Program Files\Actuate7\ErdPro\afc\pagelist.bas Line: 1302 Use of a Null...

CR v8.5 Oracle DB This formula returns a null value perhaps 80% of time. Cannot see what is wrong. HELP!!! Shared NumberVar Costs; Local NumberVar Line; If {WORKORDER.ACTFINISH} >= {?Pm-?Lower} and {WORKORDER.ACTFINISH} <= {?Pm-?Upper} Then ( If {WORKORDER.ACTLABCOST} > 0 Then...

I am running Actuate 7 with an Oracle DB running reports over the web. A report that runs perfectly well within the development environment fails on the web server. The job log shows the failure as follows: Caught Java Exception -- java.io.IOException: truncated initialization vector The...