Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sfujii

    Numerical Field Output

    Sorry I'm using CR .NET and an access database. In my program, if I type in 99.9999, 149.999, 99.9993, the output in crystal reports are those numbers. If I type in 149.9999 or 149.9993, I get 150 or 149.9990 respectively. I had just plugged in the field into my crystal report, right clicked...
  2. sfujii

    Numerical Field Output

    Hi, I have a field which is typically contains a number xyz.abcd Running my crystal report, if "d" was 5 or higher, the number was rounded up. If "d" was 4 or lower, "d" takes on the value of zero. This seems to be a problem with how big the number is. The field itself has "single" as a...
  3. sfujii

    Null Case and Numerical Field

    Hi, I have a numerical field populating a crystal report. I wrote a formula like the following: If (tbl.field) = "" then "" else CStr(tbl.number) so that tbl.number will be empty when tbl.field is null and a number otherwise. tbl.number has three decimal points but since I had to convert it...
  4. sfujii

    Displaying Records Horizontally in Crystal Reports .NET

    Hi, I'm trying to get records to display horizontally all on one line separated by a comma, instead of the vertical default. Could someone help me out? NY NJ -> NY, NJ, CT CT TIA!

Part and Inventory Search

Back
Top