I have a invoice reprint report that I'm using to reproduce invoices for a group of customers. The Stored Procedure sorts the raw data according to the Customer's name, but when the report comes up the results are not sorted. Any ideas what I can do to correct this
David
Report Sort Order
Hot Topic
- unknown error reports
- Remote Connection to file-based Express DB
- Breaking up parametersT
- Login failed for user 18456 when using asymmetric key for login
- (MDX) EXISTING operator - inconsistent behaviour when using subcubes?
- SQL Express user permissions?
- Export to Excel failed with ReportItems and sub report
- Report Catalog Database
- SQL Instance name in web script
- SQLServer 2005 Drillthrough Action does not work with OWC 11 Pivot Table
SQL Server
- Unable to start NS instance service
- Creating a Script component using SSIS Object model
- Complicated Query with Subs for Grand Total
- problem with Transfer SQL Server Objects Task
- Importing a comma delimited file
- database diagram in sql 2000
- Using custom assembly problem. Help!
- Yukon SP performance issue
- What interface does Management Studio use?
- SSIS Send Mail task problem
Report Sort Order
dontbeaquitter
C03N
Arrrgh. Quite possibly the worst user interface design imaginable for getting to that properties dialog.
So, what's one to do when it just doesn't work
I have an Analysis Services resultset in a table. One of the columns is "Age", and I've selected Field!Age.Value as the "Sort on" value. Problem is, it's sorting on the STRING representation of the value, not the Integer representation (so it goes 0,1,10,11,...,2,20,21, ... etc).
What's the secret to getting the sort to work on the VALUE of the column rather than the representation of the value
Changing the Sort On to CInt(Fields!Age.Value).ToString("00") didn't help. In fact, near as I can tell, the Sort On setting is completely ignored - no matter what I set in there, it sorts the data by the string representation of the first column (which just happens to be Age).
The resultset from Analysis Services is correctly ordered, so I know RS is uselessly re-sorting the data - I just can't figure out how to get it to sort the way I want - everything I've tried has had no effect at all.
Update: I did eventally get RS to actually sort the data - something was messed up in the grouping for the table (there shouldn't have been any). After deleting all groups, and changing the sort on to CInt(Field!Age.Value).ToString("00") it actually does sort the data.
sn1022
Sort the Detail Data
Add sorting to the detail data in the table to sort by order date.