Link to home
Start Free TrialLog in
Avatar of yingchunli
yingchunliFlag for Canada

asked on

how to put superscript to the end of a text line?

In the crystal report, I have a table of text lines with different length of text body. I need to place the text lines left justified and add superscripts to the end of the text lines. Please tell me how to do it.
Avatar of Mike McCracken
Mike McCracken

Crystal doesn't support a suprescript.  I just tried doing that last night.

I resolved this by using a text box for the text line then adding a formula to the textbox.  The formula was simply a (1) or *.  I formatted the formula to use a smaller font.  It looks a bit like a superscript.

mlmcc
Avatar of yingchunli

ASKER

mlmcc, thanks for the comment. Could you please show me by an example? Say, I have two text lines: "Line one" (with superscript '"1") and "this is a relatively long line for the test" (with superscript "2, m"). I need these two lines of text left-justified in a table.

(Could you please send me a screen-shot of the crystal report for the above simple example at <email removed mlmcc>, if possible?)
Solution via email is not allowed under EE rules.  I removed your email because these pages get searched for email addresses.

I'll try to put it together and attach it here.

mlmcc
mlmcc,

I am not able to open the "SUperscriptReport1.txt" file. I would like to get a screen-shot picture file to show the results, and the very line(s) of code "adding a formula to the textbox". Thanks.
DId you change the extension to RPT and open it in Crystal?

Here is another thin to try.  It works great.

Add a text box to your report.
Drag another copy of the field you want with the superscript onto the report
Right click it
CLck FORMAT
Set the font color to match the report background.

Drag it into the text box
Drag the formula for the superscript character into thetext box

Set the new textbox slightly above the field you need the superscript on
Align the 2 fields on the left margin

mlmcc
mlmcc, thanks. I do not have the environment to create and view crystal report yet -- I  just need  to prove (for decision making) the concept and make sure it works:  I need to put the following three LEFT-JUSTIFIED text lines (for example) into a table in the Crystal report.

  First line[superscript a];
  Second line which is relatively longer[superscript b];
  Third line short[superscript c, d];


DO you need help building the report?

Does it need to run from a database or will text fields suffuce?

mlmcc
Mlmmc,

I just have problem with  the left-justified text lines of different length with superscript on the end of the text line in the report. It will be enough If you can shown me the key code to do this and show me (by a picture?) that the result is as expected. Thanks.

There isn't a key code, there is a trick to make it happen.

I'll create a sample report and you can see how to do it.

mlmcc
mlmcc,

Please also show me the "trick" step by step, together with the sample report. Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
mlmcc, the result is exactly what I wanted. Thanks for your help.