Report Model Fields Sorter

Presentation

RMSorter a small fix or add-in to Microsoft Business Intelligence Development Studio, especially for Report Model projects. Some may have notice that it’s missing features like sorting attributes inside an entity. Surely, for an entity of about 10 or 20 attributes, a quick drag drop is sufficient. But as soons as you approach hundreds of attributes, what’s quite common in production environments, it’s not easy to manually sort them. To make the matter worse, BIDS freeze while drag droping. Hopefully, the source code behind a Report model is at XML format. The only challenge then is to master the file’s architecture.
RMSorter is based on that principle and will help you sort very quickly and efficiently your report models.

Download

To download RMSorter please click <HERE>

Installation

As all usual windows msi files, just double click on the file you’ve downloaded at the step above, and follow the installator instructions.

Use

Steps:

• Get to the installation directory (commonly “Program Files\RMSorter”)
• Execute the only file in the directory “RMFieldsSorter.exe”. This action will launch RMSorter’s main window as shown below:
  
• Click the “choose” button and select the .smdl file corresponding to your report model
• Click the “sort” button to launch the task. A “done” confirmation message will appear as soon as the task is completed. The sorted file is saved under “sourcesmdl_sorted.smdl” in the same directory as the source one.
• Click the exit button to exit the window