q2K BHP
Black History Portal
THE BHP WIRE —
HIDDEN TRUTHS
What's New!
THE JOURNEY THROUGH TIME

Explore Black History

Explore the people, places, events, achievements, struggles and stories that shaped our journey.

✊🏾

Civil Rights

Movements, leaders, victories and the continuing fight for equality.

⚙️

Black Inventors

Innovation, patents, science, technology and world-changing contributions.

🏆

Sports

Pioneers, champions, Negro Leagues, records, activism and excellence.

♟️

People

Meet the people whose lives, choices and achievements shaped the journey.

📍

Places

Black towns, communities, institutions and places where history happened.

📜

Events

Moments that changed communities, movements, institutions and the nation.

Enter a person, place, event, or topic.
MY'STORY

The MOVE Fire

This is a personal recollection on the Move fire on May 13, 1985 Philadelphia police fired thousands of rounds at the MOVE house, city officials approved dropping an explosive device on the roof, the resulting fire was allowed to burn, 11 people—including five children—died, and 61 homes were destroyed. Philadelphia City Council later called it a “brutal attack carried out by the City of Philadelphia on its own citizens” and acknowledged that no individual faced criminal consequences for the bombing. One timeline correction worth preserving for the BHP record: the major previous MOVE-police confrontation was August 8, 1978, about seven years before the bombing, not a year or two earlier. Officer James Ramp was killed, other police and firefighters were wounded, nine MOVE members were later convicted, and television cameras recorded police beating Delbert Africa during his arrest. The 1985 MOVE Commission later specifically criticized city planners for failing to adequately use lessons from that 1978 confrontation. And that actually strengthens the point you’re making: 1985 did not happen without precedent or institutional memory. There had already been a deadly confrontation with MOVE, years of conflict, negotiations and police involvement before Osage Avenue.

MORE →
BLACK FACTS
The Truths They Never Taught You...

Wilmington 1898 — An American Coup

Wilmington, North Carolina once had a thriving Black middle class and an elected interracial government. In 1898 white supremacists used violence to overthrow that government, kill Black residents and drive many others from the city.

MORE →
BHP gathered finds from its connected research sources. Showing the 4 strongest Black History matches.
← BACK TO RESULTS
Wikipedia

SQL Server Reporting Services

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

Administered via a web interface, it can be used to prepare and deliver a variety of interactive and printed reports. The SSRS service provides an interface into Microsoft Visual Studio so that developers as well as SQL administrators can connect to SQL databases and use SSRS tools to format SQL reports in many complex ways. It also provides a 'Report Builder' tool for less technical users to format SQL reports of lesser complexity.

SSRS competes with Crystal Reports and other business intelligence tools.

History

[edit]

Reporting Services was first released in 2004 as an add-on to SQL Server 2000. Subsequent versions have been:

Packaging

[edit]

Use

[edit]

SQL Server Data Tools for Business Intelligence (SSDT BI) reduces the RDL (Report Definition Language) component to graphic icons in a GUI (Graphical User Interface). In this way, instead of writing code, the user can drag-and-drop graphic icons into an SSRS report format for most aspects of the SSRS report.

Reports defined by RDL can be downloaded to a variety of formats[2] including Excel, PDF, CSV, XML, TIFF (and other image formats[3]), and HTML Web Archive. SQL Server 2008 and 2012 SSRS can also prepare reports in Microsoft Word (DOC) format, while third-party report generators offer additional output formats.

Users can interact with the Report Server web service directly, or instead use Report Manager, a Web-based application that interfaces with the Report Server web service. With Report Manager, users can view, subscribe to, and manage reports as well as manage and maintain data sources and security settings. Report Manager can also deliver SQL reports by e-mail, or place them on a file share.

Security is role-based and can be assigned on an individual item, such as a report or data source, a folder of items, or site wide. Security roles and rights are inherited and can be overloaded.

Typically the reports are only revealed to users able to run them, and SQL connections in the source allow anyone to run with sufficient privileges. This is because configuring Windows Authentication through the reports execution is laborious and time-consuming: a Server Principal Name record (requiring DOMAIN ADMINISTRATOR access) is created in Active Directory associating the Sql Server Reporting service to the user the service runs under on the server (a network user to facilitate querying the Active Directory)... and the service account user has to have the delegation option enabled, the server must be trusted for delegation too; the windows users wishing to run reports must be set to allow delegation - so Kerberos authentication protocols will be used. The reporting service itself has to have the configuration edited to enable Kerberos protocols... but then the reports will be secure and only display data the individual users are permitted to (based on SQL security configuration).

RDL reports can be viewed by using the standalone Report Server that comes with Microsoft SQL Server, or by using the ASP.NET ReportViewer web control, or by using the ReportViewer Windows Forms control. The latter method allows reports to be embedded directly into web pages or .NET Windows applications. The ReportViewer control will process reports by: (a) server processing, where the report is rendered by the Report Server; or (b) local processing, where the control renders the RDL file itself.

SQL Server Reporting Services also support ad hoc reports: the designer develops a report schema and deploys it on the reporting server, where the user can choose relevant fields/data and generate reports. Users can then download the reports locally.

Microsoft SQL Server 2012 SP1 expands Microsoft support for viewing reports to mobile platforms, including Microsoft Surface, Apple iOS 6 and Windows Phone 8.[4]

Report Definition Language

[edit]

Report Definition Language (RDL) is a standard proposed by Microsoft for defining reports.[5] RDL is an XML application primarily used with SQL Server Reporting Services. It is usually written using Visual Studio, although there are also third-party tools; it may also be created or edited by hand in a text editor. SQL Server Reporting Services or other third-party reporting frameworks use RDL to define charts, graphs, calculations, text, images (through links), and other report objects and render them in a variety of formats.

There are three high-level sections in a typical RDL file:

  • Page style - The objects to display including fields, images, graphs, and tables.
  • Field definitions - The extended attributes of fields that are populated with formulas, dynamic data, or Database derived data.
  • Parameters and Database connections - Parameters that may be furnished by the user or passed in from another application; and database connections and queries for pulling data into the report.

Power BI Report Builder

[edit]
Microsoft Power BI Report Builder
DeveloperMicrosoft
Stable release
15.7.1814.616 / 25 March 2025; 18 months ago (2025-03-25)[6]
Operating systemWindows 10, 11

Power BI Report Builder is a variant of the SSRS application for building paginated reports,[7] with some features added and branded under the Power BI platform. The "Power BI Report Builder" application (not to be confused with "Report builder", the standalone SSRS tool) produces RDL reports (.rdl files, similar to SSRS), in contrast to the interactive .pbix files of regular Power BI reports (produced for example with the Power BI Desktop application). Similar to regular Power BI reports, paginated reports can also be published to the Power BI Service, and can also be connected to shared Power BI datasets. Paginated reports with Power BI Report Builder can be developed for free locally, but a Premium Power BI workspace is needed for publishing a report to the Power BI Service.[7] SSRS reports can be migrated to Power BI using the "Power BI Report Builder".[8]

References

[edit]
  1. ↑ Archiveddocs. "Reporting Services in SQL Server Express with Advanced Services". docs.microsoft.com.
  2. ↑ Capital), Ryan Majidimehr (H10. "ReportExecutionService.Render Method (ReportExecution2005)". docs.microsoft.com.{{cite web}}: CS1 maint: numeric names: authors list (link)
  3. ↑ Image Device Information Settings - SSRS can render BMP, EMF, GIF, JPEG, PNG, and TIFF.
  4. ↑ maggiesMSFT. "View Reporting Services Reports on Microsoft Surface Devices and Apple iOS Devices - SQL Server 2014 Reporting Services". docs.microsoft.com.
  5. ↑ Report Definition Language Specification
  6. ↑ "Microsoft Power BI Report Builder". Microsoft. Retrieved 2025-04-03.
  7. 1 2 Power BI Paginated Reports vs SSRS reports – It Ain’t Boring
  8. ↑ Migrate SQL Server Reporting Services reports to Power BI - Power BI | Microsoft Learn
[edit]

Source: Wikipedia. Article content is retrieved live through the MediaWiki API.

No preview image
Wikipedia

SQL Server Reporting Services

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services). Administered via a web interface, it can be used to prepare and deliver a variety of interactive and printed reports. The SSRS service provides an interface into Microsoft Visual Studio so that developers as well as SQL administrators can connect to SQL databases and use SSRS tools to format SQL reports in many complex ways. It also provides a 'Report Builder' tool for less technical users to format SQL reports of lesser complexity. SSRS competes with Crystal Reports and other business intelligence tools.

MORE →
No preview image
Wikipedia

Microsoft Analysis Services

Microsoft SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors multidimensional and tabular, where the difference between the two is how the data is presented. In a tabular model, the information is arranged in two-dimensional tables which can thus be more readable for a human. A multidimensional model can contain information with many degrees of freedom, and must be unfolded to increase readability by a human.

MORE →
No preview image
Wikipedia

Database server

A database server is a server which uses a database application that provides database services to other computer programs or to computers, as defined by the client–server model. Database management systems (DBMSs) frequently provide database-server functionality, and some database management systems (such as MySQL) rely exclusively on the client–server model for database access (while others, like SQLite, are meant for use as an embedded database). Users access a database server either through a "front end" running on the user's computer – which displays requested data – or through the "back end", which runs on the server and handles tasks such as data analysis and storage. In a master–slave model, database master servers are central and primary locations of data while database slave servers are synchronized backups of the master acting as proxies. Most database applications respond to a query language. Each database understands its query language and converts each submitted query to server-readable form and executes it to retrieve results. Examples of proprietary database applications include Oracle, IBM Db2, Informix, and Microsoft SQL Server. Examples of free software database applications include PostgreSQL; and under the GNU General Public Licence include Ingres and MySQL. Every server uses its own query logic and structure. The SQL (Structured Query Language) query language is more or less the same on all relational database applications. For clarification, a database server is simply a server that maintains services related to clients via database applications. DB-Engines lists over 300 DBMSs in its ranking.

MORE →
No preview image
Wikipedia

SQL Server Express

Microsoft SQL Server Express Edition is an edition of Microsoft's SQL Server relational database management system that is free to download, distribute and use. It comprises a database specifically targeted for embedded and smaller-scale applications. The product traces its roots to the Microsoft Database Engine (MSDE) product, which was shipped with SQL Server 2000. The "Express Edition" branding has been used since the release of SQL Server 2005. Microsoft SQL Server Express LocalDB is a version of Microsoft SQL Server Express, on-demand managed instance of the SQL Server engine. It is targeted to developers, and has the following restrictions: up to 50 GB database size and only local connections (network connections are not supported).

MORE →
TOPIC OF THE DAY

Greenwood / Black Wall Street

Before the 1921 destruction of Tulsa’s Greenwood District, Black residents had created a remarkable center of business and community life. The district included stores, professional offices, entertainment venues and homes owned by Black citizens. Understanding Greenwood means learning what was built—not only what was burned.

MORE →
TRIVIA QUESTION OF THE DAY

Which heavyweight champion was known as the “Brown Bomber”?

Joe Louis.