Hi,

If u have actuate software with you, u can see the Exapmles 
folder, in that u can get the exaples.those are very 
helpful to get knowledge in Actuate

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.

Hi Kashyap Patel, 
Thanks for the answer. We are running Actuate Management 
Console version: 8 Fix 5 just to make sure we talk about 
the same thing. When you talk about the history from the 
completed reports section from management console - do you 
refer to when you open the Jobs tab on the Management 
Console, and then the Completed Jobs tab?
What do you mean exactly by deleting history from the 
completed reports section? Is this physically to go and 
select the check box to select all the records and then go 
to the option 'act on selected jobs' and choose 'delete'?
We had the same occurrence of the scheduled jobs being lost 
now a few times. We have about 20 different reports that 
are scheduled to run every morning. It seems if something 
somewhere gets to big, and then all .roi files are being 
deleted from actuate.  The physical scheduled job itself is 
also a .roi file. I started to clear out all .roi files on 
a weekly basis manually from actuate management console 
under completed jobs and also under files and folders under 
the different folders where the .roi files are being stored 
each time a scheduled report runs. This seems to bypass the 
problem of all the scheduled jobs being lost every now and 
then, but is certainly not a long term solution?
I would really appreciate any help on this to try and solve 
this problem.
Do you know where actuate physically store the .roi files?

Hi,
use the Actuate Help.It is the best Guide.

This will help u  a lot
http://siebeloracle.wordpress.com

Thanks you Ashish. If you know any information please help
me. Once again thanks.

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.

Actuate Foundation Class AcConnection establishes the 
protocol for connecting, disconnecting, and generating 
error messages if a connection fails. 
Database and ODBC connections all use classes derived from 
AcDBConnection, which derives from AcConnection.

AFC acronyms for Actuate Foundation class.

The Actuate Foundation Class (AFC) library contains the 
Actuate Foundation Classes. Actuate Foundation Classes form 
the framework on which report developers build additional 
classes and Actuate reports.

Actuate Foundation Classes are the building blocks of 
report designs. Representative Actuate Foundation Classes 
include those that define charts, controls, data sources, 
frames, images, pages, and sections. Users can derive 
classes from the Actuate Foundation Classes. This contains 
classes and methods that support building a wide range of 
custom reports.

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

Hi,

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

once u deploy the rox file in management consol,then u have 
to go options one is back ground job and second is immedite 
job, if u go back ground job that is schedule job or if u 
go immedite job that now itself execute after that u  have 
got report output format .roi

Hi Shailesh






i Want some assignments on actuate from you.Please do 
advise me asap.what kind of different situations you have 
faced while developing actuate business requirement reports?

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

Fetch method executes No of rows retrieved +1 times at run 
time

Data stream and Data adapters are different.
Data stream is a group of components.It contains a data
source component, data row component and one or more data
filter components(optional).It selects data from the data
source and places the data into data row structure required
by the report.

Data adapter can be a data source component or a data filter
component.It retrieves data from an input source(data
base)and   creates data row.

A data stream is a group of components that provides the 
data for your report. The data stream selects data from a 
data source database and then places the data into the data 
row structure required by the report. A data stream can be 
made up of several types of components. Every data stream 
has a data source component and a data row component. 
Additional, optional components include filters, memory 
buffers, and intermediate data rows. 
A data adapter filters, retrieves, sorts, or otherwise 
processes information. The two types of data adapters are 
data sources and data filters. The relevant Actuate 
Foundation Class is AcDataAdapter.

This is quite simple to implement.

If you have the example which are there in the actuate 
install folder you can get help from it.

For developing this what you can do is put a parallel 
section first and then drag those 2 reports on it, then 
design those report and in the page layout use two flows 
and in the report properties assign the flows to the 
respective reports.

this way you can design it

You can put more light on your requirement so that it would 
be clear.

Any ways for this requirement what you can do is run the 
sequential report 1 by another and get the values from 
those reports and accordingly run your last report.
I think this might help