Natural order with crosstab

rbuser

Hi,
i create an array with crosstab and JITpipeline, i use string value.
I want this order in my row: c,d,a,e,b,f

but when i create it with crosstab, it 's in alphabetic order :
a,b,c,d,e,f.

how have a 'natural order' without :

return a value in JITPipeline in the order that i desire

or

modify the source code so that the calculated matrix is built in natural
order.

thank you.



--- posted by geoForum on http://delphi.newswhat.com

nardmoseley

- please post using your real name, that is a requirement of this newsgroup

- I believe I have been answering your questions via
support@digital-metaphors.com on this same topic

The crosstab component performs two primary steps:

1. Traverse the data and build a multi-dimensional Matrix that contains the
crosstab calculations.

2. Traverse the Matrix and render the crosstab output to the page

During step 1, the Matrix is built in sorted order. There is currently no
option to build the matrix in natural order.

As I explained before, we use customer feedback to drive what goes into the
product. No other customer has ever requested to have the crosstab build the
matrix in natural order. That is something that we can consider adding to a
future release.

As explained before, there are some options for working around this
limitation.

I am the Chief Architect of ReportBuilder and one of the lead developers. I
did not write the crosstab, but in response to original email to support@, I
did review the relevant source code.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Hi DM,
ich you are on crosstab, my wish will be to sort on row total, so the
best/less will be on top.
Actually it is a little bit complicated. I make it with an temporary sql
table and a build a sort string wich i add to the row caption.


--
best regards
chris (EULANDA)

www.eulanda.com
ERP SOLUTIONS

rbuser

Hi Nard,


Uhhhmm... E-mail 20070311 ;-)

Regards,
Jeroen R?ttink

nardmoseley

I just reread your email, it is long, so perhaps I am missing something. I
see that you request 'control over order of rows and columns', but I do not
see a request for 'natural order'. Implementing natural order requires not
executing any logic to control the order (essentially skipping the logic
that is in place now), where as providing control over the order to me is a
different animal - more like firing an OnCompare event that enables you to
return the order.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

I reread my mail as well and you are right. OnCompare() would be better
although it could work in that example. Things that are difficult
(impossible?) to solve using natural order are the cases when cell values do
not exist like the blank cells in following example:

------x1------x2------x3
y1 blank blank 89
y2 blank 1 4
y3 21 39 56

Regards,
Jeroen R?ttink