Formulaic text rotation?

[ImArchimedes]

Is this possible? I was looking through functions and scowering the internet looking for this and no luck. To give you a better idea of what I'm looking for, here's an example.

Say I want to print field_1 going left to right when field_2 = "L2R" and top to bottom (270 degrees) when field_2 = "T2B". If the function to rotate were "rot(degrees,string)" then my formula would look something like this:

if {field_2}="L2R" then {field_1} else
(if {field_2}="T2B" then rot(270,{field_1}));

Can this be done?

Thank you all in advance for any help you can provide.

 

[CoSpringsGuy]

Would this field be in the details section or in a head?

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[ImArchimedes]

It could be in either. If you know a way for it to work in either one or both, I'd be ecstatic.

 

[lbass]

There is no option for conditional rotation in XI or lower. You could create two versions of rotation in different sections and then conditionally suppress the sections.

-LB

 

[CoSpringsGuy]

What I did was create two fields...... place them in the report where you want them aligned etc... etc.... I did this in the detail section to make sure it worked ok

on one one right click and select format field ... select the common tab and rotate it 270 degrees ...
also under the common tab .. click the formula icon next to suppress and use the criteria you want if the field is not to be displayed at 270

on the other field do the opposite.

If the returned field is going to be large it will throw the look of your report off. In that case Lbass suggestion may work better...

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[ImArchimedes]

LBass and CoSpringsGuy,

That's actually exactly what I did. Just odd that there isn't a function for that in a formula. I feel alright doing it now though, knowing that others used the duplicate field version to get around it. There should be a better way but this is definitely functional.

Thanks again all for your input.