Default Values (Matrix Report)

Last Post 31 Mar 2005 09:25 AM by DiscGolfer. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
DiscGolfer
New Member
New Member

--
24 Mar 2005 05:36 AM
Hello All:
Is there a way to set a default value for a txtbox in a matrix report? I'm pulling insurance ($$)values from a table for certain locations, and for those locations that don't have any values I'd like the report to display '$0.00' rather than a blank-
Thanks-
Jim
hassima
New Member
New Member

--
29 Mar 2005 02:02 AM
Hello Jim
Yes, Using something like this :

=IIf( Sum(Fields!Amount.Value) = 0 , "$0.00", Sum(Fields!Amount.Value))

in the expression value.
DiscGolfer
New Member
New Member

--
31 Mar 2005 09:25 AM
Dude....you rock!! Thanks!
Jim
xfonhe
New Member
New Member

--
01 Apr 2005 05:55 AM
Don't forget to handle NULL values!

IIF(Fields!x.Value=Nothing,0,Fields!x.Value)

Note: it is also best practice to set the data type for the column, rather than leave all default text w/ user-provided formatting. Edit the properties of the column and set the data type to currency. All values will then default to $xx.xx
You are not authorized to post a reply.

Acceptable Use Policy