The Challenge: Securely Sharing Insights Beyond Your Office Walls
In today's interconnected business world, data shouldn't just live in a silo. You might have a perfectly tuned DevExpress dashboard showing inventory levels, but if your suppliers can't see it, they can't proactively restock your shelves. If your franchise partners can't see their performance metrics, they can't improve their sales. The real value of a dashboard is realized when it is shared securely with the people who need to act on it.
If you've been wondering "how to share a dashboard with suppliers" or how to distribute a live data view across a large organization without giving everyone full database access, this guide is for you. We will walk through building a dynamic dashboard and implementing a secure, token-based sharing mechanism.
Step 1: Building the Foundation (Sample Data & Charts)
Before we can share, we need something worth seeing. Let's start with a sample dataset for a Supplier Performance Dashboard. We'll use three primary tables: Suppliers, Orders, and Deliveries.
CREATE TABLE Suppliers (
SupplierID INT PRIMARY KEY,
SupplierName NVARCHAR(100),
Region NVARCHAR(50)
);
CREATE TABLE PurchaseOrders (
OrderID INT PRIMARY KEY,
SupplierID INT,
OrderDate DATETIME,
TotalValue DECIMAL(18, 2),
Status NVARCHAR(20) -- Pending, Shipped, Delivered
);
CREATE TABLE DeliveryPerformance (
DeliveryID INT PRIMARY KEY,
OrderID INT,
ActualDeliveryDate DATETIME,
OnTime BIT
);
Using the DevExpress Dashboard Designer, we can quickly wire up these tables to create a high-impact visual experience. For a supplier-facing view, we typically include:
- KPI Cards: "On-Time Delivery %", "Total Order Value", "Active Orders".
- Pie Chart: Distribution of orders by status.
- Line Chart: Monthly order value trends.
- Grid View: Detailed list of pending orders with drill-down capability.
98.5%
On-Time Rate
$1.2M
Pending Orders
42
Active Shipments
Monthly Fulfillment Performance
Step 2: Defining User Roles and Row-Level Security
When sharing a dashboard with suppliers, security is paramount. Supplier A must never see Supplier B's data. This is handled through User Roles and Parameters.
Administrator
Full access to all dashboards and all supplier data. Can manage sharing tokens.
Internal Manager
Can see performance for all suppliers but cannot modify the dashboard layout.
Supplier (External)
Can only see data associated with their unique SupplierID. Accessed via a secure link.
In DevExpress, we achieve this by using Dashboard Parameters. When a user logs in (or uses a share link), we pass their SupplierID as a hidden parameter to the SQL query: SELECT * FROM PurchaseOrders WHERE SupplierID = @SupplierID.
Step 3: Generating a Secure Share Link with a Long Token
For external partners like suppliers, you don't always want to manage a full username/password account in your AD or Identity system. This is where Long-Token Share Links come in.
Instead of a standard URL, you generate a unique, cryptographically secure link that looks like this:
https://yourportal.com/Dashboard/Public?token=a8f92b7c4e5102d83f4a96b7c012e34f56789abcd...
How it works:
- Generate: When you click "Share" in your admin panel, the system generates a long random string (GUID or JWT).
- Map: This token is stored in your database mapped to a specific
DashboardID,SupplierID, and anExpiryDate. - Validate: When someone visits the link, your controller validates the token, checks if it's expired, and then loads the dashboard with the pre-filtered
SupplierID.
public string GenerateShareLink(int supplierId, int dashboardId) {
string token = Guid.NewGuid().ToString("N") + Guid.NewGuid().ToString("N"); // Extra long token
var shareRecord = new DashboardShare {
Token = token,
SupplierID = supplierId,
DashboardID = dashboardId,
CreatedAt = DateTime.UtcNow,
ExpiresAt = DateTime.UtcNow.AddMonths(6)
};
_db.DashboardShares.Add(shareRecord);
_db.SaveChanges();
return $"https://portal.com/share/view?t={token}";
}
Step 4: Sharing Across the Organization
For internal distribution, the goal is visibility and accessibility. You want your dashboard to be where people already work.
- Microsoft Teams Tabs: Embed the DevExpress Web Dashboard as a custom tab in specific Team channels.
- SharePoint Embedding: Use an IFrame to show live metrics on the company intranet homepage.
- Automated PDF Exports: Use the
DashboardExporterto schedule weekly snapshots of the dashboard to be emailed to department heads.
Take Your Dashboards Global
By implementing secure tokens and role-based filtering, you transform your DevExpress dashboard from a local reporting tool into a strategic communication platform. Whether you are wondering how to share a dashboard with suppliers or looking to align your entire organization around the same KPIs, these patterns provide the security and flexibility you need.
Need help building a secure sharing portal?
I specialize in DevExpress development with over 10 years of experience building secure, high-performance dashboards for global logistics and manufacturing firms.
Let's Discuss Your Project