cancel
Showing results for 
Search instead for 
Did you mean: 

Superscript in Crystal reports 2016 formula

gh_cr05
Participant
0 Kudos

Hi

I have the following formula in a subreport: How can i make these symbols come up as superscript in a report? Thanks

If ({TEST.COL1} = "F" and (isNull({TEST.COL2})  or {TEST.COL2} = "NONE")) then 
    " * " 
Else IF ({TEST.COL2} = "EXT" ) then
    "## "

Else ""
DellSC
Active Contributor
0 Kudos

Is this a subreport just to get this value? Or do you want to display this value as a superscript for another value in the subreport?

gh_cr05
Participant
0 Kudos

This gets appended to another text in the subreport.

Accepted Solutions (0)

Answers (2)

Answers (2)

gh_cr05
Participant
0 Kudos

I have attached 2 images. The first pic shows the output where there is a double hash followed by some text. The double hash comes from a formula called accredited which is in the second pic.

If ({TEST.COL1} = "F" and (isNull({TEST.COL2})  or {TEST.COL2} = "NONE")) then 
" * "
Else IF ({TEST.COL2} = "EXT" ) then
"## "
Else ""

How do i amend the formula to show the double hash as a superscript? I am not sure if moving the base slightly lower or moving the symbols slightly higher and with a smaller font will make the report look great and it will take more space.

Regards

Geeta

ido_millet
Active Contributor
0 Kudos

If the position of the superscript is static, you can simply nudge the formula higher a bit relative to the "base" content.

If the "base" content position is not static, you would probably need to use a UFL for this.

To make it easier to answer, consider describing the "Base" content and show an image demonstrating the desired output.