Oct 12, 2009 #1 pj2256 Programmer Oct 12, 2009 6 0 0 US My report is giving me a whole number for a person's weight. How do I format it to pounds?
Oct 12, 2009 #2 CoSpringsGuy IS-IT--Management Aug 9, 2007 955 0 0 US does the whole number represent ounces and you need that converted? show your raw data and what you want it to look like on the report _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection Upvote 0 Downvote
does the whole number represent ounces and you need that converted? show your raw data and what you want it to look like on the report _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection
Oct 12, 2009 Thread starter #3 pj2256 Programmer Oct 12, 2009 6 0 0 US I am getting 2,800.00 or 3,500.00 as the weight. Upvote 0 Downvote
Oct 12, 2009 1 #4 lbass Technical User Feb 9, 2002 32,816 0 36 US You really should find out what the number represents before moving forward, but it looks like it might be ounces, so you would just use: {table.number}/16 -LB Upvote 0 Downvote
You really should find out what the number represents before moving forward, but it looks like it might be ounces, so you would just use: {table.number}/16 -LB
Oct 12, 2009 Thread starter #5 pj2256 Programmer Oct 12, 2009 6 0 0 US I checked and it is ounces. I entered the above and got the # in pounds. Thanks for your help. Upvote 0 Downvote