This article is about handling display of report items like chart , table or matrix when there is no data
returned from the dataset .
For example :
Consider below query is my dataset :
I have table & column chart on the report body , when I preview the report and enter MonthNo =12 and click on View report
returned from the dataset .
For example :
Consider below query is my dataset :
DECLARE @SalesbyMonth TABLE (Months VARCHAR(20),Sales INT,MonthNo INT) INSERT @SalesbyMonth SELECT 'January',1000,1 INSERT @SalesbyMonth SELECT 'February',100,2 INSERT @SalesbyMonth SELECT 'March',100,3 INSERT @SalesbyMonth SELECT 'April',200,4 INSERT @SalesbyMonth SELECT 'May',500,5 INSERT @SalesbyMonth SELECT 'June',800,6 INSERT @SalesbyMonth SELECT 'July',500,7 INSERT @SalesbyMonth SELECT 'August',100,8 INSERT @SalesbyMonth SELECT 'September',900,9 INSERT @SalesbyMonth SELECT 'October',600,110 INSERT @SalesbyMonth SELECT 'November',100,11 INSERT @SalesbyMonth SELECT 'December',100,12 SELECT * FROM @SalesbyMonth WHERE MonthNo = @MonthNo
I have table & column chart on the report body , when I preview the report and enter MonthNo =12 and click on View report