A quick guide to Report Builder

Simon Jones explains how to put business information into the hands of your employees thanks to Report Builder.

Report Builder 2

Microsoft SQL Server is great for storing departmental or company data. It is fast and reliable, with the capability to expand from a hand-held device to a data centre. It can hold virtually any amount of data but what about getting data out again?

SQL Server Reporting Services together with Report Builder make it very easy to create good-looking, easy-to-understand reports and publish them so everyone in your company can have up-to-date, reliable information whenever they need it.

[img id="159463f"]Report Builder new report[/img]SQL Server Reporting Services (SSRS) produces reports to be viewed on screen, printed on demand or exported in any of several different formats.

You can, for instance, export a report to Excel for further analysis or to a PDF file, if you wanted an unalterable copy for an archive. You can also set up a subscription to any report to have it emailed, to you or anyone else, or output to a designated folder, on a regular schedule.

Advertisement
Advertisement - Article continues below
Advertisement - Article continues below

This option is very useful for getting the weekly sales figures sent to you automatically every Friday evening or having monthly reports generated at 08:00 on the first day of every month, ready for your 10:00 review meeting. Each user can easily control their own subscriptions so they get the information necessary to do their job when they need it.

Every edition of SQL Server from the free Express edition to the top-of-the-range Parallel Data Warehouse edition uses the same reporting language and tools.

Technical users can define reports using the powerful Business Intelligence Design Studio (BIDS) which is based on Visual Studio but, for less technical users, Microsoft makes Report Builder 3.0. Both BIDS and Report Builder are free for any licenced SQL Server users.

[img id="159466f"]Report Builder step 2[/img]Report Builder is perfect for self-service report generation. If a user wants to create a new report, for themselves or their department, they don't have to wait until the IT department has time to service the request.

With very little training, users can create their own reports and publish them for use by their department or the rest of the company.

Click the link below to read the full white paper.

Featured Resources

Digitally perfecting the supply chain

How new technologies are being leveraged to transform the manufacturing supply chain

Download now

Three keys to maximise application migration and modernisation success

Harness the benefits that modernised applications can offer

Download now

Your enterprise cloud solutions guide

Infrastructure designed to meet your company's IT needs for next-generation cloud applications

Download now

The 3 approaches of Breach and Attack Simulation technologies

A guide to the nuances of BAS, helping you stay one step ahead of cyber criminals

Download now
Advertisement

Most Popular

Visit/operating-systems/25802/17-windows-10-problems-and-how-to-fix-them
operating systems

17 Windows 10 problems - and how to fix them

13 Jan 2020
Visit/microsoft-windows/32066/what-to-do-if-youre-still-running-windows-7
Microsoft Windows

What to do if you're still running Windows 7

14 Jan 2020
Visit/web-browser/30394/what-is-http-error-503-and-how-do-you-fix-it
web browser

What is HTTP error 503 and how do you fix it?

7 Jan 2020
Visit/policy-legislation/general-data-protection-regulation-gdpr/354577/data-protection-fines-hit-ps100m
General Data Protection Regulation (GDPR)

Data protection fines hit £100m during first 18 months of GDPR

20 Jan 2020