| Group By and Aggregate functions possible in SQL? [message #52516] |
Tue, 28 June 2005 18:04  |
Eclipse User |
|
|
|
Originally posted by: no.spam.com
Does anyone know if there are limitations on SQL in BIRT? In other words,
if working with a flat data source is something like
SELECT Company,SUM(Amount) FROM Sales
GROUP BY Company
even possible?
|
|
|
| Re: Group By and Aggregate functions possible in SQL? [message #52544 is a reply to message #52516] |
Tue, 28 June 2005 19:01  |
| Eclipse User |
|
|
|
Originally posted by: dxmedina.west.com
Not sure about flat files. But any odbc connection can be queried using
grouping and functions to generate a data set for the report.
BIRT has its own reporting functions outside of the SQL query submitted to
generate a data set. Given a data set such as a flat file. The BIRT report
can be designed to do grouping and utilize functions such as grouping, sum,
count, etc.
"Mark S." <no@spam.com> wrote in message
news:910d9ed947fbb3a6e3486e6606f69a9b$1@www.eclipse.org...
> Does anyone know if there are limitations on SQL in BIRT? In other words,
> if working with a flat data source is something like
>
> SELECT Company,SUM(Amount) FROM Sales
> GROUP BY Company
>
> even possible?
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.02829 seconds
] 
Search
Help
Register
Login
Home
