Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Field values in a row not lining up Expand / Collapse
Author
Message
Posted Wednesday, July 31, 2013 9:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 26, 2013 9:58 AM
Points: 19, Visits: 71
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
Post #1479560
Posted Wednesday, July 31, 2013 10:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 26, 2013 9:58 AM
Points: 19, Visits: 71
Figured I could add a picture. So here it is (hope it works).



Post #1479576
Posted Thursday, August 1, 2013 6:43 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
Did you try using something like REPLACE(REPLACE(YourField,CHAR(10),''),CHAR(13),'')
to modify the field from within the report query?
Post #1479909
Posted Thursday, August 1, 2013 5:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 26, 2013 9:58 AM
Points: 19, Visits: 71
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
Post #1480223
Posted Friday, August 2, 2013 6:29 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
You're welcome, Tammy. Happy to help.

Post #1480356
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse