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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
help on concatenated address formula
thank you for your help. the bldg number was not a string, so we ended up with this - IF isnull({WKWOWHYD.WHY_AD_BDG}) then {WKWOWHYD.WHY_AD_STR} else (Replace(Replace(CStr({WKWOWHYD.WHY_AD_BDG}),',',''),'.00','') & " " & {WKWOWHYD.WHY_AD_STR}); i didn't know about the replace...- Wahine
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
help on concatenated address formula
i am trying to do two things - first, i want to format an address bldg number to have no decimals, no comma separator, then, i want a formula that will return only the street name if the bldg number field is empty, otherwise return the concatenated address. this formula - Local StringVar...- Wahine
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Why does my subreport (memo field) cut off , not wrap?
I am having trouble figuring out why my subreport, a memo field, doesn't stay within the borders of the object box in the design view of my report when I view it in my program. The text chops off, rather than wrapping. Actually, part of the memo gets lost and part does wrap.The report looks just...- Wahine
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
