Jump to content
Changes to the Jaspersoft community edition download ×

groupby and orderby in datasource


Recommended Posts

By: jose - jose4

groupby and orderby in datasource

2003-03-28 05:01

Hi Everybody!


I'm using datasource for my report

How can I use groupby and orderby

when using datasource?






By: Giulio Toffoli - gt78

RE: groupby and orderby in datasource

2003-03-28 07:31

you can supply a preordered datasource (if your data source is a result of a query, you must simply add your order by in the query statement).


The group by is obtained using groups. Open the groups form and add a group. What you want grouping is set using groupExpression. You can do a group using simple expression (like a field) or complex expression (i.e. a group is a range of values...)

You can do calculations using variables and setting the calculation reset to group and selecting the group that you are considering. In this way you can handle more than one level of group by.


I hope this helps you


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...