Actuate Interview Preparation Guide

OnRead( ) – can manufacture data based on values in the fetched datarow

OnRow( ) – extracts requested data from the datarow object; normally just used to obtain a value for the ValExp but may access all values in a datarow

It is for right to left. Reverse logic has to implement for
left to right
------------------------------------

First Define one gobal variable(g_rw_wdth) as double,
Static, publice.

And now assume that in a frame you have got two dynamic
text.

Now in 1st text box onRow method write following code:
g_rw_wdth = 0
IF ISNULL(row.getvalue("field1")) then
g_rw_wdth = g_rw_wdth + (me.size.width/1440)
end if

Now in 2ndtext box onRow method write following code:
IF ISNULL(row.getvalue("field2")) then
g_rw_wdth = g_rw_wdth + (me.size.width/1440)
else
Me.Position.X = Me.Position.X - (g_rw_wdth * OneInch)
end if
In these fashion you can have more dynamic text.

Now if 1st text box the value is null automatically the 2nd
text box will shift to place 1st text box.

And so on.

We can use finish method to hide a control at runtime.

You have lost all Scheduled jobs list because you had
cleared all history from completed reports section from
management console,
So pls remember before deleting history from completed
section remove the check mark of SCHEDULES and then clear
history.
Since you can't recover scheduled jobs So next time
whenever you Schedule the job copy the location and job
name and save it to Excel or text file.

To Change Color of Frame

override start

me.BackgroundColor = skyBLUE
OR
BackgroundColor = RGB(180, 225, 228)

''-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x
To Change Color of a specific Control

Override start

dim Control1 as AcTextControl
Set Control1 = me.getControl("MyControl") ''name of control
Control1.BackgroundColor= Blue
OR
BackgroundColor = RGB(180, 225, 228)

AFC Actuate foundation class designed to hold an ordered
collection of objects.

All the commonly used components in the AFC library have
been extended in to the sssiebel library.
Sssiebel.rol known as the Siebel library. It is derived
from afc.rol and contains all the base classes for the
sscustom library.
The use of a component from the AFC library, rather than
the sscustom library, is an
exceptional situation and applies only to detail charts.
AFC components should not be used
directly in Siebel reports except in this specific
situation.

there two types of filters
1. single input filter
2. multiple input filter

connecting the report for 2 databases we use multiple input
filter.
for example your report need two database for geting data u
have to use multiple input filter.
base class for this filter is
AC single inputfilter
AC multiple input filter
i will give example for in your database u have abc,xyz two
databases you need data from these two databases so u have
use multiple filter. normally single input filter we do not
use.

place the connection in the connection slot --use "ODBC
connection" option here.
while placing the data source in the data stream
choose "Stored prodedure data source componant" ,click on OK
Place the data row in the data row slote under data stream .
Now double click on the data stream go to Property-Stored
Procedure Def ,click on the browse button ,
then it will automatically opens the SP in your database ,
just select the stored procedure (SP) which u want

Just Try to run Axis Client first which is in
ServerIntTechnology.In that U can find code for execute and
job status.

Number of rows which are retrieved from database query,that
many times Fetch method get executed at run time.