Actuate Question:
Download Questions PDF

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

Answer:

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.

Download Actuate Interview Questions And Answers PDF

Previous QuestionNext Question
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?Can we define global methods in a report?