Homogenous column elements between drop pages

[rkazi44]

How to force full axis population for Drop Column Elements across Drop Page Elements in Seal Report

Body:
I have a report in Seal Report where:

The Drop Page Element lists Customers.

The Drop Column Elements list months (formatted as yyyy-MM — e.g. 2025-01, 2025-02, etc).

The issue I am running into is that some customer pages do not include all months.
For example:

Customer #1 page includes 2025-01, 2025-02, 2025-03

Customer #2 page only includes 2025-01, 2025-03 (because there was no data for 2025-02 for this customer)

I would like to know:

Is there a way to force Seal Report to include all the months for every Drop Page Element (customer), even if there’s no data for that month?

My goal is to have consistent column structure across all customers — always showing the full set of months, even if some months have no data for a particular customer.

Here’s my current SQL for the Model:

SELECT
  SO_Header.Customer AS C0,
  FORMAT(SO_Detail.Promised_Date, 'yyyy-MM') AS C1,
  SO_Detail.Sales_Order AS C2,
  SO_Detail.Material AS C3,
  SO_Detail.Order_Qty AS C4,
  SUM(SO_Detail.Total_Price) AS C5
FROM 
  (SO_Header RIGHT OUTER JOIN SO_Detail
   ON SO_Header.Sales_Order = SO_Detail.Sales_Order)
WHERE 
  (SO_Detail.Status LIKE '%Open%' OR SO_Detail.Status LIKE '%Backorder%')
GROUP BY 
  SO_Header.Customer, 
  FORMAT(SO_Detail.Promised_Date, 'yyyy-MM'),
  SO_Detail.Sales_Order, 
  SO_Detail.Material, 
  SO_Detail.Order_Qty
ORDER BY 
  SO_Header.Customer ASC,
  SO_Detail.Order_Qty ASC,
  FORMAT(SO_Detail.Promised_Date, 'yyyy-MM') ASC

Here’s a screenshot of what my View configuration currently looks like:

Any guidance on how to achieve full month enumeration across pages would be greatly appreciated!

[ariacom]

Did you check check:

[rkazi44]

Yes. I have since created a custom enumerated list. That contains the months I want to use.
This is the query I am using for that list:

SELECT DISTINCT
  CASE 
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) < 0 THEN 'Past Due'
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 0 THEN FORMAT(GETDATE(), 'MMM-yyyy')
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 1 THEN FORMAT(DATEADD(MONTH, 1, GETDATE()), 'MMM-yyyy')
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 2 THEN FORMAT(DATEADD(MONTH, 2, GETDATE()), 'MMM-yyyy')
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 3 THEN FORMAT(DATEADD(MONTH, 3, GETDATE()), 'MMM-yyyy')
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 4 THEN FORMAT(DATEADD(MONTH, 4, GETDATE()), 'MMM-yyyy')
    ELSE 'Future Due'
  END AS Months,
  CASE
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) < 0 THEN 'Past Due'
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 0 THEN FORMAT(GETDATE(), 'MMM-yyyy')
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 1 THEN FORMAT(DATEADD(MONTH, 1, GETDATE()), 'MMM-yyyy')
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 2 THEN FORMAT(DATEADD(MONTH, 2, GETDATE()), 'MMM-yyyy')
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 3 THEN FORMAT(DATEADD(MONTH, 3, GETDATE()), 'MMM-yyyy')
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 4 THEN FORMAT(DATEADD(MONTH, 4, GETDATE()), 'MMM-yyyy')
    ELSE 'Future Due'
  END AS Months1,
  CASE 
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) < 0 THEN -999
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 0 THEN 0
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 1 THEN 1
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 2 THEN 2
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 3 THEN 3
    WHEN DATEDIFF(MONTH, SO_Detail.Promised_Date, GETDATE()) = 4 THEN 4
    ELSE 999
  END AS SortOrder

FROM SO_Detail
ORDER BY SortOrder

And here is a screenshot of the generated list:

Here is a screenshot of the current configration:

This works correctly when I move Customer down to a Drop Row Element and adding a restriction to a customer that I know doesn't have any Sales Orders for that month. (The months will display as a Drop Column Element even if they are empty):

However, when Customer is moved back up to a Drop Page Element, it will no longer display each of the empty months when I toggle between customer tabs: