Reporting

Pardon the mess… Still Under Construction…

Reporting, analytics and the information that can be distributed can have a major impact on an organization. Deciding which reporting method to use can be a tough task. Many reporting options exist, and by focusing on which one suits a companies needs can increase the success of the overall business intelligence environment. I have used the following options multiple times throughout my career and I along with others discussed these options and determined which reporting tool was best to use for the situation. For standalone reporting that might be used enterprise wide I have often used Crystal Reports, within an application the choice of VS Report Server / SSRS are options I’ve taken.

Crystal Reports

Crystal Reports is a popular Windows-based report writer solution that allows a developer to create reports and dashboards from a variety of data sources with a minimum of code to write.

Visual Studio Report Server

SQL Server Data Tools (SSDT) is a Microsoft Visual Studio environment for creating business intelligence solutions. SSDT features the Report Designer authoring environment, where you can open, modify, preview, save, and deploy Reporting Services paginated report definitions, shared data sources, shared datasets, and report parts.

SSRS Sequel Server Reporting Services

Report Builder is a tool for authoring paginated reports, for business users who prefer to work in a stand-alone environment instead of using Report Designer in Visual Studio / SSDT. When you design a paginated report, you’re creating a report definition that specifies what data to retrieve, where to get it, and how to display it. When you run the report, the report processor takes the report definition you have specified, retrieves the data, and combines it with the report layout to generate the report. You can preview your report in Report Builder. Then publish your report to a Reporting Services report server in native mode or in SharePoint integrated mode (2016 and earlier).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s