AnnieRider
MIS
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
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