Solved

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

Posted on 2008-06-19
13
1,469 Views
Last Modified: 2012-06-22
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
Comment
Question by:yingchunli
  • 7
  • 6
13 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 21827460
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
 

Author Comment

by:yingchunli
ID: 21831707
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 21836461
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 21836509
Here it is

mlmcc
SUperscriptReport1.txt
0
 

Author Comment

by:yingchunli
ID: 21847491
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 21848933
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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:yingchunli
ID: 21849180
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 21850087
DO you need help building the report?

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

mlmcc
0
 

Author Comment

by:yingchunli
ID: 21850319
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 21851203
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
 

Author Comment

by:yingchunli
ID: 21851227
mlmcc,

Please also show me the "trick" step by step, together with the sample report. Thanks.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 21851273
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
 

Author Closing Comment

by:yingchunli
ID: 31469006
mlmcc, the result is exactly what I wanted. Thanks for your help.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now