1. Explain Difference between onRow and Onread method?

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

2. How do we have left -right flow , normally its top-down flow?

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.

3. What property you use to Hide a control at runtime?

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

4. We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

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.

5. I generated one report design time i
can color green. at run i want bule how to change dynamically? and which method i can over write?

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)

6. What is AFC? Where we Use AFC in Actuate?

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.

7. What is the filter?

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.

8. How to call a stored procedure from a report?

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

10. How many times executite the fetch method at run time?

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

Download Interview PDF

11. What is data stream and data adaopter is it same are different? explain?

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.

12. How to implement the parallel report?

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

13. How to generate a report by getting values from two reports. the generated report should contain the 5 values of first report and last 5 values of second report?

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.

14. What is the difference between
-using Group by in the SQL of the report
-having a Group section in the report?

An Actuate Group Section will group similar records
together by a key field. A query pulling all the records
from a table with 100 records and grouping by State or
Province will still display 100 records on the report. No
data is lost or aggregated.

A SQL Group By will aggregate data being pulled from a
table. Grouping By State or Province will result in
somewhere less than 100 records being delivered to the
report. The results most likely will be 5 records
containing a count and the state name: DL-20; MH-10; BR-5,
WB-25, and MP-40. A Group By processes the data and creates
new information about that original data.

15. Can we define global methods in a report?

Yes we can define global methods in eRDPro.We can put our
procedure and function in .bas file and use.

16. Can we connect to 2 different types of database through the same report?

Yes, we can use any no. of database in a single report to
extract data. We have to use different report section for
this purpose.

17. What is report bursting?

Report bursting is the process of creating a single report
object executable
(.rox) file that generates multiple report object instance
(.roi) files.Actuate iServer supports report bursting only
if the report runs as a scheduled
background job, or asynchronously. If you run a burst
report synchronously,
Actuate iServer displays an error message because it cannot
determine which report to display.

18. What is page level security?

It is a security to a report page at the User level.In PLS,
user can able to see only those pages to which he has given
a privelege to access.

19. Which cmponent has onRead method and what it is used for?

DataRow Component has OnRead method.
To manipulate the Rows which are returned by the query or
add the new rows or expressions at runtime we can use
onRead method.