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 John Tel 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: *

  • Users: sfujii
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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