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!
-
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!
Recent content by 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...- sfujii
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
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...- sfujii
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
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...- sfujii
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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!- sfujii
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
