Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1659
  • Last Modified:

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.
0
yingchunli
Asked:
yingchunli
  • 7
  • 6
1 Solution
 
mlmccCommented:
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
0
 
yingchunliAuthor Commented:
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?)
0
 
mlmccCommented:
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
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
mlmccCommented:
Here it is

mlmcc
SUperscriptReport1.txt
0
 
yingchunliAuthor Commented:
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.
0
 
mlmccCommented:
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
0
 
yingchunliAuthor Commented:
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];


0
 
mlmccCommented:
DO you need help building the report?

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

mlmcc
0
 
yingchunliAuthor Commented:
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.

0
 
mlmccCommented:
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
0
 
yingchunliAuthor Commented:
mlmcc,

Please also show me the "trick" step by step, together with the sample report. Thanks.
0
 
mlmccCommented:
Save the attached file and change the extension to .RPT

Note the 2 sets pf text boxes in design.

Each line that has a superscript needs 2 boxes - size them the same for width
Box 1 - The field or text for the report
Box 2 - A text box with 3 entries
     The same field yoiu are superscripting.  FOrmatted with text color matching the background
     A blank space or 2 for appearance
     A formula with the superscript value - Formatted to a smaller size than the text.

Box 2 is place slightly above box 1 with the left sides aligned.  
I find placing box 2 bottom at the middle of box 1 works well.

mlmcc

SuperScriptReport1a.txt
0
 
yingchunliAuthor Commented:
mlmcc, the result is exactly what I wanted. Thanks for your help.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now