[quoted text, click to view]

Here's one walkthrough, with (one hopes) more to follow:

http://www.highlyobscure.net/howto/sorttablewithparameters/sorttable.htm

--
"Fool: Then 'tis like the breath of an unfee'd lawyer; you gave me

[quoted text, click to view]

This is a report of your own using the technique in the howto, yes?
The report in the howto doesn't have fields "customer code",
"firstname", or "lastname".

You may be running into the "silent failure" feature of Reporting
Services. That is, in many cases when something is wrong, nothing in
particular happens. It doesn't work, but RS doesn't tell you that
anything is wrong either.

I have reports running here that use the technique shown in the howto,
and that sort properly on string and integer fields in the same report.

I'd look at the parameter specification for customercode. Is the field
name spelled properly, is it really in the parameter list, are Label
and Value reversed in the parameter list for customercode, and so on.
If it's sorting at all, then the problem is unlikely to be in the
sorting expression for the table, but I'd take a look at that too just
to be sure. These nitpicking sorts of things have cost me many many
hours, and brought me to the edge of despair on some occasions ("bring
back Crystal! We can't ship this #!@**#!").

But to be fair to the Microsoft and the RS dev team, many of the
problems were caused by my not typing the right things into the right
little box somewhere. Learning all the right things for all the little
boxes takes a while. Learning to recognize an error when it is staring
you in the face takes longer. Don't give up.

hth,

http://www.codefez.com/Default.aspx?tabid=49&ctl=CatalogItemDetails&mid=400&CatalogItemID=23&CatalogID=1

http://tinyurl.com/6b6nt


http://www.amazon.com/gp/product/product-description/0976033607/ref=dp_proddesc_0/103-4726323-7886222?%5Fencoding=UTF8&n=507846

http://tinyurl.com/49o24


floyd

[quoted text, click to view]