CrossTab Sorting

rbuser

Hi

Is there a way to turn off the CrossTab A-Z sorting? My Query has the order
im after and I just want the component to show the results 'as is'. Any
ideas?

nicocizik

Hi Anf,

Which version of ReportBuilder are you using? ReportBuilder 11 and later
includes support for no-sort crosstabs leaving the natural order when
generated.



Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Version 10.09.

nicocizik

Hi Anf,

This option is not available for RB 10.09.

One workaround is to create a new field in your dataset containing letters
or numbers (a-z) and setting that as the key field. Then the crosstab
component will use that as the sort order.

Another option is to upgrade to the latest version of ReportBuilder. We
have added numerous useful and powerful features to the product since the
release of 10.09. Take a look.

http://www.digital-metaphors.com/rbWiki/General/What's_New/RB_12

http://www.digital-metaphors.com/rbWiki/General/What's_New/RB_11

Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

"Anf" wrote in message news:4d6d72f5@mail....

Version 10.09.

rbuser

Hi Nico

But if I add the numeric field I cannot hide it can I?

nicocizik

Hi Anf,

Just because you add a field to your query/table, does not mean that you
need to add it to the Crosstab itself. The crosstab will sort based on
the key field of the dataset regardless if it is used or not.


Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

How do you sort based on a field the cross tab is not using? my query
results are exactly how i need them how do i then show this?