Prev: format in text boxes
Next: Matrix Columns
From: Wendy Elizabeth on 27 Feb 2010 13:17
In sql server report 2005 (SSRS 2005), I will be generating some reports
that may not have any data selected at times. This can you can tell me how
can you display a message like 'The report is not generated since no records'
were selected for this report. Can you tell me how to solve this problem
either with sql and/or a sql server report 2005? If not no is selected, what
will sql server report display? Would it display anything at all!
From: sriram on 28 Feb 2010 00:15
You can have a default row that says "No data for this month" and use
an iif statement to suppress it if there is data in the report.(can
implement this in source or put a union all query to add this record)
In Properties, Under visibility on the hidden row,have an expression.
IIF(Fields!Sales.Value = "",False,True) Use a field that will always
have data if it is available.

Sriram
www.sqllike.com
From: Kiwi_smith on 28 Feb 2010 14:26
Use the NoRows table property to enter whatever text you want to display when
there are no records in your data set

"Wendy Elizabeth" wrote:

> In sql server report 2005 (SSRS 2005), I will be generating some reports
> that may not have any data selected at times. This can you can tell me how
> can you display a message like 'The report is not generated since no records'
> were selected for this report. Can you tell me how to solve this problem
> either with sql and/or a sql server report 2005? If not no is selected, what
> will sql server report display? Would it display anything at all!
 | 
Pages: 1
Prev: format in text boxes
Next: Matrix Columns