Microsoft Report Viewer隐藏表中的空行

时间:2022-06-26 08:15:09

We use grouping to display master-detail report. If there are only nulls in a corresponding part of a report data source flat table, how can I not show empty records?

我们使用分组来显示主 - 详细报告。如果报表数据源平台的相应部分中只有空值,我怎么能不显示空记录?

1 个解决方案

#1


0  

If I understand correctly, you want to hide records in your report that have NULL values in one of the columns.

如果我理解正确,您希望隐藏报表中其中一列中包含NULL值的记录。

Is it an option to update your query to exclude these rows?

是否可以选择更新查询以排除这些行?

If this isn't an option, you can add a filter to the Dataset in the dataset property pages... you could use this filter to remove rows from the dataset that don't meet the criteria that you are looking for.

如果这不是一个选项,您可以在数据集属性页中向数据集添加过滤器...您可以使用此过滤器从数据集中删除不符合您要查找的条件的行。

#1


0  

If I understand correctly, you want to hide records in your report that have NULL values in one of the columns.

如果我理解正确,您希望隐藏报表中其中一列中包含NULL值的记录。

Is it an option to update your query to exclude these rows?

是否可以选择更新查询以排除这些行?

If this isn't an option, you can add a filter to the Dataset in the dataset property pages... you could use this filter to remove rows from the dataset that don't meet the criteria that you are looking for.

如果这不是一个选项,您可以在数据集属性页中向数据集添加过滤器...您可以使用此过滤器从数据集中删除不符合您要查找的条件的行。