Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting a Table

Status
Not open for further replies.
Jun 23, 2008
55
GB
Hi

I have a table of data that I have set as sorted on one field/column (Name) because I want this to be the default when the report is run.

I have put Interactive sorts on two other columns (Telehone & Mobile Phone) so that Users can order by those records where there are no Contact Numbers.

My problem is that the Interactive sorts don't seem to override the Default and so when I sort by Telephone, then Shift click and sort by Mobile, I get the reults grouped by Status then by the other two fields.

When what I really want is the whole table to start with all those that have no Telephone or Mobile number, regardless of the Status.

Also is there any other way to sort on two fields other than the User using the SHIFT key when viewing the report, our Users will be new to SSRS and I would have to include instructions in the header on using the SHIFT key, which I don't want to do as it takes up space and looks messy.

Thanks
Annie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top