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

Answers were Sorted based on User's Feedback



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

Answer / lingaraj

Using the Group by in the SQL returns the data form the
database which is grouped by that attribute.
If u r not grouping through the SQL if u wan to group in
thr report from the front end through actuate, u can use
the Group section.

Is This Answer Correct ?    1 Yes 2 No

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

Answer / sanjeev kumar sinha

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.

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More Actuate Interview Questions

what is data stream and data adaopter is it same r different? tell me?

2 Answers   TCS,


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?

0 Answers  


What is data stream and data adapter is it same are different? Explain?

0 Answers  


how many times executite the fetch method at run time?

2 Answers   EDS, IBM, TCS,


What is data stream and data adapter is it same are different?

0 Answers  


Hi Friends, I am planning to learn actuate tool by it self .... can u suggest me any examples to practise this tool.

1 Answers  


Can we define global methods in a report?

2 Answers   L&T,


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?

0 Answers  


how can i 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 any one guide me on this. pls... awaiting for the rply..

1 Answers  


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?

0 Answers  


which cmponent has onRead method and what it is used for?

2 Answers   TCS,


What are actuate smart reports?

3 Answers   L&T,


Categories