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.