That one is tricky.

I first thought I need to say "No", because I could not imagine a function which will return a random value - at least inside XSL without EXSLT enhancements or within a dataset expression. But stop: What is random enough is the part of the acesstime within seconds and smaller.

Create a new column with the name Random and Type "Calculated Column" Set the Expression to:

convert((([ticks:now] - [ticks:today]) / 10000), System.Int32)%(count(UserDefinedrowID))+1

This returns a number between 1 and the number of records.

If you now create a custom XSL file with the Token2 XSL Editor, change

    <xsl:variable name="currentData" select="udt:Data" />

to

    <xsl:variable name="random" select="udt:Data[1]/udt:Random" />
    <xsl:variable name="currentData" select="udt:Data[position()=$random]" />

Eureka!

Hi guys,

How would I create a completely random number (within the range of the number of records) to do as you have done above (new field with a calculated value) to set as the sort order, so that my records are simply displayed in a random order?

Thanks!