I have a sql stored proc that will display 0's for months that do not have data in SSMS.
On my webfocus report, it will NOT display the same information as my sproc does.
Does anyone know why webfocus will not display my 000000????

SSMS:
Month_Year TotalMB
January 2015 0.00000381
February 2015 0.00000000
March 2015 0.00000000


IS There a setting or command/function that makes user unfriendly webfocus not display what SSMS does?

Webfocus report:

Month_Year TotalMB
January 2015 0.00000381

Can anyone tell me why these would b different when I pass in the same parameters on both level.

Thank u very much

This message has been edited. Last edited by: <Kathryn Henning>,

A WHERE clause might do that. SET SHORTPATH=FOCUS might do that. Set ALL=OFF might do that. SET SSMS=BADFOCUS! might do that.

Or format that field with Zero Suppression.