|
Re: New to Cross tab - group sort order on a parameter [message #1722266 is a reply to message #1722259] |
Wed, 03 February 2016 16:21 |
|
On 02/03/2016 09:06 AM, james allen wrote:
> New to Birt, so kinda running before I can walk.
>
> Have a crosstab with :
> areaid, customerid, customername , postcode.
>
> Totalling nettsales for each customer by year.
>
> To show details (name & post code) for a customerid I've had to create
> a grouping for each field for the datacube and included all groups on
> the crosstab.
>
> Besides not being clear on how the default sort order is achieved, I've
> managed to get a crosstab to be ordered by postcode (ascending
> alphabetically) - as default.
>
> I've added a sort on: PostcodeGroup/postcode, with
> key["Nettsales_postcodegroup/Postcode"] - Descending, to reorder the
> report so customers descend by yearly totals.
>
> Is there anyway to either:
> toggle the "group level" sort on\off with code
> or
> assign the sort with code?
>
> The plan is to link a report parameter to switch between the two sorts.
>
> I've search for dynamic crosstab sort beforefactory and can't find much
> that makes sense - admittedly don't have enough knowledge to sus this
> one out.
>
> Any advise welcome.
>
> James
>
>
Ask BIRT questions in the BIRT forum.
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03097 seconds