Toad World® Forums

TDM Report needs to sort dbo(s) correctly in reports - Bug Report


#1

TDM Report needs to sort dbo(s) alphabetically regardless of character case…. In the attached word document you will see procedures that are out of sort for TDM reports, where they are not for Toad SQL Server or Microsoft SQL Server Management Studio.

Please include this fix in the upcoming BETA cycle or as soon as possilble…

cid:image001.jpg@01C7CADC.1398B7E0
Hank FreemanContract Data /Systems Architect | Video Gaming Systems
Scientific Games International
1500 Bluegrass Lakes Parkway ** | Alpharetta, GA 30004**
image002.jpeg


#2

Hi Hank,

Good news - it’s already been fixed for the upcoming Beta. (CR# 61 515)

Thanks!

Regards,

Vladka


#3

Upon testing this issue on the 3,.4.2.6 BETA it was determined that this issue is still outstanding… Meaning the dbo(s) should be sorted regardless of character case. Currrently UpperCase is being sorted ahead of lowercase and therefore they are seperate, where they should be sorted without concern for Upper or Lower case.

Details available upon request.

Hank Freeman
hfreeman@msn.com


#4

Hi Hank,

We’ve just checked it out. It seems to work fine for us in the BETA 3.4.2.6. Please find attached a screenshot - compare the order in Model Explorer and in the report where the procedures have been sorted automatically.

Please make sure you have the checkbox Sort Objects Alphabetically selected in the Report Wizard | Options step.

Thanks.

Regards,

Vladka + Dave
sort_proc.png