Organize reports in Report Manager SQL Server


show more Folders and subfolders in your SQL Server database are useful tools for keeping your information organized. You can orient data by the different departments in your company. While preparing reports, it's useful to consider how security may influence your decision. In this online video, you can see how organizing reports in Report Manager can streamline and restrict access to information within your group. show less
please wait ...

Organizing reports in Report Manager

So I've created a lot of reports and the Report Manager website is becoming a mess. These need to be organized. The fundamental method of organizing reports is like organizing any other document. You create folders--when that's not good enough, subfolders. We've already done this a couple of times in the course. You just create a new folder directly from the Bar and Report Manager and call it whatever you want. However, it is worth thinking about your best top-level structure. There are no official recommendations as it's so dependent on your organization.

You might create folders to strictly organize your reports by departments, so have a Sales folder, Purchasing, Manufacturing, Accounts. Or you might go by purpose. You might create one folder for financial reports, another for inventory, another for personnel. It's whatever makes the most sense. You might even create a Work In Progress folder for your own experiments. However, I would say that the most common structu...

Organizing reports in Report Manager
Video duration: 3m 1s 3h 44m Advanced

Viewers:

Folders and subfolders in your SQL Server database are useful tools for keeping your information organized. You can orient data by the different departments in your company. While preparing reports, it's useful to consider how security may influence your decision. In this online video, you can see how organizing reports in Report Manager can streamline and restrict access to information within your group.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...