如果数据集为空,则无法通过SSRS嵌套报告

如果没有数据,可以插入“虚拟”记录。假设您当前的查询是:

SELECT ID
    , [Name]
    , [FavoriteFruit]
FROM yourTable
WHERE [SomeField] = 'hello'

您可以检查值并返回一个伪记录,如:

IF EXISTS(
    SELECT 1
    FROM yourTable
    WHERE [SomeField] = 'hello'
    )
    SELECT ID
        , [Name]
        , [FavoriteFruit]
    FROM yourTable
    WHERE [SomeField] = 'hello'
ELSE
    SELECT ID = 0
        , [Name] = 'No data'

检查 Row Exists

    IF NOT EXISTS(SELECT 1 FROM table)
     BEGIN
          SELECT Column from table
     END        
  ELSE
     BEGIN
          SELECT 'No records' as Column from table
     END

Tablix Properties > Visibility > Show or Hide Based on Condition

添加 TextBox 带文本 'No records found' 并根据数据集结果添加要显示的条件。