Hi

I have just joined as I am using CR 9 now in my work and have never used it before.

I am currently updating an existing report that when the users run it they can pick certain parameters to sort the data by.

I went into Formula Fields > Sort > Edit, and found this statement:

select {?@SortField}
case "Parameter Name" : {view.Column}
case "Parameter Name" : totext ({view.column})
case "Parameter Name" : {view.column}

These are the three parameters that can currently be used to sort. I have added a few more and need to change this statement to make them actually work.

The problem is one of my sorts requires multiple columns and I can't figure out the syntax to do it in this statement.

In a normal query you would do this:

Select ....
From....
Order by x, y

But I can't do this in this statement. Have tried different things and just get errors.

I appreciate any guidance on this issue.

Thanks
 
G

Ok thanks hilfy i'll see what I can do with that.


Thanks

G


Edited by Grifter - 02 Jun 2009 at 8:41am