I have this formatting issue in the crystal report, I hope someone must have resolved this one.
I have a column “Part Name” which is having many different values, sometimes it is having only one word part name, sometimes it is having 2-3 lines long part name. I want to show blank line when part name is small(like in this example) I want to have multiple lines, and when part name is long, then blank line should be used for the part name.
Part Name:_ A1 ID CLUTCH#2______________________________________________________________________________________________________
justdesi,
My solution requires that the data be padded with an _ like in your example. If it is Space padded then you will need to replace each space with an _ and then code the following in a Crystal Formula
We are coding for a fixed length file using variable length data and pad each field to the correct length in our stored procedure. The above code replaces the _ with a space. Crystal in it’s infinite wisdom truncates space at the end of data fields so the _ needs to be passed.
justdesi,
My solution requires that the data be padded with an _ like in your example. If it is Space padded then you will need to replace each space with an _ and then code the following in a Crystal Formula
We are coding for a fixed length file using variable length data and pad each field to the correct length in our stored procedure. The above code replaces the _ with a space. Crystal in it’s infinite wisdom truncates space at the end of data fields so the _ needs to be passed.
Thanks “amosgreg” for replying back. Actually In my case, I think padding won’t work because I need “" for continuous 3 rows, and if the data is available , it should come on top of the "”.
So you are saying that you want an Underline for x bytes. And if text is present then you want the text underlined followed by the remainder of space underlined? Is that what the requirement is?
I haven’t tried to solve for that issue but in ours we query the DBA_TAB_COLUMNS for the length of our data DBA_TAB_COLUMNS. We then use this value to set the length of padding or 0 fill numerics. Our fields are VARCHAR without spaces but they can easily be removed and length calculated.
Crystal has Underline as an avaliable effect under the format field option. You should be able to apply it for the length of the data element and concatinate the underbar for the remainder of the length of your field requirement.
I hope that helps.