Carriage Returns Inside Database 1

[sabloomer]

Related to thread1462-1071902

I have an accouting system that stores addresses as a single field. When I create my data source and run it I can hover over the address field and the pop-up box shows the data with carriage returns. When I add the field to the report it flattens it out into a single line. Is there a way to format the box to use the carriage returns? Is there a way to search for "returns" and replace it with VBCRLF?

Thank You have much!

sabloomer

 

[xlbo]

Have you tried

=Replace(Fields!FieldName.value,"return",vbcrlf)

??

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[sabloomer]

I am not sure what to search for. When I look at it while creating my datasource for the report it shows two square boxes. I will see if I can figure out what SRS thinks those boxes are.

Thank You,

sabloomer

 

[xlbo]

squar boxes can be pretty much anything. If you can find the ASCII code for them, you may well be able to do something like

=Replace(Fields!FieldName.value,Asc(Ascii_Value),vbcrlf)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[sabloomer]

I will give that a try!

 

[sabloomer]

Geoff,

That worked like a charm. I was able to replace the mystery box character (carriage return) with a vbcrlf and it looks perfect.

=Replace(Fields!FieldName.value,chr(13),vbcrlf)

Thanks!

 

[xlbo]

excellent - thought it might but I'm always a little iffy with exactly what functions are available to RS...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question