New Report Sorting

[Rboynton]

I created a new report using the report builder. I set the fields that I want sorted and when I show the report output, it looks like I want. When I attached the new report to the dashboard, none of it is sorted the way I set it up. What am I doing wrong?

[AdmJLovejoy]

I'm running SQL 2005 SP3

[Hemoco]

Edit: this might be the problem http://support.microsoft.com/kb/926292/

You can
1) apply the hotfix
2) change "select top 100 percent" to "select top 10000000" (a really large number)

[Rboynton]

Lansweeper wrote:
Edit: this might be the problem http://support.microsoft.com/kb/926292/

You can
1) apply the hotfix
2) change "select top 100 percent" to "select top 10000000" (a really large number)

I ended up changing the query to "select top 10000000" to resolve this issue. Thanks you for your help.

[Hemoco]

I can't reproduce the issue, the sorting works ok for me with the same SQL code.

Which version of SQL server / service pack are you using

[AdmJLovejoy]

Same issue here as well.

[Rboynton]

Yes, sir.

[Hemoco]

Your query looks ok.
When you run in the report builder does it sort ok there?

[Rboynton]

Here is the query:

Select Top 100 Percent tblComputersystem.Manufacturer, tblComputersystem.Model, tblBIOS.SMBIOSBIOSVersion, tblBIOS.SerialNumber, tblBIOS.Computername, tblBIOS.Lastchanged From tblADComputers Inner Join tblBIOS On tblBIOS.Computername = tblADComputers.Computername Inner Join tblComputersystem On tblADComputers.Computername = tblComputersystem.Computername Inner Join tblComputersystem tblComputersystem1 On tblComputersystem1.Computername = tblBIOS.Computername Order By tblComputersystem.Manufacturer, tblComputersystem.Model, tblBIOS.SMBIOSBIOSVersion Desc

I selected to sort ascending on the manufacturer, model, then descending on the BIOS version.

[Hemoco]

Could you post your sql query and a screenshot of the webpage please.