Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between
-using Group by in the SQL of the report
-having a Group section in the report
- 2 Answers
- 8967 Views
- HCL, I also Faced
- E-Mail Answers
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 |
Hi, I am Anna and new to actuate programming. I am trying to learn the tool on my own, if any one could provide any helpful websites or training centers in NJ area will be greatly appriciated. Thanks in advance.
Can we define global methods in a report?
How can i make use of Multiple Input Filter, the case is, i have two Datasources with different queries with a common field. i need the merge set in datarow of MultipleInputFilter. how can i make it.? please provide with clear example i'm new to actuate. thanks in advance.
What is page level security?
Can we connect to 2 different types of database through the same report?
How do we have left -right flow , normally its top-down flow
What property you use to Hide a control at runtime?
what is data stream and data adaopter is it same r different? tell me?
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.
What is AFC? Where we Use AFC in Actuate?
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?
Teradata 
