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
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 |
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 |
what is data stream and data adaopter is it same r different? tell me?
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?
What is data stream and data adapter is it same are different? Explain?
how many times executite the fetch method at run time?
What is data stream and data adapter is it same are different?
Hi Friends, I am planning to learn actuate tool by it self .... can u suggest me any examples to practise this tool.
Can we define global methods in a report?
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?
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..
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?
which cmponent has onRead method and what it is used for?
What are actuate smart reports?