Conditional Formatting 1

[gooseriver]

In Crystal can we use conditional formatting. I have a string and would like to make specific phrases bold in a string ie: If {Table1.Memo} in ("<" to ">") then formula = crBold

 

[lbass]

What are you trying to bold here? If you are trying to bold the signs only, then use a formula like this (with Crystal syntax):

replace(replace({table.memo},' > ','<b> > </b>'),' < ','<b> < </b>')

It is important to use the spaces before and after the signs--otherwise the signs in the HTML tags get replaced. You have to format the formula to paragraph->text interpretation->HTML. Of course whether you can work with a memo field in a formula depends upon your version which you should always identify.

-LB

 

[gooseriver]

I am using CR10nd would like to put any text between the < and > will be bold..

 

[dgillz]

Did you try LB's formula?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

Please show a sample of the current field and how you would want it to look. I'm unclear on whether you want to see the < and >, and if you do, whether you want them bolded, too. The following will include the signs in bold:

left({table.memo}, instr({table.memo},"<")-1)+
"<b>"+"<"+extractstring({table.memo},"<",">")+">"+"</b>"+
mid({table.memo}, instr({table.memo},">")+1)

In future posts, please try to provide more specifics in your initial post.

-LB

 

[gooseriver]

I created a formula with the following:

@Test1
"this is a <test> for CR"

Then a second formula with the following:
@Test2
left({@Test1}, instr({@Test1},"<")-1)+
"<b>"+"<"+extractstring({@Test1},"<",">")+">"+"</b>"+
mid({@Test1}, instr({@Test1},">")+1)

At this point @Test2 should return "this is a <Test> for CR" with Test apperaing in bold..

This did not work..

 

[dgillz]

As LB indicated, you have to format the formula to paragraph->text interpretation->HTML.

Did you do this?


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

Try this:

stringvar x := replace(replace({table.memo},"<","< "),">"," >");
left(x, instr(x,"<")-1)+
"< "+"<b>"+extractstring(x,"< "," >")+"</b>"+" >"+
mid(x, instr(x,">")+1);

This will return:

"this is a < Test > for CR"

Do you really want to show the symbols? The issue is that without the space, the symbols are interpreted as belonging to the HTML tags.

The following would bold without the symbols showing:

stringvar x := replace(replace({@table.memo},"<","< "),">"," >");
left(x, instr(x,"<")-1)+
"<b>"+extractstring(x,"< "," >")+"</b>"+
mid(x, instr(x,">")+1);

This would return:

"this is a Test for CR"

-LB

 

[gooseriver]

Wow I have worked with cr for 10+ years since the seagate days and never used this before... Thanks worked like a charm..

 

[gooseriver]

if there is no < or > in the field how do I handle the formula... I get String length is less than 0 or not an integer

 

[lbass]

Add a clause like this:

stringvar x := replace(replace({table.memo},"<","< "),">"," >");
if instr(x,"<") = 0 then
{table.memo} else
left(x, instr(x,"<")-1)+
"<b>"+extractstring(x,"< "," >")+"</b>"+
mid(x, instr(x,">")+1);

This assumes that these symbols always appear in pairs.

-LB

 

[gooseriver]

The bold formatting works fine but for some reason the paragraph is being truncated....

 

[gooseriver]

Strange not hasppening for all the fields... Why this one..

 

[gooseriver]

When I set the formula to Text Interpretation = HTML it truncates the actual data. If I set the Text Int to None the data is no longer truncated...

Help me here please..

 

[lbass]

You could try a different approach where you break the field into three segments and drop each into a text box. You could then bold the middle segment by selecting it->right click->format text->font style->bold.

//{@Segment1}:
if instr({table.field},"<") <> 0 then
left({table.field}, instr({table.field},"<")) else
{table.field}

//{@Segment2}:
if instr({table.field},"<") <> 0 then
extractstring({table.field},"<",">")

//{@Segment3}:
if instr({table.field},">") <> 0 then
mid({table.field},">")

-LB