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 |
|
latingntlman
Yak Posting Veteran
96 Posts |
 Posted - 2008-05-09 : 14:19:37
|
| I've gotta a count field passed from SQL stored proc, and I've included Isnull(count(field,0),But when I bring it into the rpt and display it, the rows that have zero values from the data view and running the sql query are actually shown as blank in the preview view.Do I need to add some other syntax to get it to display as zero when there are no values?thx,John |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-10 : 03:16:20
|
| What is the value you are getting when you run sp in data tab? 0 or blank value? |
 |
|
|
|
|
|
Zero value displayed as space