Field values in a row not lining up

  • All -

    I have a report that outputs lines of data. The data is correct, but there is one field that prints out like it has a return character in front of it. I trim the field before I get it from the stored procedure, so it shouldn't. The rest of the fields all line up but this one does not. First, it doesn't look right. But the bigger problem is that the users export the data to Excel and when they export it each line exports to two lines in Excel because the one field goes on a separate line. Any ideas?

    I have tried:

    1) The Trim function within the report and it doesn't work.

    2) Changing the Vertical Align of the cell and that doesn't work either.

    3) I made sure the padding is the same as the other fields on the row and that does not help either.

    4) I tried creating a new column with the same field and received the same results.

    Any help would be appreciated.

    Thank you.

    Tammy

  • Figured I could add a picture. So here it is (hope it works).

  • Did you try using something like REPLACE(REPLACE(YourField,CHAR(10),''),CHAR(13),'')

    to modify the field from within the report query?

  • Thank you OldHand. That worked. I should have known to try that. I have had to use that cleanup of fields before.

    If I can award points or mark your answer as the solution, please let me know. I don't know how to do that if it is an option.

    Tammy

  • You're welcome, Tammy. Happy to help. 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply