Solved

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

Posted on 2008-06-19
13
1,565 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 101

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 101

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
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

 
LVL 101

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 101

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
 

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 101

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 101

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 101

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

696 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