I have a report that when I run it in BIDS 2008 and in Report Manager (MSSQL 2008 R2), the report sorts fine with both columns....first sorting by column 1 and then by column 2.
When I upload this report on to a machine running Report Manager (MSSQL 2008), the report will sort by the first column, but not the second column.
Appears to be something between versions....but there has to be a way to make this work with MSSQL 2008.
In order to get it to work in the template for MSSQL 2008 R2, the tablix is sorted by both columns AND i select one of the groups (column labeled machine), select to sort it by machine and then by the second column (column labeled start time). So sorting is set in both places....
Any ideas on how to get this to work on Report Manager 2008? I checked collations on the databases and they are the same...did not know if that would cause it to act diffferent.