Rotating text 1

[peterswan]

hello,

I've got 20 catagories I want to fit across the top of a report, all of which fit into a group. I'll have to rotate the labels in order to get them to fit. I know I can rotate 90 degrees, and this would look fine, but I think it would look more legible if I rotated the text 45 degrees, and displayed them at a diagonal angle.

Is there any way to do this in CR?

Thanks for any help,

Peter Swanson

 

[synapsevampire]

I think that you'd have to place an external object (image, ole object...)in to accomplish this, and that might wreak havoc with exporting, but it's an option.

For instance, create rotated text in Word, copy and paste it.

Otherwise 90 and 270 are the CR options.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[goranm]

Hi !

Is this maybe a solution ?

Create a formula field as your Heading like this:

'H' + CHR(13) + ' E' + CHR(13) + ' L' + CHR(13) + ' L' + CHR(13) + ' O'

Select a fixed font type (like Courier).
Format the field with "Can Grow".

This will make the text "HELLO" appear diagonal.

/Goran

 

[peterswan]

Synanpse Vampire's solution worked great. I went to Insert / OLE Object, then Microsoft Word, then WordArt, and created several Text images and rotated them 45 degrees. I then placed the OLE Object into the group header. It printed up fine, with very good legibility.

I also tried Goran M's idea. This looked cool and would work fine for shorter labels. Some of my labels were 25 characters long.

Thanks to all who helped on this one,

Peter Swanson

 

[synapsevampire]

Goranm: I thought about that idea, But I feared weird displays because most fonts are proportional, so the spacing won't align quite right, and exporting will be problematic.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[peterswan]

Hi Synapse Vampire,

Notice how Goran M says to use a fixed font like Courier, which is what I used as a test. This way a space will have the same distance as a character of text. If you try out his example, you'll notice the characters are perfectly spaced.



Peter Swanson

 

[mbarron]

Building off of Goranm's post:
Just create this as a text box, resize it to one character wide using the fixed width font and set it to can grow.

There is no need for a formula since you've already limited the field to one character wide, the next letter goes to the next line. Mike

Before: After

 

[goranm]

Hi Mike!

If you limit the box to one character wide I don´t think you will have the diagonal thing with the text that Peter wanted to achieve.

/Goran

 

[mbarron]

I have start reading the entire post.

Because I love to play :
Here's a formula that'll work for up to 21 charatcters in CR8 and 8.5 -- CR9 can handle more.

stringvar header:="Up to 21 characters";
numbervar loop;
numbervar loopnum:=length(header);
stringvar out;
stringvar hold;
for loop:= 1 to loopnum do(
stringvar return;
if loop=loopnum then return:="" else return:=chr(13);

(out:=replicatestring(" ",loop-1)+header[loop] ;
hold:=hold+out+return));
hold
Mike

Before: After

 

[goranm]

Hi Mike !

That´s a good one.

/Goran