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.

 All Forums
 Development Tools
 Reporting Services Development
 clarification in reporting services

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
Go to Top of Page

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 Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -