Need A formula where part of the formula is right aligned

[AnnetteB1305]

Hello,

I have a formula which is
@customersite {opencall1.cust_name} +" "& {opencall1.site}

However I want to right align the {opencall1.site}

I have to put this into a crosstab so I can't do this in 2 fields and have to use a formula.

Is this possible either using something in the formula or with spacing?

Thanks,
Annette

 

[MCuthill]

Annette,

I do not have Crystal in front of me, so I apologize if this idea doesn't work. I am wondering if you can "work around" the issue with the structure of your Cross-tab.

If your rows were defined as:
Row-Level 1: {opencall1.cust_name} &" "& {opencall1.site} [blue]*suppressed* (if able)[/blue]
Row-Level 2: {opencall1.cust_name} [blue]*Left-Align*[/blue]
Row-Level 3: {opencall1.site} [blue]*Right-Align*[/blue]

I think then using suppression on sub-total rows and the left-most column (if able) you can get the results you seek. If it s bit crude and perhaps another member has a cleaner solution (assuming the above works, of course).

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[AnnetteB1305]

I'll give it a whirl and let you know.

Thanks,

Annette

 

[AnnetteB1305]

It worked, Thank you. I had to suppress subtotals too in the format crosstab but that worked.

Thank you very much

Annette

 

[MCuthill]

Excellent! You are most welcome.

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."