Susan Geller
sgeller at cce.umn.edu
Mon Dec 8 17:50:20 CST 2003
When I change the formatting from #,### to #,##0 I see zeros. Thanks much! --Susan -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco H Tapia Sent: Monday, December 08, 2003 12:54 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer]Zeros not showing up on a report In my situation w/ Access 2000, they show up and my boss doesn't want to see them :D. But what you might want to check is in the report what the fields are formatted as, generally you can just format it to general and that ought to do it it, if not in the format property add a 0 and see if that takes care of it. -- -Francisco Susan Geller wrote: >ADP in Access XP (2002 format). I have a report whose record source is >a sproc that does some summing. All is well except that "0" does not >show up on the report. All other values show up. I have similar >problems before and have always been able to solve them by explicitly >casting the fields in the sproc as decimals. In the past I've seen >this more in that if I didn't cast as such, the report couldn't add >values like in a group footer. When I run the sproc from the adp I see >the zeros. It's only on the report that I don't see them. I've tried >using the nz function on the report and that doesn't work. And, I've >tired using an IIF to evaluate for zero and that doesn't work. So, >they aren't coming through as zero or as null. Ideas? > >--Susan > > >Susan B. Geller > > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com