Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
balajii78
Starting Member
13 Posts |
 Posted - 2006-09-07 : 01:23:04
|
| hi peso, Can u help me by giving source code/procedure as to how give the message "No records found" when there are no records retrieved for a query in reporting services? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-07 : 02:23:05
|
| You have to do that in your stored procedure. Save the result of the query in a temporary table, check if the are any rows in the table and if so, select to rows from the temporary table. If there are no rows, select 'No records found' as the result instead. Please beware that you must output the same number of columns as the original query does.Peter LarssonHelsingborg, Sweden |
 |
|
|
balajii78
Starting Member
13 Posts |
Posted - 2006-09-11 : 10:10:55
|
quote:
Originally posted by Peso
You have to do that in your stored procedure. Save the result of the query in a temporary table, check if the are any rows in the table and if so, select to rows from the temporary table. If there are no rows, select 'No records found' as the result instead. Please beware that you must output the same number of columns as the original query does.Peter LarssonHelsingborg, Sweden
thanx for the suggestion can u help me by sending the code? |
|
|
|
balajii78
Starting Member
13 Posts |
Posted - 2006-09-11 : 10:12:33
|
| thank u man ..can u help me by sending a sample code? |
|
|
|
|
|
|
reporting services