What is the difference between
-using Group by in the SQL of the report
-having a Group section in the report
Answer Posted / 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 View All Answers
What is afc?
What is data stream and data adapter is it same are different?
What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?
Copy ".roi" file of management console to another path of management console's folder using ".rox" file. or any command of actuate. Is it Possible? if Yes then pls give me Example.
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?
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?
Explain difference between onrow and onread method?
I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.
How do you design a report which has multiple child datastream (horizontal seq)
What is data stream and data adapter is it same are different? Explain?
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?
How to do performance tunning of reports?
Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?
Where we use afc in actuate?
Where do we use ACvisitor class?