Grouping
in [Reports]
|
Prev: Report request works, then doesn't work
Next: Report in Webarchive Format does not display correct in Outloo
From: James Terrington on 30 Jun 2008 02:41 I have a query that results in the following data Account No Amount 4110 500.00 4120 600.00 5000 77.00 5300 60.00 I would like to create a grouping that will allow me to specify the grouping ranges that I require so I end up with Account No Amount Income 4110 500.00 4120 600.00 Income Total 1100.00 Expense 5000 77.00 5300 60.00 Expense Total 137.00 I can create groups on preexisting fields, but at a complete loss to figure out how to specify the group range myself (even if it is possible)?? Thanks in advance. James
From: TheRealRobbie on 30 Jun 2008 03:39
Hi James, You can also, instead of just a fieldname, specify an expression as a group. Suppose you want split just by the first digit of the salary, you could first convert to varchar and then take the first character as the grouping expression. You can also use case statements, so any group split-up should be possible. Regards, Rob "James Terrington" wrote: > I have a query that results in the following data > > Account No Amount > 4110 500.00 > 4120 600.00 > 5000 77.00 > 5300 60.00 > > I would like to create a grouping that will allow me to specify the grouping > ranges that I require so I end up with > > Account No Amount > Income > 4110 500.00 > 4120 600.00 > Income Total 1100.00 > > Expense > 5000 77.00 > 5300 60.00 > Expense Total 137.00 > > I can create groups on preexisting fields, but at a complete loss to figure > out how to specify the group range myself (even if it is possible)?? > > Thanks in advance. > > James |