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-04 : 02:12:56
|
hi folks, Im T.Balaji.Ive a clarification.If there are no records found for a query specified in the data tab of a report then how to display a valid message in the preview tab.Can anyone help me find a solution? |
|
balajii78
Starting Member
13 Posts |
Posted - 2006-09-04 : 02:35:21
|
test reply from balaji |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 06:18:36
|
Serverside, you can use EXISTS keyword to send a row with "Information not available at this moment?" if there is no rows, otherwise send the real data. Of course the two different resultsets must have equal number of columns and datatypes.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|